My C drive filled up [edit: actually my D drive], so I carefully followed the instructions here to move my PostgreSQL data folder (all 18 Gig of it) to a second hard disk.
PostgreSQL is installed in "D:\Program Files (x86)\PostgreSQL\8.3\"
And now my data folder is "P:\Program Files (x86)\PostgreSQL\8.3\data"
I did everything in the instructions, including changing the ImagePath registry entry to:
Code:
"D:\Program Files (x86)\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D "P:\Program Files (x86)\PostgreSQL\8.3\data\"
I also checked the permissions for the newly created data folder. Full Control is granted to everyone.
But having done all this (and rebooted) I now can't get the database service to start up.
When I 'Start service', the command-prompt window pops up as usual, but the service never starts:
Code:
The PostgreSQL Database Server 8.3 service is starting..........................
How can I find out what's going wrong?