| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | christine sarsonas <ctsarsonas(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Incremental Backup via WAL archive |
| Date: | 2022-06-30 11:52:44 |
| Message-ID: | 570BA187-1FAA-42E0-A29B-DB4A3497A532@yandex-team.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> On 29 Jun 2022, at 13:15, christine sarsonas <ctsarsonas(at)gmail(dot)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 of the box.
Thank you!
Best regards, Andrey Borodin.
[0] https://supabase.com/blog/2020/08/02/continuous-postgresql-backup-walg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sbob | 2022-06-30 23:18:58 | Quartz Scheduler + pgpool + PostgreSQL 12 = issues |
| Previous Message | Andrey Borodin | 2022-06-30 11:48:06 | Re: Long running backup preventing auto vacuum |