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

Re: [GENERAL] Streaming Replication woes

2011-11-08 Thread Fujii Masao
On Tue, Nov 8, 2011 at 3:45 AM, Konstantin Gredeskoul wrote: > The user 'postgres' was created using standard database installation > procedure.  It has superuser, but does not include an explicit replication > role: > > my_db=# \du >                       List of roles > Role name  |            A

Re: [GENERAL] Streaming Replication woes

2011-11-06 Thread Fujii Masao
On Mon, Nov 7, 2011 at 8:41 AM, Konstantin Gredeskoul wrote: > Does that mean "postgres" superuser is no longer able to also be a > replication user in 9.1?  If so this is not yet updated on the > Replication wiki. No. Superuser has the replication privilege by default. But if you granted the "po

Re: [GENERAL] Streaming Replication woes

2011-11-06 Thread Konstantin Gredeskoul
Sean, I saw your email on PostgreSQL general list about replication. We are using 9.1.1 and were having the same issue, unable to setup replication even though following wiki precisely.  I was able to setup replication following wiki steps using PG 9.0.3, but not 9.1.1. Then I found this page: h

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: [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/Streaming_Replication

Re: [GENERAL] Streaming Replication woes

2011-11-04 Thread Simon Riggs
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 all. It won't block you from getting repl

Re: [GENERAL] Streaming Replication woes

2011-11-04 Thread Thom Brown
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 Patronis  wrote: >>> >>> I am running Postgres 9.1 >>> >>> I have followed the howto here: >>> http://wiki.postgresql.org/wiki/Streaming_Replication >>> >>> I am attempti

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 error

Re: [GENERAL] Streaming Replication woes

2011-11-04 Thread Raghavendra
* * On Fri, Nov 4, 2011 at 8:20 PM, 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 error in the postgres log