Re: Move PGdata to a different drive - Mailing list pgsql-general

From Massa, Harald Armin
Subject Re: Move PGdata to a different drive
Date
Msg-id e3e180dc0906040820k22a4b222j21caf9a4e32cd4ad@mail.gmail.com
Whole thread Raw
In response to Re: Move PGdata to a different drive  (Jennifer Trey <jennifer.trey@gmail.com>)
List pgsql-general
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@gmail.com> 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@momjian.us> 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@momjian.us>        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?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Division by zero
Next
From: Jennifer Trey
Date:
Subject: Re: Re: High I/O writes activity on disks causing images on browser to lag and not load