From: Heikki Linnakangas on 14 Jan 2010 09:15 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? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
|
Pages: 1 Prev: segmentation fault in function Next: Streaming replication, retrying from archive |