Postgres Pro
Downloads
Home   >   mailing lists

Re: Streaming Replication woes - Mailing list pgsql-general

From Raghavendra
Subject Re: Streaming Replication woes
Date
Msg-id CA+h6Ahgu=zMDJ=vDcm2yyKJCPZOzKDQCQFaYyUM36qSdCN2rqA@mail.gmail.com
Whole thread Raw
In response to Streaming Replication woes  (Sean Patronis <spatronis@add123.com>)
Responses Re: Streaming Replication woes  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-general
Tree view

On Fri, Nov 4, 2011 at 8:20 PM, 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?



Step 3 from wiki. and reload PG-instance 

  • 3. Set up connections and authentication so that the standby server can successfully connect to the replication pseudo-database on the primary.

$ $EDITOR postgresql.conf

listen_addresses = '192.168.0.10'

$ $EDITOR pg_hba.conf

# The standby server must have superuser access privileges.
host  replication  postgres  192.168.0.20/22  trust

---
Regards,
Raghavendra
EnterpriseDB Corporation


pgsql-general by date:

Previous
From: Sean Patronis
Date:
Subject: Streaming Replication woes
Next
From: Sean Patronis
Date:
Subject: Re: Streaming Replication woes