Postgres Database Backup Size

From: Shiwangini Shishulkar <shiwangini(dot)shishulkar(at)webgility(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Database Backup Size
Date: 2019-08-12 06:23:33
Message-ID: CAD8gUhivhJqOQna_8ixirhz6=dukdQZ3ruXWg7+orkw28A=yzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 more than 100GB for 50GB database
size. Due to some business requirement , we need to restore each backup
daily.

Here, I'm taking backup via below sample statement:

pg_dump -U postgres -d welcome -f welcome_${DATE}.sql

I had also tried with compressed backups via -Fc. But, since it is
compressed, in case of restoration -> first it decompresses the backup and
restore it. Which again takes a lot of time.

Any way to reduce backup size of postgres backups or it's default behavior
of postgres to take backups which are double in size?

Thanks,
Shiwangini

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2019-08-12 07:39:02 Re: Postgres Database Backup Size
Previous Message stan 2019-08-11 23:01:58 [SOLVED] Re: A question about trigger fucntion syntax