Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D4D699FBC6A; Fri, 9 Mar 2007 14:01:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 25555-01-2; Fri, 9 Mar 2007 14:00:58 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc2-s33.bay0.hotmail.com (bay0-omc2-s33.bay0.hotmail.com [65.54.246.169]) by postgresql.org (Postfix) with ESMTP id EAA0E9FBC71; Fri, 9 Mar 2007 14:00:58 -0400 (AST) Received: from hotmail.com ([65.55.136.102]) by bay0-omc2-s33.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 9 Mar 2007 10:00:57 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 9 Mar 2007 10:00:57 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Fri, 09 Mar 2007 18:00:53 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: <321.1173457766@sss.pgh.pa.us> From: "Karthikeyan Sundaram" To: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org Subject: Running in single instance mode Date: Fri, 09 Mar 2007 10:00:53 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 09 Mar 2007 18:00:57.0370 (UTC) FILETIME=[E35E87A0:01C76274] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.868 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/46 X-Sequence-Number: 24870 Hi Everybody, We are using postgres 8.1.0. I want to do some maintenance work. Hence, I want to run postgres in single user mode so that external people won't be able to access the database. How can I run the postgres in single user mode?. Any idea? Regards skarthi _________________________________________________________________ Get a FREE Web site, company branded e-mail and more from Microsoft Office Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/