PROTECTED]>,<[EMAIL PROTECTED]>
CC:
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 & B
shal Arora
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 spe
ot; <[EMAIL PROTECTED]>
CC: pgsql-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
automic
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 Ste
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
: 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:
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
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
You can do an initdb -d /var/lib/postgresql to initialize the data directory in
the /var/lib/postgresql directory. If you also have data in the
/usr/lib/postgresql - make sure you back it up and restore it in the new
directory.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PR
