Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4246C9FBB67 for ; Fri, 9 Mar 2007 15:01:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 13506-04 for ; Fri, 9 Mar 2007 15:01:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 761F49FBBBE for ; Fri, 9 Mar 2007 15:01:16 -0400 (AST) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1HPkL2-0001YL-C7; Fri, 09 Mar 2007 14:01:12 -0500 Subject: Re: Running in single instance mode From: Brad Nicholson To: andy.shellam-lists@mailnetwork.co.uk Cc: Karthikeyan Sundaram , pgsql-admin@postgresql.org In-Reply-To: <45F1A4CC.7010809@mailnetwork.co.uk> References: <45F1A4CC.7010809@mailnetwork.co.uk> Content-Type: text/plain Date: Fri, 09 Mar 2007 14:01:11 -0500 Message-Id: <1173466872.5446.2.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.578 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/49 X-Sequence-Number: 24873 http://www.postgresql.org/docs/8.2/interactive/app-postgres.html On Fri, 2007-03-09 at 18:17 +0000, Andy Shellam wrote: > Remove other users' entries in pg_hba.conf so it only allows your > username from your machine. > > Andy. > > Karthikeyan Sundaram wrote: > > 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/ > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: explain analyze is your friend > > > > !DSPAM:37,45f1a140103006986215648! > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.