On Wed, 2008-12-10 at 14:39 +0200, Heikki Linnakangas wrote: > For a solution that doesn't depend on the file-based log shipping, I > think we'll need a way for the standby to request a certain starting > point for the streaming when it connects. When the standby starts, it > would first recover all the log segments it can obtain using > recovery_command, and then connect to the primary and request to > start > streaming from where recovery_command stopped.
That was already suggested and rejected because it introduces a potentially unacceptable delay in the start of synch replication - for large databases this could be hours. (I should add it was suggested by me and I now accept that it should be rejected.) -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers