On Thu, Jan 14, 2010 at 9:15 AM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > Imagine this scenario: > > 1. Master is up and running, standby is connected and streaming happily > 2. Network goes down, connection is broken. > 3. Standby falls behind a lot. Old WAL files that the standby needs are > archived, and deleted from master. > 4. Network is restored. Standby reconnects > 5. Standby will get an error because the WAL file it needs is not in the > master anymore. > > What will currently happen is: > > 6, Standby retries connecting and failing indefinitely, until the admin > restarts it. > > What we would *like* to happen is: > > 6. Standby fetches the missing WAL files from archive, then reconnects > and continues streaming. > > Can we fix that?
Just MHO here, but this seems like a bigger project than we should be starting at this stage of the game. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
