On Tue, Nov 8, 2011 at 3:45 AM, Konstantin Gredeskoul <kigster@gmail.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