Bug with database

[planeswalker]

Below is the message that appears in the PT

Unable to begin feeder import process. Reason: Unable to login to database (PT3 DB). 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?

It started appearing after accidentaly i deleted postgres.conf
How to create new postgres.conf?

Thx,

planeswalker

[WhiteRider]

First, see if postgres.conf is in your Recycle Bin - if it is, restore it.
IF that doesn't work, I've attached a copy of my file - the only thing in there which appears to be non-default is the currency localisation entry. Unzip and save it to your "C:\Program Files\PostgreSQL\8.3\data" folder.

postgresql.zip

(5.51 KiB) Downloaded 116 times

[planeswalker]

Havent found where currency is set. I use USD. Anyway, this didnt help at all. The message is a little bit different though:

"Unable to begin feeder import process. Reason: Unable to login to database (PT3 DB). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting"

[WhiteRider]

You'll need to reload configuration and then start the service.
Start -> Programs -> Postgres -> ...

[planeswalker]

I did, but nothing changed. The same message appears as above. Reinstall PT and postgresql?

[WhiteRider]

You won't need to do anything to PT3, but you may need to re-install postgres.
If you have a database you want to keep, don't remove the data folder when you uninstall.

See this post which explains the process:
Total uninstall/reinstall of PT3 & Postgres

[planeswalker]

I tried to backup postgres database with PGadmin and from the command line. Both methods do not work.

In the first case, i dont get "Right click the database and choose "Backup..."." option.

In the second case, too many command line agruments, are a reason for a failure. I used the basic setup of pokertacker3 with "PokerTracker 3 Database" as a name, and added .tar to the new backup file.

Any ideas? I start losing hope it can be done with saving so far gathered data.

[WhiteRider]

If you can't run postgres you won't be able to backup your database, so as I said above you will have to not delete the data folder, then when you re-install you can link your database back to the existing one. You will have to do a manual postgres install, and on the step where you initialize the database cluster uncheck the box to skip this step (since your database is already initialised).

[planeswalker]

What to do if during manual installation, an error "user postgres already exists", appears? then the installation is rolling back and is cancelled

[planeswalker]

Forget the above entry.