Re: Move PGdata to a different drive

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(dot)trey(at)gmail(dot)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(at)momjian(dot)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(at)momjian(dot)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?