On Thu, Jul 7, 2011 at 1:05 PM, David Hartveld <david.hartv...@mendix.com> wrote: > > The following bug has been logged online: > > Bug reference: 6094 > Logged by: David Hartveld > Email address: david.hartv...@mendix.com > PostgreSQL version: 9.1-beta2 > Operating system: Debian GNU/Linux 6.0.2 "Squeeze" > Description: Streaming replication does not catch up when writing > enough data > Details: > > After creation of two new clusters, and setting them up as master and slave > (in async mode, according to the current 9.1 docs), the execution of a large > SQL script (creating a db, tables, sequences, etc., filling them with data > through COPY) runs properly on the master, but does not stream to the slave, > i.e. the slave does not catch up. In the master log, the following line is > printed many times:
Your output indicates that there is a problem in your replication setup and this is why the slave does not catch up. This is not a performance issue. It is either a bug in replication, or a user configuration issue. Since few things have changed in 9.1 in this area, at the moment the balance of probablity if user error. If you can provide a more isolated bug report we may be able to investigate. This is being discussed in a thread on the General list and there is no reason to post twice. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs