Unable to log on to database(PT3DB)

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

Unable to log on to database(PT3DB)

Postby hiflyer51 » Wed Sep 10, 2008 9:05 pm

Began Auto-Import and got this message:

Unable to log on to database(PT3DB) Reason: Server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request.

How do I correct this???
hiflyer51
 
Posts: 4
Joined: Tue Sep 02, 2008 11:04 pm

Re: Unable to log on to database(PT3DB)

Postby hiflyer51 » Wed Sep 10, 2008 9:30 pm

Well, I rebooted and all is well.
hiflyer51
 
Posts: 4
Joined: Tue Sep 02, 2008 11:04 pm

Re: Unable to log on to database(PT3DB)

Postby Skipjack » Thu Sep 11, 2008 11:12 am

If it happens again, this link explains what I had to do viewforum.php?f=16
Skipjack
 
Posts: 26
Joined: Tue May 06, 2008 9:42 pm

Re: Unable to log on to database(PT3DB)

Postby TrashBin » Sat Sep 20, 2008 5:40 am

I am a new user, loaded the trial version.
When it works properly, i'll register.
However i'm encountering the same problem skipjack had.

After first installation it worked fine, the next day the error pops up.

The link skipjack refers to gives me only the general forum window and i can't find the solution (up till now).

I run PT3 the beta version and postgres 8.3.
I run as computer administrator.

This seems to be a known problem, so i hope help will be on its way.

Thanks in advance.
TrashBin
 
Posts: 2
Joined: Wed Sep 17, 2008 5:37 am

Re: Unable to log on to database(PT3DB)

Postby WhiteRider » Sat Sep 20, 2008 6:06 am

This means that postgres isn't running.
Please try starting the postgres service: Start -> Programs -> PostgreSQL -> Start Service.
If that, and a reboot doesn't work, try stopping the service (Start -> Programs -> Postgres -> Stop Service), running a search on your computer for postmaster.pid and then deleting that file, then restarting the service and see if that helps.
Note that you may need to turn on 'View hidden files and folders', and the file seems to be in the folder './Program Files/postgresql//data'.
See also: viewtopic.php?f=17&t=6332#p38285

TrashBin wrote:I run PT3 the beta version and postgres 8.3.
I run as computer administrator.

This is not the same as running PT3 and your poker site as administrator.
Right click the shortcut and select 'Run As Administrator'.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to log on to database(PT3DB)

Postby TrashBin » Sat Sep 20, 2008 6:51 am

Thanks,

Found the other thread aswell and stopped/started the service.
It's importing hand histories now, getting some other problems.
I'll give rebooting a try next and check out the administrator thing.
I'll be working on those problems looking through the threads, if i need more help ( :lol: ) i'll be sure to post.

Thanks for the speedy reply.
TrashBin
 
Posts: 2
Joined: Wed Sep 17, 2008 5:37 am

Re: Unable to log on to database(PT3DB)

Postby WhiteRider » Sat Sep 20, 2008 7:00 am

If it's importing hands then postgres is working.
Are you getting import errors?

What version of PT3 are you using?
What poker site?
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to log on to database(PT3DB)

Postby TDDT » Sat Sep 20, 2008 1:38 pm

Right lads

having the exact same trouble, and ended up unistalling everything PT3 related which i then read was a bad idea, now i can't get Postgres to reinstall at all?

anyhelp much appreciated.
TDDT
 
Posts: 6
Joined: Mon May 26, 2008 5:18 pm

Re: Unable to log on to database(PT3DB)

Postby WhiteRider » Sat Sep 20, 2008 1:40 pm

Please see this post for how to fully uninstall and re-install.
Total uninstall/reinstall of pt3

Note: if you previously installed PT3 with postres and it worked, you can do that again, you don't need to do the manual postgres installed.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 7 guests

cron
highfalutin