Re: Postgres Database Backup Size - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Postgres Database Backup Size
Date
Msg-id 9638676cdd3274bc76a7f41503156732f9dac8dc.camel@cybertec.at
Whole thread Raw
In response to Postgres Database Backup Size  (Shiwangini Shishulkar <shiwangini.shishulkar@webgility.com>)
List pgsql-general
Shiwangini Shishulkar wrote:
> Any way to reduce backup size of postgres backups or it's default behavior of postgres to take backups which are
doublein 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




pgsql-general by date:

Previous
From: Shiwangini Shishulkar
Date:
Subject: Postgres Database Backup Size
Next
From: "James(王旭)"
Date:
Subject: How to gracefully keep my specific index in memory ?