The following bug has been logged online:
Bug reference: 5033
Logged by: Raja Rayaprol
Email address: raja.rayaprol@swift.com
PostgreSQL version: 8.4
Operating system: HP-UX
Description: Fallback using Warm Standby
Details:
I am applying archive logs at a warm standby and then brought up the
standby. However if I want to set up the old primary as a standby, I am
required to clone the standby to the primary.
It is not practical to do such cloning across a WAN for a large database,
and Oracle allows you to switch roles without requiring the standby to be
recreated.
I would like to know if there is demand for similar functionality from
Postgres users, and whether PostgreSQL Plus (or other variant) offer any
relief in this area ?
Thanks and regards