Обсуждение: Backup and Recovery related

Поиск
Список
Период
Сортировка

Backup and Recovery related

От
SathishKumar R
Дата:
Hello All,

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 ?

Regards,
Sathish

Re: Backup and Recovery related

От
Stephen Frost
Дата:
Greetings,

* SathishKumar R (mail.to.sathishkumar.raja@gmail.com) 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

Вложения