Re: archive logs recovery

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: archive logs recovery
Date: 2006-09-03 23:25:24
Message-ID: bf05e51c0609031625g6664dda6g35866b9ee7adfd17@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 8/31/06, Sriram Dandapani <sdandapani(at)counterpane(dot)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
==================================================================

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Luís Sousa 2006-09-04 11:14:30 SET SESSION AUTHORIZATION permissions
Previous Message Bruno Wolff III 2006-09-03 18:55:34 Re: REVOKE DROP tables