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	January 8, 2015 08:36:00
Msg-id	CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com Whole thread Raw
Responses	Re: PostgreSQL Dump rate is too slow Re: PostgreSQL Dump rate is too slow Re: PostgreSQL Dump rate is too slow Re: PostgreSQL Dump rate is too slow Re: PostgreSQL Dump rate is too slow
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:

From: Ian Barwick
Date: 04 January 2015, 10:42:41
Subject: Re: The quickest way to migrate database within the same cluster

From: David G Johnston
Date: 08 January 2015, 08:45:47
Subject: Re: PostgreSQL Dump rate is too slow

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

Previous

Next