Re: [ADMIN] Moving data directory

2007-05-22 Thread Khan, Mahmood Ahram
Sent: Tuesday, May 22, 2007 10:09 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Moving data directory Each time you start postgres server using pg_ctl you have to mention the data directory location using -D option. Alternatively you can specify

Re: [ADMIN] Moving data directory

2007-05-22 Thread Vishal Arora
@postgresql.org Subject: Re: [ADMIN] Moving data directory Date: Tue, 22 May 2007 11:11:00 +0530 No needs to specify in pg_ctl start/stop clause instead add a variable in PATH. PG_DATA = d:\postgresdata\data. It is start by just typing pg_ctl start/stop. Thanks Best Regards M.AHRAM KHAN -Original

Re: [ADMIN] Moving data directory

2007-05-21 Thread Linux Geeks
Hi Ray, Sorry for late reply. Yes, I have tested your instructions and working well. The think is now I need to configure so that it will always automically start with the new location. Thank you very much for the detailed instructions, really appreciated it. Regards, Dino On 5/14/07, Ray

Re: [ADMIN] Moving data directory

2007-05-21 Thread Vishal Arora
-admin@postgresql.org Subject: Re: [ADMIN] Moving data directory Date: Tue, 22 May 2007 10:45:17 +0700 Hi Ray, Sorry for late reply. Yes, I have tested your instructions and working well. The think is now I need to configure so that it will always automically start with the new location. Thank you

Re: [ADMIN] Moving data directory

2007-05-13 Thread Peter Eisentraut
Linux Geeks wrote: I'm very new to postgresql and would like to move my data directory to another partition in Ubuntu. The standard installation is in /usr/lib/postgresql. How do I move it into /var/lib/postgresql. The standard data directory on Ubuntu *is* /var/lib/postgresql. You must be

Re: [ADMIN] Moving data directory

2007-05-13 Thread Srinivas Kotapally
: Saturday, May 12, 2007 1:58 PM To: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Moving data directory Hi Srinivas, Is it permanently change it ? Do I have to change some entry in configuration file ? Regards, Dino On 5/12/07, Srinivas Kotapally [EMAIL PROTECTED] wrote: You can

Re: [ADMIN] Moving data directory

2007-05-13 Thread Ray Stell
On Sat, May 12, 2007 at 11:47:46PM +0700, Linux Geeks wrote: I'm very new to postgresql and would like to move my data directory to another partition in Ubuntu. I don't think there is anything internal to pg that locks the data location. Just tell postmaster where you move it to. Shut down

[ADMIN] Moving data directory

2007-05-12 Thread Linux Geeks
Hi All, I'm very new to postgresql and would like to move my data directory to another partition in Ubuntu. The standard installation is in /usr/lib/postgresql. How do I move it into /var/lib/postgresql. Regards, Dino -- To Analyze Is To Know Batte Field, Differ from Battle Itself

Re: [ADMIN] Moving data directory

2007-05-12 Thread Srinivas Kotapally
PROTECTED] On Behalf Of Linux Geeks Sent: Saturday, May 12, 2007 12:48 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] Moving data directory Hi All, I'm very new to postgresql and would like to move my data directory to another partition in Ubuntu. The standard installation is in /usr/lib

Re: [ADMIN] Moving data directory

2007-05-12 Thread Linux Geeks
Hi Srinivas, Is it permanently change it ? Do I have to change some entry in configuration file ? Regards, Dino On 5/12/07, Srinivas Kotapally [EMAIL PROTECTED] wrote: You can do an initdb -d /var/lib/postgresql to initialize the data directory in the /var/lib/postgresql directory. If you