Thread: server closed the connection unexpectedly

server closed the connection unexpectedly

From
"Muhyiddin A.M Hayat"
Date:
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

Re: server closed the connection unexpectedly

From
Raymond O'Donnell
Date:
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
---------------------------------------------------------------

Re: server closed the connection unexpectedly

From
"Muhyiddin A.M Hayat"
Date:
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


> 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