Thread: server closed the connection unexpectedly
Dear all,
i'm unable to connect postgres server with error :
C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres siakad
Password for user postgres:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Password for user postgres:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_log :
2007-08-19 03:00:50 LOG: database system was shut down at 2007-08-19 02:58:26 Malay Peninsula Standard Time
2007-08-19 03:00:50 LOG: checkpoint record is at 0/75A808
2007-08-19 03:00:50 LOG: redo record is at 0/75A808; undo record is at 0/0; shutdown TRUE
2007-08-19 03:00:50 LOG: next transaction ID: 0/1931; next OID: 16737
2007-08-19 03:00:50 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2007-08-19 03:00:51 LOG: database system is ready
2007-08-19 03:01:43 LOG: could not receive data from client: An operation was attempted on something that is not a socket.
2007-08-19 03:00:50 LOG: checkpoint record is at 0/75A808
2007-08-19 03:00:50 LOG: redo record is at 0/75A808; undo record is at 0/0; shutdown TRUE
2007-08-19 03:00:50 LOG: next transaction ID: 0/1931; next OID: 16737
2007-08-19 03:00:50 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2007-08-19 03:00:51 LOG: database system is ready
2007-08-19 03:01:43 LOG: could not receive data from client: An operation was attempted on something that is not a socket.
2007-08-19 03:01:43 LOG: incomplete startup packet
somebody help me please
Muhyiddin A.M Hayat wrote: > Dear all, > > i'm unable to connect postgres server with error : > > C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres siakad > Password for user postgres: > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > > pg_log : > > 2007-08-19 03:00:50 LOG: database system was shut down at 2007-08-19 > 02:58:26 Malay Peninsula Standard Time > 2007-08-19 03:00:50 LOG: checkpoint record is at 0/75A808 > 2007-08-19 03:00:50 LOG: redo record is at 0/75A808; undo record is at > 0/0; shutdown TRUE > 2007-08-19 03:00:50 LOG: next transaction ID: 0/1931; next OID: 16737 > 2007-08-19 03:00:50 LOG: next MultiXactId: 1; next MultiXactOffset: 0 > 2007-08-19 03:00:51 LOG: database system is ready > 2007-08-19 03:01:43 LOG: could not receive data from client: An > operation was attempted on something that is not a socket. > > > 2007-08-19 03:01:43 LOG: incomplete startup packet > > somebody help me please This error is most likely some antivirus or firewall software that's misbehaving. Try uninstalling any such software from the server (you can try disabling it first, but often a complete uninstall is needed) and try again. //Magnus //Magnus