uninstall/reinstall postgres 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

uninstall/reinstall postgres SQL

Postby airfull » Sun Apr 10, 2011 3:47 am

Hello

I'm having trouble with PT3 since few days. When i start PT3, i get an error message "unable to connect to database". So i close the window and start PT3 one more time and then it works.
Today i've decided to reinstall PostgreSQL adn follow this document

http://www.pokertracker.com/products/PT ... greSQL.pdf

On page 7 it says to type "net user postgres/delete" on the prompt command and i get this

http://img402.imageshack.us/i/pbpostgresql.jpg/

The UAC is disabled and i've try with "right click and run as administrator". Can I continue the procédure safely ?

Thanks for help
airfull
 
Posts: 48
Joined: Thu Apr 23, 2009 1:33 am

Re: uninstall/reinstall postgres SQL

Postby WhiteRider » Sun Apr 10, 2011 3:55 am

There is a space in that command - you need this: "net user postgres /delete"
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: uninstall/reinstall postgres SQL

Postby airfull » Sun Apr 10, 2011 4:27 am

Ok thanks for help! PT3 works fine now !

:D
airfull
 
Posts: 48
Joined: Thu Apr 23, 2009 1:33 am

Re: uninstall/reinstall postgres SQL

Postby kraada » Sun Apr 10, 2011 8:06 am

Glad to hear it! :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: uninstall/reinstall postgres SQL

Postby airfull » Thu Apr 14, 2011 3:13 am

:(

Hi i'm still having problem with PostreSQL. Here's the message i get when i start PT3 each day
Image

Uploaded with ImageShack.us

I check "this database already exist" and i get this
Image

Uploaded with ImageShack.us

Then i close the window and restart PT3 and it works.

Any idea to solve that problem ? should i make a backup of the database ?

Thanks for help
airfull
 
Posts: 48
Joined: Thu Apr 23, 2009 1:33 am

Re: uninstall/reinstall postgres SQL

Postby WhiteRider » Thu Apr 14, 2011 4:11 am

That looks like the PostgreSQL service isn't starting correctly the first time.
After you reboot your computer, click Start (on XP click Run), type services.msc and hit enter. In the window that appears, locate the PostgreSQL service. What are the Status and Startup Type?
Assuming that it is not "Started", right click it and choose Start. Does it start?
If you run PT3 then, it should start up OK?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: uninstall/reinstall postgres SQL

Postby WhiteRider » Thu Apr 14, 2011 4:23 am

Which version of PostgreSQL do you have?
PT3 will only start the default 8.3 version that is installed automatically. If you have a later version installed you will need to either launch it manually (as above or via the Start menu), or configure it to start automatically by right clicking it and choosing Properties, then setting the startup type to Automatic.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: uninstall/reinstall postgres SQL

Postby airfull » Thu Apr 14, 2011 9:21 am

Ok white rider

I ' m using the very last version of PostgreSQL 8.3 (i reinstalled it last week end because of that problem). I've been just restart my computer and look to seervices.
The service "PostgreSQL Database server 8.3" has started and is set to "automatic start". So i've tryed to start PT3, and it works fine.

Maybe the problem appears only the compouter is stopped ? I'll Try PT3 tomorrow (i need my computer right now) and i'll tell you if there's something new.

Anyway, thanks for help ! :)
airfull
 
Posts: 48
Joined: Thu Apr 23, 2009 1:33 am

Re: uninstall/reinstall postgres SQL

Postby kraada » Thu Apr 14, 2011 9:35 am

Ok, please keep us posted.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: uninstall/reinstall postgres SQL

Postby airfull » Fri Apr 15, 2011 10:46 am

Hi

I've try today, same problem: PT3 launch correctly the 2nd time.

Any idea ?

:?:
airfull
 
Posts: 48
Joined: Thu Apr 23, 2009 1:33 am

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 25 guests

cron
highfalutin