Re: Postgres Database Backup Size

2019-08-12 Thread Laurenz Albe
Shiwangini Shishulkar wrote: > Any way to reduce backup size of postgres backups or it's default behavior of > postgres to take backups which are double in size? The smallest backup would be a compressed custom format "pg_dump": pg_dump -F c -Z 9 ... I is very unusual for a custom format dump

Postgres Database Backup Size

2019-08-11 Thread Shiwangini Shishulkar
Hi, Here , we have first tried with .BAK backups. For, 43GB database-> the backup size was ~86GB. Then, I configured backup with .sql file. Here it was ~70GB for the same database size. Next, now our database size keeps increasing. As well as backup size is also increasing. Now, backup size is