From: | Konstantin Gredeskoul <kigster(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Streaming Replication woes |
Date: | 2011-11-06 23:41:53 |
Message-ID: | CAJ7CQvaBYG_No+2MZYPhw6Fz0CY9Dzo4YE+HknoybSD+Wi0FSQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-11-06 23:55:36 | Re: Re: Re: [GENERAL] Named / preparsed / preplaned(prepared) queries - Feature proposal |
Previous Message | John R Pierce | 2011-11-06 22:23:50 | Re: Re: Re: [GENERAL] Named / preparsed / preplaned(prepared) queries - Feature proposal |