pg_dump backup utility is taking more time around 24hrs to take thebackup of 28GB

Поиск
Список
Период
Сортировка
От Raghavendra Rao J S V
Тема pg_dump backup utility is taking more time around 24hrs to take thebackup of 28GB
Дата
Msg-id CAEHH7R4iZVS7Ew9iyGtMAu+yjZgpoZ-uq_hZqSaYHAgxH-nysQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB
RE: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB
Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB
Список pgsql-general
Дерево обсуждения
Hi All,

We are using pg_dump backup utility in order to take the backup of the database. Unfortunately,it is taking around 24hrs of time  to take the backup of  28GB database. Please guide me how to reduce the time and is there any parameter need to be modified which will help us to reduce the backup time. We are using Postgres 9.2 version

Note:-Kindly suggest me options using pg_dump only.

--
Regards,
Raghavendra Rao 

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

Предыдущее
От: Alessandro Aste
Дата:
Сообщение: convert real to numeric.
Следующее
От: Ozz Nixon
Дата:
Сообщение: Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB