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@xxxxxxxxxxxxxx>:
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 using regedit. 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
