X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A4E569FB319; Mon, 10 Jul 2006 20:27:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 08823-05; Mon, 10 Jul 2006 20:26:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id E468A9FB220; Mon, 10 Jul 2006 20:26:59 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.6/8.13.6) with ESMTP id k6ANQwT6005310; Mon, 10 Jul 2006 16:27:00 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. To: pgsql-admin@postgresql.org Subject: Re: lock a database from new connections, without modifying pg_hba.conf Date: Mon, 10 Jul 2006 16:26:54 -0700 User-Agent: KMail/1.9.1 Cc: adey , "Tom Lane" , "Marc G. Fournier" References: <20060518141816.Q1145@ganymede.hub.org> <20570.1147984074@sss.pgh.pa.us> <1c66bda80607101558x51dd4eb5l5fb569ea31f00da6@mail.gmail.com> In-Reply-To: <1c66bda80607101558x51dd4eb5l5fb569ea31f00da6@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607101626.54936.jd@commandprompt.com> X-Virus-Scanned: ClamAV version 0.88.2, clamav-milter version 0.88.2 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Mon, 10 Jul 2006 16:27:01 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/63 X-Sequence-Number: 22309 On Monday 10 July 2006 15:58, adey wrote: > Can hba be manipulated in such a way to make Postgres "read only" to obtain > a complete and full backup please, and if so, how? PostgreSQL allows "complete and full backups" while in production. E.g; we support hot backups :). You do not have to stop working just to run backups (unlike another unnamed database). Sincerely, Joshua D. Drake > > On 5/19/06, Tom Lane wrote: > > "Marc G. Fournier" writes: > > > Is that possible? I've checked the docs for 8.1, and am not finding > > > anything, nor anything in contrib ... > > > > > > the best I've been able to think of so far is to modify pg_hba.conf to > > > > not > > > > > allow new connections for the duration of the operations I need to > > > > perform > > > > > (drop and create a database) ... > > > > Not sure I understand what you need. DROP DATABASE already locks out > > new connections. > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/