Greetings, * SathishKumar R (mail.to.sathishkumar.raja@xxxxxxxxx) 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. Thanks, Stephen
Attachment:
signature.asc
Description: PGP signature
