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 4972E9FB352 for ; Sun, 3 Sep 2006 20:25: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 70325-06 for ; Sun, 3 Sep 2006 20:25:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.183]) by postgresql.org (Postfix) with ESMTP id 66D759FB2CE for ; Sun, 3 Sep 2006 20:25:41 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so2342596pyd for ; Sun, 03 Sep 2006 16:25:39 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=mI0xQ58T6zH/fNO7Z3/uUlpDjVLLH662+/CD0vsA3UYgD6I4WkFECr4/Za8D8E0LnUByLXh5Onvgiym9GJqmwYecRu+THnmBGN/w5vFieygB7zW0QCGdEKlisEhA/H2bRsduj6Jc8OWY2e34kBeL3bOfLPZIJ3K4QXdpxGICz4w= Received: by 10.35.57.5 with SMTP id j5mr8681774pyk; Sun, 03 Sep 2006 16:25:39 -0700 (PDT) Received: by 10.35.80.9 with HTTP; Sun, 3 Sep 2006 16:25:24 -0700 (PDT) Message-ID: Date: Sun, 3 Sep 2006 18:25:24 -0500 From: "Aaron Bono" To: "Sriram Dandapani" Subject: Re: archive logs recovery Cc: "Tom Lane" , pgsql-admin@postgresql.org In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF05ABC4CE@ca-mail1.cis.local> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_30921_2422463.1157325924066" References: <6992E470F12A444BB787B5C937B9D4DF05ABC4CE@ca-mail1.cis.local> X-Google-Sender-Auth: c65d337dbbafb48e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.706 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/20 X-Sequence-Number: 22934 ------=_Part_30921_2422463.1157325924066 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/31/06, Sriram Dandapani wrote: > > Also, the dynamic pg_hba changes work only for new connections that are > being established via jdbc. Existing connections seem to able to make > connections. What about changing the permissions on the tables using the GRANT/REVOKE? That way you can stop access to the tables you are working with without having to change the pg_hba.conf or restarting the database. ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_30921_2422463.1157325924066 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 8/31/06, Sriram Dandapani <sdandapani@counterpane.com> wrote:
Also, the dynamic pg_hba changes work only for new connections that are
being established via jdbc. Existing connections seem to able to make
connections.

 
What about changing the permissions on the tables using the GRANT/REVOKE?  That way you can stop access to the tables you are working with without having to change the pg_hba.conf or restarting the database.

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_30921_2422463.1157325924066--