Re: Creation of a read-only role.

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: dmitry(at)koterov(dot)ru
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Creation of a read-only role.
Date: 2007-03-17 15:22:24
Message-ID: 9e4684ce0703170822m72bfaff4j2a128e21aef9fbff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/16/07, Dmitry Koterov <dmitry(at)koterov(dot)ru> wrote:
> Overall, we need 3 roles:
> 1. Administrator: can do anything with a database (by default this user is
> already exists - "postgres").
> 2. Read-only: can only read. Runs on all slave nodes.

actually - you dont need the read-only role, if this is only for slave
nodes. slony takes care about the issue and doesn't allow any writes
on slaves.

depesz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cesar Alvarez 2007-03-17 15:41:38 Store Procedures
Previous Message Karsten Hilbert 2007-03-17 13:47:47 Re: Creation of a read-only role.