Thread: Incremental Backup via WAL archive
Good day Team.
I would like to have your insights regarding my above-mentioned inquiry.
I'm currently assigned to perform a DBA task and have a look at the incremental backup routine using WAL archives (we're currently using Postgresql for Windows) which will be maintained as a daily backup.
I would like to have your insights regarding my above-mentioned inquiry.
I'm currently assigned to perform a DBA task and have a look at the incremental backup routine using WAL archives (we're currently using Postgresql for Windows) which will be maintained as a daily backup.
The objective of the daily backup is to have a small file/files of new data or changes in the database that can be played or resumed using the related (nearest) basebackup and afterwards it can be kept and archived for a long time.
Recently, I performed a test on one of the servers and found out that within 1 hour, the overall wal files is around 1GB already as the main DB is just 900+MB if backup using pg_dump.
What would be the best approach for daily backups? We have 2 systems that are 9GB in size already (very heavy to store on a daily basis).
Looking forward to your best recommendation.
Thank you.
Recently, I performed a test on one of the servers and found out that within 1 hour, the overall wal files is around 1GB already as the main DB is just 900+MB if backup using pg_dump.
What would be the best approach for daily backups? We have 2 systems that are 9GB in size already (very heavy to store on a daily basis).
Looking forward to your best recommendation.
Thank you.
> On 29 Jun 2022, at 13:15, christine sarsonas <ctsarsonas@gmail.com> wrote: > > What would be the best approach for daily backups? Hi! It's very easy to setup Point-in-time recovery with PostgreSQL. The Postgres ecosystem have a lot of different PIT solutions.For example, you can use WAL-G. [0] But for Windows you will need to build exe file manually. I think there must be other tools providing exe binaries out ofthe box. Thank you! Best regards, Andrey Borodin. [0] https://supabase.com/blog/2020/08/02/continuous-postgresql-backup-walg