PostSQL database failure

[Tims1501]

Hey there,

I've been having problems connecting to the postSQL server. I've been using PT3 and everything was working fine before. Now whenever I opened PostSQL 8.3 from pgAdmin 3 it stated: Server doesn't listen. It stated:

"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?"

There are a few things I did but there is still no solution to the conenction problems, I tried:
- turning off UAC, win defender/firewall(set exceptions for pgadmin)
- uninstalling 3rd party antivirus/firewall software
- set all files as administrator
- reinstalling pgadmin 3 as FAQ's instructions
- stop/start server(server cannot start due to logon failure, however no changes were being made previously)
- check connection of external disk server (I could access, read/write on that disk so I don't think its the connection problem)

Is there any other solution you can provide me to perhaps check what the problem could be?

Thanks,
Tim

[fozzy71]

Have you tried to reinstall the same version of postgresql using your same, existing \data folder?


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

For reinstalling SQL to the same DB, follow these steps:

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\8.x\data directory to it's new location.
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

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.


You could also try this method: http://www.holdemmanager.net/forum/showthread.php?t=8261