 | |
#21
 
| |||
| |||
|
Re: Change datadir -
05-26-2008
, 01:39 AM
|
What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. Stop the database, move the datadir to the new destination, change the data_directory - value in your postgresql.conf to the new value, start the server. Hmmm, shame on me. I tried this way first only on Ubuntu, and it did not work. On the Debian installation of the production server, I install yet, it works perfect. |
server? Do you remember the error message? Was it something like:
postgres cannot access the server configuration file
"/old/db/location/postgresql.conf": No such file or directory
Yours,
Laurenz Albe
#22
| |||
| |||
|
|
What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. Stop the database, move the datadir to the new destination, change the data_directory - value in your postgresql.conf to the new value, start the server. Hmmm, shame on me. I tried this way first only on Ubuntu, and it did not work. On the Debian installation of the production server, I install yet, it works perfect. |
server? Do you remember the error message? Was it something like:
postgres cannot access the server configuration file
"/old/db/location/postgresql.conf": No such file or directory
Yours,
Laurenz Albe
#23
| |||
| |||
|
|
What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. Stop the database, move the datadir to the new destination, change the data_directory - value in your postgresql.conf to the new value, start the server. Hmmm, shame on me. I tried this way first only on Ubuntu, and it did not work. On the Debian installation of the production server, I install yet, it works perfect. |
server? Do you remember the error message? Was it something like:
postgres cannot access the server configuration file
"/old/db/location/postgresql.conf": No such file or directory
Yours,
Laurenz Albe
#24
| |||
| |||
|
|
What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. Stop the database, move the datadir to the new destination, change the data_directory - value in your postgresql.conf to the new value, start the server. Hmmm, shame on me. I tried this way first only on Ubuntu, and it did not work. On the Debian installation of the production server, I install yet, it works perfect. |
server? Do you remember the error message? Was it something like:
postgres cannot access the server configuration file
"/old/db/location/postgresql.conf": No such file or directory
Yours,
Laurenz Albe
#25
| |||
| |||
|
|
What is the best way to change the datadir from /var/lib/postgresql to, for example, /data/postgresql. Stop the database, move the datadir to the new destination, change the data_directory - value in your postgresql.conf to the new value, start the server. Hmmm, shame on me. I tried this way first only on Ubuntu, and it did not work. On the Debian installation of the production server, I install yet, it works perfect. |
server? Do you remember the error message? Was it something like:
postgres cannot access the server configuration file
"/old/db/location/postgresql.conf": No such file or directory
Yours,
Laurenz Albe
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.