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
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
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
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
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