Re: PostgreSQL Dump rate is too slow

> On Jan 7, 2015, at 21:35, girish R G peetle <giri.anamika0@gmail.com> wrote:
>
> Hi all,
> We have a customer who has 1TB database on a production server. They are trying dump based backup of this large
database.Following dump command is being used.  
> Dump rate is around 12 GB/hr, which will take lot of time for the backup to complete. This is affecting their
productionserver.   
> Is there is a way to increase dump data rate ?
>
> pg_dump -U <User> -Fc -b --port=<Port> '<Db-Name>'
>

You could reduce the compression ratio. Gzip defaults to -Z6, but -Z3 is quite a bit quicker with not that much larger
dumpfile.   

I did a few tests here: http://frosty-postgres.blogspot.com/2011/12/pgdump-compression-settings.html

Also, if it's is impacting production, you could set up a streaming replica and take the dump from the replica.