Feature requests - Githubissues

k0lter / autopostgresqlbackup

Automated tool to make periodic backups of PostgreSQL databases

52 stars 17 forks source link

Closed kwoot closed 10 months ago

kwoot commented 4 years ago

Hi,

I have a few feature requests for this script that I sort of install on every server I setup:

Compress dump file during creation of dump. Due to large dumps really dipping filespace before zipping.
Option to disable weekly, montly backups. Due to sometimes going back more than a week is just not an option but daily backups are very much needed.

Kind regards, Jeroen Baten

PurplePingu commented 2 years ago

It would also be great to capture the database permissions as well. This might require use of pg_dump --schema-only to a seperate file from what I saw at https://dba.stackexchange.com/questions/132610/export-roles-with-privileges-under-postgresql-9-3

k0lter commented 1 year ago

@kwoot I've just pushed some changes (they will be part of version 2.0) which addressed your feature requests. See Changelog.md for details.

k0lter commented 1 year ago

@PurplePingu This is already supported, PostgreSQL globals are dumped into a "virtual database" named postgres-gloabals.

k0lter commented 10 months ago

I'm closing this bug as it is already solved.