On 4 November 2011 17:19, Sean Patronis <spatronis@xxxxxxxxxx> wrote: > On 11/04/2011 10:59 AM, Thom Brown wrote: >> >> On 4 November 2011 16:50, Sean Patronis<spatronis@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
