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 Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vishal 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 specify in the data_directory parameter of postgresql.conf file. - vishal >From: "Linux Geeks" <[EMAIL PROTECTED]> >To: "Ray Stell" <[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 >automically start with the new location. > >Thank you very much for the detailed instructions, really appreciated it. > >Regards, > >Dino > >On 5/14/07, Ray Stell <[EMAIL PROTECTED]> wrote: >>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 the >>postmaster and move it and start it with the -D flag pointing to the >>new location: >> >>$ pg_ctl start -D /var/pgsql/data >>server starting >> >>$ psql -p 5437 testdb jira >>Password for user jira: >>Welcome to psql 8.2.3, the PostgreSQL interactive terminal. >> >>Type: \copyright for distribution terms >> \h for help with SQL commands >> \? for help with psql commands >> \g or terminate with semicolon to execute query >> \q to quit >> >>testdb=> \q >> >>pg_ctl stop -D /var/pgsql/data >>waiting for server to shut down....,7222,,2007-05-13 19:52:06.675 >>EDT,,1,,, LOG: logger shutting down >> done >>server stopped >> >>$ mv /var/pgsql/data-move-test /var/pgsql/data >> >>$ pg_ctl start -D /var/pgsql/data-move-test >>server starting >> >>$ psql -p 5437 testdb jira >>Password for user jira: >>Welcome to psql 8.2.3, the PostgreSQL interactive terminal. >> >>Type: \copyright for distribution terms >> \h for help with SQL commands >> \? for help with psql commands >> \g or terminate with semicolon to execute query >> \q to quit >> >>testdb=> \q >> >>pg_ctl stop -D /var/pgsql/data-move-test >>waiting for server to shut down....,7245,,2007-05-13 19:55:00.944 >>EDT,,1,,, LOG: logger shutting down >> done >>server stopped >> >>$ mv /var/pgsql/data-move-test /var/pgsql/data >> >>$ pg_ctl start -D /var/pgsql/data >>server starting >> >>$ psql -p 5437 testdb jira >>Password for user jira: >>Welcome to psql 8.2.3, the PostgreSQL interactive terminal. >> >>Type: \copyright for distribution terms >> \h for help with SQL commands >> \? for help with psql commands >> \g or terminate with semicolon to execute query >> \q to quit >> >>testdb=> \q >> >>-- >> Lost time is when we learn nothing from the experiences of life. Time >> gained is when we grow to have a wisdom that is tested in the reality of >>life. >> > > >-- >To Analyze Is To Know Batte Field, Differ from Battle Itself > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings _________________________________________________________________ More photos, more messages, more storage-get 2GB with Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migr ation_HM_mini_2G_0507 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq