Page 1 of 2

uninstall/reinstall postgres SQL

PostPosted: Sun Apr 10, 2011 3:47 am
by airfull
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

Re: uninstall/reinstall postgres SQL

PostPosted: Sun Apr 10, 2011 3:55 am
by WhiteRider
There is a space in that command - you need this: "net user postgres /delete"

Re: uninstall/reinstall postgres SQL

PostPosted: Sun Apr 10, 2011 4:27 am
by airfull
Ok thanks for help! PT3 works fine now !

:D

Re: uninstall/reinstall postgres SQL

PostPosted: Sun Apr 10, 2011 8:06 am
by kraada
Glad to hear it! :)

Re: uninstall/reinstall postgres SQL

PostPosted: Thu Apr 14, 2011 3:13 am
by airfull
:(

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

Re: uninstall/reinstall postgres SQL

PostPosted: Thu Apr 14, 2011 4:11 am
by WhiteRider
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?

Re: uninstall/reinstall postgres SQL

PostPosted: Thu Apr 14, 2011 4:23 am
by WhiteRider
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.

Re: uninstall/reinstall postgres SQL

PostPosted: Thu Apr 14, 2011 9:21 am
by airfull
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 ! :)

Re: uninstall/reinstall postgres SQL

PostPosted: Thu Apr 14, 2011 9:35 am
by kraada
Ok, please keep us posted.

Re: uninstall/reinstall postgres SQL

PostPosted: Fri Apr 15, 2011 10:46 am
by airfull
Hi

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

Any idea ?

:?: