Re: Proposal: Change of pg_trigger.tg_enabled and adding pg_rewrite.ev_enabled

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: Change of pg_trigger.tg_enabled and adding pg_rewrite.ev_enabled
Date: 2007-01-26 21:40:12
Message-ID: EE4E0C47-44AF-4DF0-8CD9-89AF49D640B1@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Jan 25, 2007, at 5:33 PM, Jan Wieck wrote:
> A new per session GUC variable, restricted to superusers, will
> define if the session is in origin or replica mode.

It would be nice if we had a separate role for replication services
so that we weren't exposing superuser so much. IIRC Oracle even uses
2 roles; one for administration of replication and one that the
replication code actually runs under.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-01-26 21:46:28 Re: PostgreSQL Data Loss
Previous Message Jim Nasby 2007-01-26 21:39:35 Re: Proposal: Change of pg_trigger.tg_enabled and adding