Re: [HACKERS] Streaming Replication: sql error on standby

2010-06-27 Thread Simon Riggs
On Wed, 2010-06-23 at 10:48 +0200, Sander, Ingo (NSN - DE/Munich) wrote: > Sql query "select pg_last_xlog_receive_location(); " does not work > during startup of standby database. Thanks for the report. We need to understand more about what you are saying. There is no error message with that te

Re: [HACKERS] Streaming Replication: sql error on standby

2010-06-25 Thread Robert Haas
On Wed, Jun 23, 2010 at 4:48 AM, Sander, Ingo (NSN - DE/Munich) wrote: > Sql query "select pg_last_xlog_receive_location(); " does not work during > startup of standby database. > TestScenario; > We have a active-standby system with PostgreSQL Streaming Replication beta2. > If the active database

[HACKERS] Streaming Replication: sql error on standby

2010-06-25 Thread Sander, Ingo (NSN - DE/Munich)
Hi, Sql query "select pg_last_xlog_receive_location(); " does not work during startup of standby database. TestScenario; We have a active-standby system with PostgreSQL Streaming Replication beta2. If the active database is up the database is in use (read/write queries will be performed). The