Skip to content

Geo: Use a background WAL receiver and replication slot to improve initial sync

Stan Hu requested to merge sh-replicate-with-slot into master

In the current mode, WAL segments are only retrieved after the initial snapshot has finished: https://www.postgresql.org/docs/10/static/app-pgbasebackup.html

For large databases, by the time the initial snapshot is taken, the relevant WAL files may have been removed already. We can improve this by using the -X stream and -S options:

  • -X stream: Stream the WAL while the base backup is running
  • -S: Use a replication slot to stream

Relates to:

Edited by GitLab Release Tools Bot

Merge request reports