Some databases could benefit from some backups without the overhead of having point in time recovery set up for them:
...
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.
| Status | Assigned | Task | ||
|---|---|---|---|---|
| Migrated | gitlab-migration | T881 PostgreSQL backups based on pg_dump | ||
| Migrated | gitlab-migration | T880 Add softwareheritage-indexer backup | ||
| Migrated | gitlab-migration | T944 Separate indexer db to its own postgresql cluster |
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?