Page 1 of 2

Bug with database

PostPosted: Thu Nov 27, 2008 12:39 am
by 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

Re: Bug with database

PostPosted: Thu Nov 27, 2008 5:19 am
by 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

Re: Bug with database

PostPosted: Thu Nov 27, 2008 11:08 am
by 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"

Re: Bug with database

PostPosted: Thu Nov 27, 2008 11:25 am
by WhiteRider
You'll need to reload configuration and then start the service.
Start -> Programs -> Postgres -> ...

Re: Bug with database

PostPosted: Thu Nov 27, 2008 12:20 pm
by planeswalker
I did, but nothing changed. The same message appears as above. Reinstall PT and postgresql?

Re: Bug with database

PostPosted: Thu Nov 27, 2008 12:26 pm
by 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

Re: Bug with database

PostPosted: Thu Nov 27, 2008 1:50 pm
by 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.

Re: Bug with database

PostPosted: Thu Nov 27, 2008 4:34 pm
by 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).

Re: Bug with database

PostPosted: Sat Nov 29, 2008 11:51 am
by planeswalker
What to do if during manual installation, an error "user postgres already exists", appears? then the installation is rolling back and is cancelled

Re: Bug with database

PostPosted: Sat Nov 29, 2008 12:23 pm
by planeswalker
Forget the above entry.

highfalutin