itbm/postgresql-backup-s3

Use pg_dump custom format

natali-maximenko opened this issue · 2 comments

Hi there,

store dump in gz is nice idea, but PG can do this by -Fc option

pg_dump $POSTGRES_HOST_OPTS $POSTGRES_DATABASE -Fc > $SRC_FILE.gz

Custom format work faster then redirecting to gzip. I think it is important when dump isn't small.

Thank you for making this image, is very cool!

It would be helpful to include the custom format, as for the database size of 50GB it takes around 15 mins to backup the database in plain format. Please update and release, and thanks a lot for the increments to the base image!

FYI you don't need the .gz in > $SRC_FILE.gz as SRC_FILE already has the .gz extension at the end. The -Fc option is a good addition though, good idea!