Re: [BULK] Re: Streaming Replication woes

From: Sean Patronis <spatronis(at)add123(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [BULK] Re: Streaming Replication woes
Date: 2011-11-16 18:48:25
Message-ID: 4EC40579.2040401@add123.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Konstantin,

Just back from some time off and read this reply.

This was exactly the issue. The superuser "postgres" did not have this
role since this was a dump/restore/upgrade from postgres 8.4. I just
created a new Role and user, and it all worked!

Thanks!

--Sean

On 11/06/2011 06:41 PM, Konstantin Gredeskoul wrote:
> Sean,
>
> I saw your email on PostgreSQL general list about replication.
>
> We are using 9.1.1 and were having the same issue, unable to setup
> replication even though following wiki precisely. I was able to
> setup replication following wiki steps using PG 9.0.3, but not 9.1.1.
> Then I found this page:
> http://www.postgresql.org/docs/9.1/static/role-attributes.html
>
> where it says:
>
> initiating replication
> A role must explicitly be given permission to initiate streaming
> replication. A role used for streaming replication must always have
> LOGIN permission as well. To create such a role, use CREATE ROLE name
> REPLICATION LOGIN.
>
> 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.
>
> I went to the master and created a new user specifically for replication:
>
> CREATE ROLE REPLICATOR REPLICATION LOGIN PASSWORD '....';
>
> Then changed my master's pg_hba.conf, and slave's recovery.conf to
> reference the new user "replicator" instead of "postgres", and I no
> longer get the same error, and our replication is working.
>
> Hope this helps!
>
> Thanks,
> ____
> Konstantin Gredeskoul
> Principal Ruby Engineer
> ModCloth, Inc. San Francisco
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Cornett 2011-11-16 18:48:30 Re: all non-PK columns from information schema
Previous Message Eliot Gable 2011-11-16 18:38:03 Foreign Tables