Page 1 of 2

Unable to connect to database

PostPosted: Fri Nov 21, 2008 7:34 am
by Duppy81
Ugh, beat. I've browsed the forums but can't seem to find the answer although I do see a lot of people regulalry having similar problems.

My problem is as follows:

I made a complete backup of my system, so the entire disk. I then put in a RAID0 configuration and restored the backup to that disc. After some struggles (installing RAID drivers and such) I got everythin to work again and nothing (programs, files etc...) seemed lost. Now, however, I'm trying to launch PT3 but it says:

"Unable to login to database (PT3_2008_09_30_010222). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?"

I then launched pgAdmin III ad tried connecting to my database server, but it gives this error:

"Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?"

I've tried the pinging stuff on 127.0.0.1 and get this:

"Packages sent = 4, received = 4, lost = 0"

All worked fine before, haven't changed a thing just backed up en restored the entire system and now this crap :(. I don't know what to do and I'm scared of taking steps by myself because I don't want to risk losing any databases (there are also some HM databases).

Re: Unable to connect to database

PostPosted: Fri Nov 21, 2008 7:36 am
by Tenitsi
Same here. PT3 doesn't work anymore. It doesn't show any stats. MAJOR BUG!
Here is what the PT3 shows: http://img509.imageshack.us/my.php?imag ... rorph9.jpg

Re: Unable to connect to database

PostPosted: Fri Nov 21, 2008 11:03 am
by WhiteRider
This isn't a problem with PT3, it just 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/[version]/data'.
See also: viewtopic.php?f=17&t=6332#p38285

Re: Unable to connect to database

PostPosted: Sat Nov 22, 2008 4:07 am
by Duppy81
Thanks, Postgres and the service was running. I reinstalled postgres using one of your guides (keeping the data folder for not losing any databases). Searching for an exact similar version of Postgres was a pain (I was running an older version) but I finally found it and it worked. So all fine now :D.

Re: Unable to connect to database

PostPosted: Sat Nov 22, 2008 5:10 am
by WhiteRider
Great! Glad you got it working again.

Re: Unable to connect to database

PostPosted: Sat Nov 22, 2008 4:57 pm
by andyb325
Thanks, I had this problem today as well, and this did wonders.

Re: Unable to connect to database

PostPosted: Sat Nov 29, 2008 12:11 am
by ButteredToes
WhiteRider wrote:This isn't a problem with PT3, it just 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/[version]/data'.
See also: viewtopic.php?f=17&t=6332#p38285

I'm having the same problem. I followed those steps but it didn't help. In my data folder there isn't a postmaster.pid file, but there is a postmaster.opts file, what should I do now?

Re: Unable to connect to database

PostPosted: Sat Nov 29, 2008 5:24 am
by WhiteRider
Something on your system is probably preventing postgres running.
Please select the last few files in C:\Program Files\PostgreSQL\8.3\data\pg_log (they're dated so just pick the recent ones), right-click and choose 'Send To Compressed/zipped Folder', then attach the zip file to a ticket on the Support system, and link to this thread in the reference field of the ticket so that we can investigate.

Re: Unable to connect to database

PostPosted: Sat Dec 06, 2008 4:35 pm
by manool
then Im lauchin PR the window Configure postgreSQL server appears & when Im tryin to connect - Unable to connect to this database. Please check the configuration. Help pls

Re: Unable to connect to database

PostPosted: Sun Dec 07, 2008 9:51 am
by kraada
manool,

Did you install PostgreSQL? Click Start --> Programs --> PostgreSQL --> Start Services to start the PostgreSQL service. If you don't see the "Start Services" link or the PostgreSQL folder then you don't have PostgreSQL installed and you will need to download and install PokerTracker 3 Beta 22 with PostgreSQL from our download page.

If you have PostgreSQL installed, the default values are:
Server: localhost
Port: 5432
User: postgres
Password: dbpass

If this password does not work for you, you can disable password authentication by following the directions of this tutorial.

highfalutin