PostgreSQL Dump rate is too slow

Поиск
Список
Период
Сортировка
От girish R G peetle
Тема PostgreSQL Dump rate is too slow
Дата
Msg-id CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: The quickest way to migrate database within the same cluster
Следующее
От: David G Johnston
Дата:
Сообщение: Re: PostgreSQL Dump rate is too slow