Re: Move PGdata to a different drive

["Massa, Harald Armin" <chef@xxxxxxx>]

Probably you do not have any script to start PostgreSQL, but it is started as a service.

The data directory is a parameter of the service within services.msc, there is
... pg_ctl.exe ... -D "<your drive>":\your\directory"

Read up on pg_ctl --help how to change this information

(pg_ctl --register)

Best wishes,

HArald

On Thu, Jun 4, 2009 at 5:13 PM, Jennifer Trey <jennifer.trey@xxxxxxxxx> wrote:

Ook.. thats what I wanted to know. I figured there has to be a place to change the pointer to the new location of the data.

Thank you / Jennifer

On Thu, Jun 4, 2009 at 6:11 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote:

Jennifer Trey wrote:
> Hi,
> What file should I be working with?

Just shut down the server and move the directory whever you want and
restart the server.  There are no file contents that need changing.  Of
course should adjust your scripts or PGDATA environment variable.

--
 Bruce Momjian  <bruce@xxxxxxxxxx>        http://momjian.us
 EnterpriseDB                             http://enterprisedb.com

 + If your life is a hard drive, Christ can be your backup. +

-- 
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon 
-
LASIK good, steroids bad?