| From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
|---|---|
| To: | Konstantin Gredeskoul <kigster(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Streaming Replication woes |
| Date: | 2011-11-07 04:27:07 |
| Message-ID: | CAHGQGwGgO0rXWdSJ474+E4MqTuwiTw6OFurQqCv1XaSGCU0=fA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Nov 7, 2011 at 8:41 AM, Konstantin Gredeskoul <kigster(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Geluk (Collis) | 2011-11-07 05:04:17 | PostgreSQL references in the Middle East |
| Previous Message | Fujii Masao | 2011-11-07 02:51:04 | Re: equivalent to "replication_timeout" on standby server |