Hi Scott - > > But. When the primary is vacuumed, re-indexed and all clean and shiny > > again, HOW do I catch up with data changes that happened in the meantime on > > my warm standby without corruption or >30 minutes of user down-time? I > > cannot re-ingest WALs from the warm standby into the cleaned up primary or I > > get a PANIC, and I don't have time to run a full backup on the warm standby > > and ingest it into the primary leaving everything down. > > If you've moved on, so to speak, with the new primary, you restart the > old primary, now warm standby, the same way you initially created the > warm standby. issue the start hot backup command to the primary, copy > over all the data dir and start shipping WAL files to it before you > start continuous recovery.
If I do that, the primary will not be clean anymore. It will be as unvacuumed and index-bloated as the warm standby. Or am I missing something? Thanks, Jennifer _________________________________________________________________ Insert movie times and more without leaving Hotmail®. http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd_062009
