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