Unable to Connect to the Database

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 Connect to the Database

Postby smart money » Wed Aug 13, 2008 12:11 pm

Vista. Everything running under Admin, and has been working fine for 100k+ hands.

Nothing new has been installed/uninstalled. No firewall added/removed. Basically, no change of environment...

Then today: File --> Open a Database... --> Select PostgreSQL database --> ERROR message: Unable to Connect to the Database. 101 - SQLSTATE = 08001 server closed the connection unexpectedly.

I also receive this error when starting PAHud: PokerAce Hud Error! SQL Connection Exception: Failed to connect to datasource: server closed the connection unexpectedly.

Thanks.

*EDIT* Only just noticed other post similar to this (despite searching the forum beforehand.) None of the advice given there resolved the problem.
smart money
 
Posts: 38
Joined: Tue Jun 24, 2008 2:14 am

Re: Unable to Connect to the Database

Postby WhiteRider » Wed Aug 13, 2008 12:36 pm

That sounds like postgres isn't running.
Check Task Manager / Processes and see if there are any postgres processes.

Try Start -> Programs -> Postgres -> Start Service.

If that doesn't start it, search on your computer for postmaster.pid and delete that file, the restart 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/<version>/data'
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to Connect to the Database

Postby Ajezz » Wed Aug 13, 2008 3:31 pm

Fwiw, I had the exact same problem today. Must be because of the newest Windows updates from today (Microsoft patch day). After a computer restart everything was fine again.
Ajezz
 
Posts: 6
Joined: Thu Mar 06, 2008 7:12 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 18 guests

cron