Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question