Re: pg_basebackup + incremental base backups

Greetings,

* Christopher Pereira ([email protected]) wrote:
> Our stream replication slave server got out of sync so we need to base
> backup again.

If you do WAL archiving instead of depending on the WAL to exist on the
primary then a replica can catch up using WAL.  Having a WAL archive
also means you can do point-in-time-recovery for any point.

> In case of big databases, can we do incremental backups with pg_basebackup?

pg_basebackup doesn't support incremental backups, though there's been
discussion of adding some kind of support for it, check -hackers if
you're curious.

> Is there any alternative?

There's a few different alternatives for PG backup software, some of
which support incremental backups and restores.  I'm personally involved
with pgbackrest- https://pgbackrest.org though there's other options out
there also (wal-g, barman, and more).

Thanks,

Stephen

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJd5yNTAAoJEO1sijiDR2RVyecQAJh1JSwxdpij7sTGs8q7DhN0
9rdN/ZOmI1x5IfQxXMfJuljBZrhwzoHizoeztBh7GessUHUTy1TrSrDiVB7yCUfE
4X/fF2Z/UA7BHz0m5qd7Vrejp0y7Qab7DexCCKsa8/dSVZ/vQdzKEGwFMyaymgzp
mu6LPZUFHF5f+D854oQZoWw5W81YNDSr7vGQwmbmTZnNTP+sd4rJAiPnoKS6nOyY
gwsGq1rzgsF7D8d+/gH39F0A3DklbEs2JEmjxc8QxWxJSDcY6k664ZotfubuE0OS
64iNu7pLE1M/rGA0rf+da/Kd6j1qFtBrh9b9bk7IoFk1WHrMjtzqPwwOyQlJgIAu
suqkRN8tLc8x9YQ5av8IskjDr8q1V8oDSHDFF17PvSNgJavMe4vWH0x5oHE0MaZV
Tz0zDThoJFeHlm7kolVC4gEzWEybL3Q8zjNTnhjeGtBJRtu+v2DBNL27MvXzoSI4
hjtapml+lkNTEZgP1em38kB6vRY7X357jb+tNVPN0bdjkRgeyQrNED/DclOqEo08
yM7ocJ9rAQH5oLLyosIDrz7EVZFrDTQ+H8h+uEOrAdOEtTRFL8R74PsIs95w2jdY
yHxFEMDyUDsMtpaPXvg9l/M+b/CLZv4gkpizREm5AN254zkdkZertPae+jGk9Ppg
P1MP3twg/9MWKvT0oOXF
=DALV
-----END PGP SIGNATURE-----