can't start server after update

[husngforfood]

After upgrading from 8.4.1 to 8.4.12 I can't start server.

In the start server window it says that service could not be started. And that service did not report an error.

Under computer management - system tools - event viewer - application there's an error that says: 2012-06-19 16:52:20 GMTFATAL: could not create lock file "postmaster.pid": Permission denied

[kraada]

What operating system are you using?

[husngforfood]

XP

[kraada]

Reboot your system first, then check to see if PostgreSQL is running. If it is not, go into the C:\Program Files\PostgreSQL\8.4\data\ folder and delete the postmaster.pid file, then try to restart the server and let me know if it works.

[husngforfood]

Problem solved! I found this instruction from the web and it worked.

1) Start - Control Panel - Administrator Tools - Services.

2) Look for the service called "PostgreSQL Server <your version number>" in
the right panel of the "Services" window, right click on it and select
"Properties" (or click on it and in the menu select: Action - Properties).

3) In the "Properties" dialog click on the "Start Sesion" tab and change the
radio button from "This account" to "Local System Account" (names can be
slightly different, I'm translating from Spanish to English). That's all.

4) Accept everything and close the "Properties" dialog.


Hope I didn't mess anything up by doing so. Thanks for your time!