Problems after installing on a new HD

[johlag]

Changed hard drive and trying to get pt (v2) to work again. I 've installed PostgreSQL again but pt cant connect to the server. I get the following error message:

Error # :1
Unable to connect to PostgreSQL (Port #: 5432) to get the list of databases. The error was:
101 - SQLSTATE = 08001
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

This is most likely due to the fact that the data base server is not running on this port. Make sure ..

I've seen the same problem in the old forum and I belived that there might be a firewall problem. I 'm running Panda Internet security 2008. I tried to disable the firewall but the same error message came up. Any more suggestions?

I also had problems installing PostgreSQL due to similar problems with connecting to a server but that worked when I disabled the firewall.

//Johan

[ptrack pat]

This error isn't related to just PT. It means the PostgreSQL database server isn't running so nothing will be able to connect to PosgreSQL.

Go to the Start > Settings > Control Panel > Admin Tools > Services window.

Find PostgreSQL 8.2 Database Server in the list. Is it started? If not, try to start it. Does it work or give an error message?

[johlag]

I get this message when I tried to connect to the server:

"An error has occurred:

Error connecting to server: server closed the connection unexpectadly. This problem means the server terminated abnormally before or while processing the request."

[ptrack pat]

Please don't post the same message on another forum.

Go to the c:\program files\postgresql\8.2\data folder. Is there a file called postmaster.pid there? If so, delete it and restart the computer and try it again.

[johlag]

[quote="ptrack pat"xof]Please don't post the same message on another forum.[/quotexof]

Sorry about that.

I tried som different things yesterday including your advise and I got it to work and I managed to restore my old database and it seemed to work fine. Today when I tried to start pt I got this error message:

"Unable to connect to the database
101 - SQLSTATE = 08001
could not connect to the server : connection refused (0x0000274D/10061)
Is the server running on host "localhost" and acccepting TCP/IP connections on port 5432?"

I've tried from admin III to start the database but it is not working. Not even when I disabled the firewall. I could not find the postmaster.pid - file mentioned earlier.

//Johan

[ptrack pat]

It's got to be the firewall that's causing this. I don't know what else would allow it to work one day and then not the next day.

How long have you been using this Panda Internet Security program?

[johlag]

I read this advice in another thread:

Use the Start > Settings > Control Panel > Add or Remove Programs window to uninstall PostgreSQL. Uninstalling will still leave the entire c:\program files\postgresql\8.2\data folder intact.

Go to the Start menu and select Run. Type COMMAND on this window to open a DOS window. Type:

net user postgres /delete

into the DOS window and hit ENTER to run it. Type EXIT to close the DOS window.

Download and reinstall PostgreSQL as detailed here:
http://www.pokertracker3.com/products/P ... nstallSQL2

EXCEPT FOR WHEN YOU GET TO THE WINDOW that has "Initialize database cluster" at the top. UNCHECK THAT BOX and then click the Next button. This will cause it to try to reuse the old ../data folder which has your databases in it.

Once installation completes, restart the computer and try it again."

It worked! But unforunately only the first time I started pt. I closed it and when I opened it to import some tournaments It gave me the same error message as before. I hope I don't have to go through this procedure everytime.

I've used Panda for a few years. I just upgraded it from an older version though. I'll try the older version and see if that works.

[ptrack pat]

The thing is it's the PostgreSQL service that isn't working. Something is causing that to shut down for some reason because as you said, you can't get pgAdmin to work either.

[johlag]

Any ideas?

[ptrack pat]

No, I don't know what would be causing this. Did you revert to the older version of that software?