Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 34C3B9FB6FD for ; Fri, 9 Mar 2007 14:19:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 89658-04 for ; Fri, 9 Mar 2007 14:18:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cooma-1.andyshellam.eu (cooma-1.andyshellam.eu [82.165.38.62]) by postgresql.org (Postfix) with ESMTP id 8B3919FB6A3 for ; Fri, 9 Mar 2007 14:18:45 -0400 (AST) Received: from user-3e88ba12.telcl18.dsl.pol.co.uk ([62.136.186.18]:1319 helo=[10.100.9.2]) by cooma-1.andyshellam.eu with esmtpa (Exim 4.66) (envelope-from ) id 1HPjiw-0002z7-RZ; Fri, 09 Mar 2007 18:21:50 +0000 Message-ID: <45F1A4CC.7010809@mailnetwork.co.uk> Date: Fri, 09 Mar 2007 18:17:48 +0000 From: Andy Shellam Reply-To: andy.shellam-lists@mailnetwork.co.uk Organization: www.AndyShellam.EU User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Karthikeyan Sundaram CC: pgsql-admin@postgresql.org Subject: Re: Running in single instance mode References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.239 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/47 X-Sequence-Number: 24871 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! > >