Geo: Use a background WAL receiver and replication slot to improve initial sync
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