Re: Backup and Recovery related

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



* SathishKumar R ( wrote:
> Our organisation is now implementing a backup and recovery process.We use
> Debezium to collect change data, which requires wal_level=logical.
> Our backup method is as follows: every third day, full backup, and
> incremental backups for the remaining days.
> Is it feasible to take physical and incremental backups with
> wal_level=logical and archive_mode=on in postgres-15 ?

Yes, wal_level=logical is fine for doing online backups with PG.  I'd
suggest you look into a backup tool like pgBackRest for your physical
backups, which supports both full and incremental backups.



Attachment: signature.asc
Description: PGP signature

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux