From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Konstantin Gredeskoul <kigster(at)gmail(dot)com> |
Cc: | PostgreSQL pg-general List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Streaming Replication woes |
Date: | 2011-11-08 10:54:05 |
Message-ID: | CAHGQGwHe8oiQoo4ZaA=3crcFwckdqXhmE06kGFiDO4sO04VBww@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Nov 8, 2011 at 3:45 AM, Konstantin Gredeskoul <kigster(at)gmail(dot)com> wrote:
> The user 'postgres' was created using standard database installation
> procedure. It has superuser, but does not include an explicit replication
> role:
>
> my_db=# \du
> List of roles
> Role name | Attributes | Member of
> ------------+-----------------------------------+-----------
> postgres | Superuser, Create role, Create DB | {}
> replicator | Replication | {}
Did you restore the database from the dump file created by pg_dumpall
in 9.0 instead of 9.1? If yes, that dump file would contain the "ALTER ROLE
postgres" command and revoke the replication privilege, I guess.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Ondrej Ivanič | 2011-11-08 11:03:46 | Re: Postgres vs other Postgres based MPP implementations |
Previous Message | Ondrej Ivanič | 2011-11-08 10:36:47 | Re: Postgres vs other Postgres based MPP implementations |