Project: [PG]: Use compressed dumps for backup

Created on 4 Dec 2017  路  1Comment  路  Source: kubedb/project

pg_dumpall is slow for big size database

dpostgres research stash
Source
picture tamalsaha
👍4

Most helpful comment

Please add snapshot/backup compression, uncompressed sql-dumps are very large.

In my case:
database on-disk (du -h /var/pv/data/base/): 380mb
umcompressed sql-dump: 840mb
gzip-compressed dump: 17.4mb (compressed size is only ~2% of uncompressed size)

picture david-ecc on 8 Apr 2019
👍3

>All comments

Please add snapshot/backup compression, uncompressed sql-dumps are very large.

In my case:
database on-disk (du -h /var/pv/data/base/): 380mb
umcompressed sql-dump: 840mb
gzip-compressed dump: 17.4mb (compressed size is only ~2% of uncompressed size)

david-ecc picture david-ecc on 8 Apr 2019
👍3
Was this page helpful?
0 / 5 - 0 ratings

Related issues

yazfaz picture yazfaz  路  4Comments
pjebs picture pjebs  路  3Comments
stephan2012 picture stephan2012  路  9Comments
iamliamc picture iamliamc  路  9Comments
botzill picture botzill  路  5Comments