Unable to connect to database

[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).

[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

[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

[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 .

[WhiteRider]

Great! Glad you got it working again.

[andyb325]

Thanks, I had this problem today as well, and this did wonders.

[ButteredToes]

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?

[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.

[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

[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.