Re: Streaming Replication woes - Mailing list pgsql-general

From Fujii Masao
Subject Re: Streaming Replication woes
Date
Msg-id CAHGQGwGgO0rXWdSJ474+E4MqTuwiTw6OFurQqCv1XaSGCU0=fA@mail.gmail.com
Whole thread Raw
In response to Re: Streaming Replication woes  (Konstantin Gredeskoul <kigster@gmail.com>)
Responses PostgreSQL references in the Middle East  ("Jan Geluk (Collis)" <geluk@collis.nl>)
List pgsql-general
On Mon, Nov 7, 2011 at 8:41 AM, Konstantin Gredeskoul <kigster@gmail.com> wrote:
> Does that mean "postgres" superuser is no longer able to also be a
> replication user in 9.1?  If so this is not yet updated on the
> Replication wiki.

No. Superuser has the replication privilege by default. But if you granted
the "postgres" user the superuser privilege by using ALTER ROLE, the
replication privilege would not be granted.

You can check whether the "postgres" user has the replication privilege
by executing "\du" command.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

pgsql-general by date:

Previous
From: Fujii Masao
Date:
Subject: Re: equivalent to "replication_timeout" on standby server
Next
From: "Jan Geluk (Collis)"
Date:
Subject: PostgreSQL references in the Middle East