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 68FC89FB251 for ; Mon, 10 Jul 2006 19:58:50 -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 89052-07 for ; Mon, 10 Jul 2006 19:58:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 1D2C19FB1D3 for ; Mon, 10 Jul 2006 19:58:41 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so4090586ugf for ; Mon, 10 Jul 2006 15:58:40 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=oa+vBUlVXHtNC7yw6nDPuQAEq9EpwYh5gA8C9tUN/P6reTOcmOVQcIfNKV/OvDvJ/ezEqCPDw1fGNQy+SHY7OTaqrBUsQpOE88khQnF4SxDoJlWrkrOmrYvzUyKhQRIBEIeMA5GsVv1QPiqzWv95lNhQIjR+/Roap0MEgLN8ybI= Received: by 10.67.22.2 with SMTP id z2mr345295ugi; Mon, 10 Jul 2006 15:58:40 -0700 (PDT) Received: by 10.66.234.17 with HTTP; Mon, 10 Jul 2006 15:58:40 -0700 (PDT) Message-ID: <1c66bda80607101558x51dd4eb5l5fb569ea31f00da6@mail.gmail.com> Date: Tue, 11 Jul 2006 10:58:40 +1200 From: adey To: "Tom Lane" Subject: Re: lock a database from new connections, without modifying pg_hba.conf Cc: "Marc G. Fournier" , pgsql-admin@postgresql.org In-Reply-To: <20570.1147984074@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_28604_26253987.1152572320282" References: <20060518141816.Q1145@ganymede.hub.org> <20570.1147984074@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/60 X-Sequence-Number: 22306 ------=_Part_28604_26253987.1152572320282 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? 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 > ------=_Part_28604_26253987.1152572320282 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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?

On 5/19/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Marc G. Fournier" <scrappy@postgresql.org> 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

------=_Part_28604_26253987.1152572320282--