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.
somebody help me please
On 18/08/2007 19:30, Muhyiddin A.M Hayat wrote:
somebody help me please
You'll need to post a lot more information before anyone can help.
Is there anything in the server log? - or the Windows event log?
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------
This is 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
2007-08-19 03:20:15 LOG: could not receive data from client: An operation
was attempted on something that is not a socket.
2007-08-19 03:20:15 LOG: incomplete startup packet
2007-08-19 03:25:30 LOG: could not receive data from client: An operation
was attempted on something that is not a socket.
2007-08-19 03:25:30 LOG: incomplete startup packet
2007-08-19 03:27:05 LOG: could not receive data from client: An operation
was attempted on something that is not a socket.
2007-08-19 03:27:05 LOG: incomplete startup packet
2007-08-19 03:33:18 WARNING: there is no transaction in progress
2007-08-19 03:33:29 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "auth_users_pkey" for table "auth_users"
2007-08-19 03:33:30 WARNING: there is no transaction in progress
2007-08-19 03:33:34 LOG: could not receive data from client: An operation
was attempted on something that is not a socket.
2007-08-19 03:33:34 LOG: incomplete startup packet
Thanks
----- Original Message -----
From: "Raymond O'Donnell" <rod@iol.ie>
To: "Muhyiddin A.M Hayat" <middink@indo.net.id>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, August 19, 2007 3:13 AM
Subject: Re: [GENERAL] server closed the connection unexpectedly
Show quoted text
On 18/08/2007 19:30, Muhyiddin A.M Hayat wrote:
somebody help me please
You'll need to post a lot more information before anyone can help.
Is there anything in the server log? - or the Windows event log?
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
------------------------------------------------------------------------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly