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

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

Postby Gorilla » Sat Aug 30, 2008 10:02 am

dont know why i cant edit my last post.

here is a screenshot of the procmon log (a part of it):

Image
Gorilla
 
Posts: 61
Joined: Sun May 04, 2008 12:43 pm

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

Postby Gorilla » Sat Aug 30, 2008 4:01 pm

err...hello? i cant use pokertracker
Gorilla
 
Posts: 61
Joined: Sun May 04, 2008 12:43 pm

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

Postby WhiteRider » Sat Aug 30, 2008 5:59 pm

Sorry, bear in mind it's a holiday in the US and not everyone is around.
Did you try disabling avira? That's one of the known culprits IIRC.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby Gorilla » Sat Aug 30, 2008 7:15 pm

yes i tried disabling avira. doesnt help. anyway, it worked fine for months with avira
Gorilla
 
Posts: 61
Joined: Sun May 04, 2008 12:43 pm

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

Postby APerfect10 » Mon Sep 01, 2008 12:10 am

Uninstall PostgreSQL from your Control Panel (your data will remain in tact).

Then download and manually install PostgreSQL 8.3.3. During the re-installation process, when you get to the step to initialize your database cluster, uncheck the 'Initialize Cluster' box so that you skip this step. It is not needed since your database cluster from the previous installation is still good. Proceed through the remainder of the installation using default settings.

I suspect that will resolve the issue. My guess is that some security software (Avira?) may have deleted an import PostgreSQL file and reinstalling will resolve the issue.

Best regards,

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

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

Postby Gorilla » Mon Sep 01, 2008 2:36 am

ok, i did what you said.

now i have the postgresql service running again and i can start it manually, too.

but i still loose connection to the database when doing housekeeping. no matter if i only do the cache thing or just vacuum or whatever. after about 35-40 min (always) the connection is lost.

i dont have any other problems with my system and i am using pt3 and avira since months.

i will do one more thing today: reboot my system, unable avira and firewall and try to do the housekeeping. just to be absolutely sure.
Gorilla
 
Posts: 61
Joined: Sun May 04, 2008 12:43 pm

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

Postby Gorilla » Mon Sep 01, 2008 8:59 pm

Gorilla wrote:
i will do one more thing today: reboot my system, unable avira and firewall and try to do the housekeeping. just to be absolutely sure.



it doesnt work either. lost connection after 11 minutes.
Gorilla
 
Posts: 61
Joined: Sun May 04, 2008 12:43 pm

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

Postby APerfect10 » Thu Sep 04, 2008 12:31 am

Is this still happening in Beta 17? B17 contains code so that PT3 automatically reconnects to PostgreSQL if the connection drops. If the service is no longer running PT3 will automatically try starting it then connecting so this hopefully is no longer an issue for you.

Best regards,

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

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

Postby Chimes » Thu Sep 16, 2010 4:42 am

Hi

i've got this exact same problem only its with Postgres 8.4.
I have followed all the instructions from this thread:- viewtopic.php?f=45&t=4098
I found the .dib file and deleted it and disabled Avira etc, to no avail

Now i suspect i need to uninstall Postgres then Reinstall but i just want check with you guys that my Data should be ok if i do this. Could you please advise me which site to download latest Postgres from.

Thanks


Edit: P.s Will i be able to set this up straight to my D drive as opposed to C drive which is getting a bit full?
Chimes
 
Posts: 1
Joined: Sat Jul 24, 2010 11:27 pm

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

Postby kraada » Thu Sep 16, 2010 8:24 am

If you uninstall and reinstall your data should be fine, but if you reinstall somewhere other than C your data will not move.

The easiest solution for you is going to be to create a support ticket using this link so that we can assist you remotely and help you get everything set up and working properly.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

PreviousNext

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 11 guests

cron
highfalutin