Page 1 of 1
can't start server after update
Posted:
Tue Jun 19, 2012 2:54 pmby 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
Re: can't start server after update
Posted:
Tue Jun 19, 2012 3:55 pmby kraada
What operating system are you using?
Re: can't start server after update
Posted:
Wed Jun 20, 2012 1:24 amby husngforfood
XP
Re: can't start server after update
Posted:
Wed Jun 20, 2012 7:32 amby 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.
Re: can't start server after update
Posted:
Wed Jun 20, 2012 8:59 amby 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!
