Is there any link where the required setup and the step by step procedure for performing the controlled switchover are listed?
Thanks Raj On Tue, Feb 19, 2019 at 4:44 PM Michael Paquier <mich...@paquier.xyz> wrote: > On Tue, Feb 19, 2019 at 04:27:02PM -0800, RSR999GMAILCOM wrote: > > So wanted to clarify if this procedure really requires the WAL archive > > location on a shared storage ? > > Shared storage for WAL archives is not a requirement. It is perfectly > possible to use streaming replication to get correct WAL changes. > Using an archive is recommended for some deployments and depending on > your requirements and data retention policy, still you could have > those archives on a different host and have the restore_command of the > standbyt in recovery or the archive_command of the primary save the > segments to it. Depending on the frequency new WAL segments are > generated, this depends of course. > -- > Michael >