Page 1 of 2
Bug with database
Posted:
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
Posted:
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.
Re: Bug with database
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
Sat Nov 29, 2008 12:23 pm
by planeswalker
Forget the above entry.