Re: Moving PostgreSQL data directory on Windows

Directory permissions for user the user running the service?

Ottó Havasvölgyi wrote:

>Magnus,
>
>It's a service, and it is 8.0.6. I have fixed the registry to this
>value: "C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" runservice -N
>"pgsql-8.0" -D "E:\PostgreSQL\data\"
>
>The service does not start.
>This new directory definetely exists. But now there is no Event log
>entry about the error. The log file says nothing because it is in the
>data/pg_log directory.
>
>Thanks,
>Otto
>
>
>
>2006/1/13, Magnus Hagander <mha@sollentuna.net>:
>
>
>>>Hello,
>>>
>>>I would like to move the data directory to another location.
>>>I have done this:
>>>1. Stop PostgreSQL
>>>2. Move data directory
>>>3. Create a PGDATA env. variable to the new location 4. Start
>>>PostgreSQL
>>>
>>>And it cannot start, because it cannot find postgresql.conf.
>>>(in Event log) What should I do now?
>>>
>>>
>>Are you running it as a service:? If so you need to reconfigure the service. Unfortunatly,the only way to do this is
usingregedit. Go to 
>>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql-8.1
>>
>>Open the value "ImagePath" and change the data directory.
>>
>>//Magnus
>>
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
>