On 3/16/07, Dmitry Koterov <dmitry@xxxxxxxxxx> 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