[pgpool-general: 6249] Online Recovery vs WAL acrhiving

Andre Piwoni apiwoni at webmd.net
Sat Oct 20 06:57:15 JST 2018


It seems that online recovery scripts take base backup of the primary
to recover downed node.
With streaming replication and WAL archiving enabled downed node can
be recovered when it is started again much faster than taking entire
base backup of the primary.
So question comes to mind, what is the advantage of using
time-consuming online recovery over WAL archiving restore process?
Is attaching downed node to PgPool automatically the only benefit?

Thank you,
Andre Piwoni


More information about the pgpool-general mailing list