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 to be bigger than
the original database. How did you measure the database size?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com