can't start server after update

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

can't start server after update

Postby husngforfood » Tue Jun 19, 2012 2:54 pm

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
husngforfood
 
Posts: 83
Joined: Wed Mar 21, 2012 4:03 am

Re: can't start server after update

Postby kraada » Tue Jun 19, 2012 3:55 pm

What operating system are you using?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: can't start server after update

Postby husngforfood » Wed Jun 20, 2012 1:24 am

XP
husngforfood
 
Posts: 83
Joined: Wed Mar 21, 2012 4:03 am

Re: can't start server after update

Postby kraada » Wed Jun 20, 2012 7:32 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: can't start server after update

Postby husngforfood » Wed Jun 20, 2012 8:59 am

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!
husngforfood
 
Posts: 83
Joined: Wed Mar 21, 2012 4:03 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 39 guests

cron