[GENERAL] Streaming Replication woes

2011-11-04 Thread Sean Patronis
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 sla

Re: [GENERAL] Streaming Replication woes

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

Re: [GENERAL] Streaming Replication woes

2011-11-04 Thread Sean Patronis
On 11/04/2011 11:25 AM, Thom Brown wrote: On 4 November 2011 17:19, Sean Patronis wrote: On 11/04/2011 10:59 AM, Thom Brown wrote: On 4 November 2011 16:50, Sean Patroniswrote: I am running Postgres 9.1 I have followed the howto here: http://wiki.postgresql.org/wiki

Re: [BULK] Re: [GENERAL] Streaming Replication woes

2011-11-04 Thread Sean Patronis
On 11/04/2011 11:31 AM, Simon Riggs wrote: On Fri, Nov 4, 2011 at 2:56 PM, Raghavendra wrote: # The standby server must have superuser access privileges. host replication postgres 192.168.0.20/22 trust I strongly recommend you don't use those settings, since they result in no security at

Re: [BULK] Re: [GENERAL] Streaming Replication woes

2011-11-16 Thread Sean Patronis
Konstantin, Just back from some time off and read this reply. This was exactly the issue. The superuser "postgres" did not have this role since this was a dump/restore/upgrade from postgres 8.4. I just created a new Role and user, and it all worked! Thanks! --Sean On 11/06/2011 06:41 P