Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB
Дата
Msg-id CAMkU=1wVHwQ8wy=qOh9sTYJ3V52jpWkMOU3oXds2=k2zr564Hg@mail.gmail.com
обсуждение исходный текст
Ответ на pg_dump backup utility is taking more time around 24hrs to take thebackup of 28GB  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Oct 18, 2018 at 8:26 AM Raghavendra Rao J S V <raghavendrajsv@gmail.com> wrote:
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

What minor version?  How long does it take to do just a pg_dump -s?  Can you use system tools (like top in Linux) to identify the bottleneck as CPU, disk, etc.?

Cheers,

Jeff

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

Предыдущее
От: Kevin Brannen
Дата:
Сообщение: RE: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB
Следующее
От: Thiemo Kellner
Дата:
Сообщение: Re: What is the problem with this code?