I
I
ironheaddd2020-03-10 18:29:13
PostgreSQL
ironheaddd, 2020-03-10 18:29:13

How and with what to set up an incremental PostgreSQL backup?

There is a database on PostgreSQL, which grows daily by an average of 100 MB.
There is a bash script that makes a backup every hour and puts it on the storage system. At the moment, the database weighs about 5.5 GB, it takes 20 minutes to create a backup, which cannot but disturb, and therefore the question arose: how and with what to set up an incremental database backup?
Ideally, we would get the following scheme: a full backup is created, and then when changes are made to the database, only a backup of the changes is created.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2020-03-10
@ironheaddd

Judging by the desire to backup surprisingly often - you are trying to find PiTR.
In general: https://www.postgresql.org/docs/current/continuous...
In particular: wal-g, barman, pgbackrest so as not to build the constructor manually.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question