Re: Streaming Replication woes

On 4 November 2011 17:19, Sean Patronis <spatronis(at)add123(dot)com> wrote:
> On 11/04/2011 10:59 AM, Thom Brown wrote:
>>
>> On 4 November 2011 16:50, Sean Patronis<spatronis(at)add123(dot)com>  wrote:
>>>
>>> I am running Postgres 9.1
>>>
>>> I have followed the howto here:
>>> http://wiki.postgresql.org/wiki/Streaming_Replication
>>>
>>> I am attempting to replicate an existing database.
>>>
>>> On the Master, I get the following error in the postgres log file:
>>>
>>> FATAL:  must be replication role to start walsender
>>>
>>>
>>> On the slave I get this:
>>> FATAL:  could not connect to the primary server: FATAL:  must be
>>> replication
>>> role to start walsender
>>>
>>> I have googled both of those log entries to no avail.
>>>
>>> note that the sender process on the master is not running.
>>>
>>> What simple step am I missing?
>>
>> What have you got primary_conninfo set to on the standby in
>> recovery.conf?  Are you trying to use a regular user?  If so, you will
>> have to grant it REPLICATION permissions on the primary, which was
>> introduced in 9.1.
>>
>
>
> The primary_conninfo in the recovery.conf is set to :
> primary_conninfo      = 'host=192.168.127.12 port=5432 user=postgres'
>
> So I should just have to grant the postgres user REPLICATION permissions,
> and be good?

Well the postgres user will be a superuser, so doesn't need to be
granted such a permission.

Have you got the necessary entry in pg_hba.conf as Raghavendra
highlighted? It will need configuring to accept a connection from the
IP address of the standby server.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company