Re: [GENERAL] Can someone help explain what's going on from the attached logs?

2011-10-27 Thread Simon Riggs
On Wed, Oct 26, 2011 at 6:41 PM, Chris Redekop ch...@replicon.com wrote: Caveat #2 applies here http://developer.postgresql.org/pgdocs/postgres/hot-standby.html#HOT-STANDBY-CAVEATS The consistent state is delayed until your long running transactions end, which is workload dependent but

Re: [GENERAL] Can someone help explain what's going on from the attached logs?

2011-10-26 Thread Chris Redekop
Caveat #2 applies here http://developer.postgresql.org/pgdocs/postgres/hot-standby.html#HOT-STANDBY-CAVEATS The consistent state is delayed until your long running transactions end, which is workload dependent but transient. I'm not quite sure how this correlates to what I'm seeing in

Re: [GENERAL] Can someone help explain what's going on from the attached logs?

2011-10-25 Thread Simon Riggs
On Tue, Oct 18, 2011 at 6:39 PM, Samuel Hwang sam...@replicon.com wrote: The log is getting from PostgreSQL 9.0.4 Basically we set up streaming replication hot-standby slave while master is under heavy load The slave started but not accepting read-only queries, every request will trigger the

Re: [GENERAL] Can someone help explain what's going on from the attached logs?

2011-10-24 Thread Craig Ringer
On 19/10/11 01:39, Samuel Hwang wrote: The log is getting from PostgreSQL 9.0.4 Basically we set up streaming replication hot-standby slave while master is under heavy load The slave started but not accepting read-only queries, every request will trigger the FATAL: the database system is

[GENERAL] Can someone help explain what's going on from the attached logs?

2011-10-18 Thread Samuel Hwang
The log is getting from PostgreSQL 9.0.4 Basically we set up streaming replication hot-standby slave while master is under heavy load The slave started but not accepting read-only queries, every request will trigger the FATAL: the database system is starting up error. The slave will eventually