PDA

View Full Version : postgresql issues



mayor_haggar
09-27-2009, 06:11 PM
Hi there, I'm running the lastest beta edition of the omaha manager version of the software, on a vista machine and with postgresql v 8.3.

I'm getting the usual 127.0.0.1 error messages regarding postgresql not connecting, but i then seem to get a circular series of error messages once the database control panel comes up. I've tried following the advice in the FAQS and various threads, but to no avail.

Firstly I click connect, and it tells me a connection could not be made, and would i like HEM to attempt to start the service. I click ok and it tells me HEM has started the service and asks me to try again. This takes me back to the database control panel.

I go back to the database manager, try to connect, and the get the first error message. However, I then get a new second error message telling me HEM was unable to start the service. I OK this, but then immediately get the message telling me HEM has started the service and to try again, which again brings up the database control panel. there seems to be no way out of this loop of error messages, and I can't even get the main HEM window open.

Now, when I went into the control panel > admin tools > services menu and tried to start postgresql manually it basically tried for a few minutes, then said that it couldn't start it because it didn't "respond in a timely manner". So I can't seem to get postgresql to start at all, which I think is the problem. Any idea as to how to sort this? I don't mind reinstalling if need be, since i can always just re-import the hands, but I'm not sure this would fix the problem.

EDIT: I can't get postgresql to start at all, even when i try to get it going manually from the run menu.

fozzy71
09-27-2009, 06:36 PM
1. Close down all programs that might be using postgreSQL like EV Graph, PT2 etc.

2. Restart your computer.

3. Disable/Exit/Close your firewall and any antivirus programs.

Also if you have a 3rd part firewall like Zonealarm, make sure your built in firewall isn't running as well by going to Start > Control Panel > Windows Firewall and in the General tab switching it to off. Then restart your PC.

4. Go to C:\Program Files\PostgreSQL\8.x\data and delete the postmaster.pid file.

5. Restart the PostgreSQL service like in step 2. (If that file dosen't exist then that's normal. Also don't delete the postmaster.opts file, it's a different one).

If this isn't successful and you get the error again saying it can't start, then you have a problem with an antivirus/firewall etc. blocking PostgreSQL. Follow the FAQ for antivirus/firewall help here: http://www.holdemmanager.net/faq/?f=171.




If it still wont connect after a reboot, try to reinstall postgresql using the same \data files:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\data directory to it's new location.
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.



If it still wont connect, use the reinstallation method explained here:

http://www.holdemmanager.net/forum/showthread.php?t=8261



If none of that works, I would suggest a clean reinstall of postgresql 8.4 and import all your archives (after turning off postgresql logging).

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows