Error Message when I try connect to HEM

[pucciyamagucci]

The following error occurred when trying to open the database: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

Then I try to connect to the database and then a window pops up with title "DB Control Panel"

"Connection Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at SYstem.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32size)
--- End of inner exception stack trace ---"

THen there's like 12 more lines of the of "at etc. etc." I would c/p but it won't let me and it's too tedious to type
There are 2 lines of at System.
Then the rest are at Npgsql.Npgsql (State,ConnectorPool, ConnectedState, or Connection)
Last line says: at f.i(Object A_O, EventArgs A_1)

Not sure what this all means. Help would be much appreciated.
Thanks

[Patvs]

This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely
Try 8.2 PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)

[pucciyamagucci]

This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely
Try 8.2 PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)
Thanks for the response Patvs!

I rebooted, Stopped service, Started it, restarted it, etc. I tried everything really. Even deleted the .pid file. That didn't help either.

So I reinstalled PostgreSQL (This doesn't mean I'm gonna lose all my hands right? The last thing I want is that happening) the 8.2 version (i clicked the http link, not the ftp?). Now I'm stuck and don't know where to go from here. I read some of the postgreSQL FAQ but got kind of discouraged and frustrated..

[netsrak]

If you reinstall Postgres (especially another version as currently running) you will probably loose your databases.

Have you checked your firewall settings and defined exceptions? http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29
Please also try this:
- Check the postgresql service in the windows services (control panel->administration). Sometimes it helps to change the Logon As.. to "local system account"


Before reinstalling Postgres i would try to reinstall your firewall (if you are using a 3rd party product).