Page MenuHomeSoftware Heritage

PostgreSQL backups based on pg_dump
Open, NormalPublic

Description

Some databases could benefit from some backups without the overhead of having point in time recovery set up for them:

  • softwareheritage-indexer (somerset)
  • softwareheritage-scheduler (belvedere)
  • swh-lister

...

I've sent a query on the freenode #postgresql channel, trying to see if there exist a tool, akin to autopostgresqlbackup but a bit more flexible. No reply yet.

Event Timeline

ardumont updated the task description. (Show Details)Jun 20 2019, 1:53 PM
twitu added a subscriber: twitu.Mon, Jun 24, 6:54 PM

While I was adding comments to all the tables in the db, I experimented a bit with pgdump.

Some databases could benefit from some backups without the overhead of having point in time recovery set up for them

If I understand correctly, it means that recovery from all previous time stamps is not a concern here. In such a case, is a chron job running pgdump at regular intervals feasible?