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 94EB6D1B269; Mon, 31 May 2004 01:31:01 -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 32264-08; Mon, 31 May 2004 01:31:00 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 396ADD1B211; Mon, 31 May 2004 01:30:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i4V4Uwb1006970; Mon, 31 May 2004 00:30:58 -0400 (EDT) To: "angshumitra ghosh" Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: Backend crash In-reply-to: References: Comments: In-reply-to "angshumitra ghosh" message dated "Tue, 25 May 2004 11:34:44 -0000" Date: Mon, 31 May 2004 00:30:58 -0400 Message-ID: <6969.1085977858@sss.pgh.pa.us> From: Tom Lane 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/332 X-Sequence-Number: 13648 "angshumitra ghosh" writes: > 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 ? I suspect that you are doing something roughly along the lines of postmaster ... & psql ... ^C When you launch the postmaster from an interactive session, it is still susceptible to being SIGINT'd by your shell unless you take steps to prevent that. When I need to manually launch a postmaster, I usually do this sort of thing: nohup postmaster ...args... logfile 2>&1 & The combination of nohup and making sure that none of stdin, stdout, stderr are still connected to your terminal is enough to disconnect the postmaster from your shell session in the Unixen that I've used. regards, tom lane