Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL Dump rate is too slow - Mailing list pgsql-admin

From girish R G peetle
Subject PostgreSQL Dump rate is too slow
Date
Msg-id CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Dump rate is too slow  (David G Johnston <david.g.johnston@gmail.com>)
Re: PostgreSQL Dump rate is too slow  (Jeff Frost <jeff@pgexperts.com>)
Re: PostgreSQL Dump rate is too slow  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
Re: PostgreSQL Dump rate is too slow  ("ktm@rice.edu" <ktm@rice.edu>)
Re: PostgreSQL Dump rate is too slow  (Eduardo Morras <emorrasg@yahoo.es>)
List pgsql-admin
Tree view
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 production server.  
Is there is a way to increase dump data rate ?

pg_dump -U <User> -Fc -b --port=<Port> '<Db-Name>'


PostgreSQL version : 9.2.4
Platform : Linux

Thanks
Girish

pgsql-admin by date:

Previous
From: Ian Barwick
Date:
Subject: Re: The quickest way to migrate database within the same cluster
Next
From: David G Johnston
Date:
Subject: Re: PostgreSQL Dump rate is too slow