PostgreSQL Dump rate is too slow

From: girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL Dump rate is too slow
Date: 2015-01-08 05:35:54
Message-ID: CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G Johnston 2015-01-08 05:45:37 Re: PostgreSQL Dump rate is too slow
Previous Message Ian Barwick 2015-01-04 07:42:26 Re: The quickest way to migrate database within the same cluster