Re: Streaming Replication woes

On 11/04/2011 10:59 AM, Thom Brown wrote:
> On 4 November 2011 16:50, Sean Patronis<spatronis@add123.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?