| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | SathishKumar R <mail(dot)to(dot)sathishkumar(dot)raja(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Backup and Recovery related |
| Date: | 2024-02-22 17:50:53 |
| Message-ID: | ZdeJfXQ83krPouxf@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Greetings,
* SathishKumar R (mail(dot)to(dot)sathishkumar(dot)raja(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lucio Chiessi | 2024-02-22 19:14:24 | Another way to do audit in DML operations in PostgreSQL >= 14 |
| Previous Message | Stephen Frost | 2024-02-22 17:48:40 | Re: Use AD-account as login into Postgres. |