Is there a fix for the Services Privilleges problem with SQL

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

Is there a fix for the Services Privilleges problem with SQL

Postby mrpinkmcpink » Mon May 26, 2008 7:41 am

I noticed that a few other people with XP are getting the error message when stating services that you have insufficient privileges.

Has anyone been able to find a way round this yet?
mrpinkmcpink
 
Posts: 2
Joined: Mon May 26, 2008 6:27 am

Re: Is there a fix for the Services Privilleges problem with SQL

Postby APerfect10 » Tue May 27, 2008 1:42 am

Still searching. I know how to resolve the issue with every WinXP version except Home. :(

-Derek
APerfect10
Site Admin
 
Posts: 4370
Joined: Sat Dec 08, 2007 6:03 pm

Re: Is there a fix for the Services Privilleges problem with SQL

Postby mrpinkmcpink » Thu Jun 26, 2008 1:38 pm

Any news on this? :-(
mrpinkmcpink
 
Posts: 2
Joined: Mon May 26, 2008 6:27 am

Re: Is there a fix for the Services Privilleges problem with SQL

Postby keggler » Thu Jun 26, 2008 2:55 pm

You've both probably got a permissions problem that another piece of software has set on a file folder or a registry key that is stopping the postgres service get going.

Get procmon (from sysinternals), restart the install, when it gets to the error, don't dismiss the dialog box, launch procmon, make a note of the postgres process ID (PID) from windows task manager, filter the procmon to this PID, scroll down to the bottom and look for any folders/registry keys this PID is trying to access.

The path and result columns in procmon should give you the clue as to the offending item...

If it turns out to be the path of a completely different app, this is the culprit that's holding the lock that's preventing postgres from starting - that app needs to be disabled, uninstalled or updated so it does not conflict with the postgres service.


susan
keggler
 
Posts: 640
Joined: Sun Jun 01, 2008 4:53 am

Re: Is there a fix for the Services Privilleges problem with SQL

Postby kraada » Thu Jun 26, 2008 5:24 pm

So far the known culprit list includes:
Norton Antivirus, F-Secure Antivirus, and Spampal
(edit: plus Internet Explorer 8 beta 2 IIRC)

If you are using one of these, please disable it and make sure it is not running in resident memory and attempt to reinstall and it may resolve your issue.

If you find out it was another program, please send me a PM and let me know I'm trying to keep a list of known offenders (and while I'm going to keep checking in on this thread, a PM is faster :)
kraada
Moderator
 
Posts: 54435
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Is there a fix for the Services Privilleges problem with SQL

Postby bugsbunny » Thu Jun 26, 2008 5:39 pm

Note that any anti-virus should be disabled while installing postgres (or almost any other software - especially if it's a complex package) - and that the postgres folders should be excluded from antivirus checking even once your anti-virus is started again.
bugsbunny
 
Posts: 65
Joined: Sun Feb 10, 2008 9:29 am

Re: Is there a fix for the Services Privilleges problem with SQL

Postby Lawrence » Tue Aug 26, 2008 3:26 pm

Unfortunately I have got the same problem. Interestingly in my first few sessions, it worked without problems and suddendly i got the above explained error. I tried all the hints posted in the FAQ but nothing helped so I cant use PT now :(

Any help for me?

I'm using Vista. And the imporant thing is that it already worked!

Thanks a lot!
Lawrence
 
Posts: 4
Joined: Fri Aug 22, 2008 11:39 am

Re: Is there a fix for the Services Privilleges problem with SQL

Postby WhiteRider » Tue Aug 26, 2008 6:13 pm

Have you installed anything else since?
Had an update to your anti-virus software, etc?
WhiteRider
Moderator
 
Posts: 53416
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Is there a fix for the Services Privilleges problem with SQL

Postby Lawrence » Wed Aug 27, 2008 1:37 pm

No
Lawrence
 
Posts: 4
Joined: Fri Aug 22, 2008 11:39 am

Re: Is there a fix for the Services Privilleges problem with SQL

Postby WhiteRider » Thu Aug 28, 2008 4:02 am

Did you do the search for postmaster.pid? Did the file exist?
WhiteRider
Moderator
 
Posts: 53416
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 1 guest

cron
highfalutin