X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 34778D1B23F; Tue, 25 May 2004 08:35:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85414-08; Tue, 25 May 2004 08:34:48 -0300 (ADT) Received: from hotmail.com (bay7-f49.bay7.hotmail.com [64.4.11.49]) by svr1.postgresql.org (Postfix) with ESMTP id 53AD1D1B34C; Tue, 25 May 2004 08:34:42 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 25 May 2004 04:34:44 -0700 Received: from 202.54.102.151 by by7fd.bay7.hotmail.msn.com with HTTP; Tue, 25 May 2004 11:34:44 GMT X-Originating-IP: [202.54.102.151] X-Originating-Email: [angshumitrag@hotmail.com] X-Sender: angshumitrag@hotmail.com From: "angshumitra ghosh" To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Backend crash Date: Tue, 25 May 2004 11:34:44 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 25 May 2004 11:34:44.0945 (UTC) FILETIME=[47019410:01C4424C] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/318 X-Sequence-Number: 13634 I am facing some problem while using postgres (version 7.3.1) On trying to execute a psql command from the postges interactive terminal as user 'test' (which exists in the pg database), pgsql seems to be crashing. The postmaster log file contains the following - -------------------------------------------------------------------------------- WARNING: ROLLBACK: no transaction in progress FATAL: Password authentication failed for user "test" LOG: fast shutdown request LOG: shutting down ....... StreamConnection: accept() failed: Connection aborted ------------------------------------------------------------------------------------ Can anyone please tell me why postmaster is shutting down ? What all causes the SIGINT signal to be sent to postmaster that causes rollback of open transactions and disconnection of open connections ? _________________________________________________________________ Get a Citibank Home Loan now. http://go.msnserver.com/IN/49351.asp Build with Citibank Home Loans.