Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB - Mailing list pgsql-general

From Jeff Janes
Subject Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB
Date
Msg-id CAMkU=1wVHwQ8wy=qOh9sTYJ3V52jpWkMOU3oXds2=k2zr564Hg@mail.gmail.com
Whole thread Raw
In response to pg_dump backup utility is taking more time around 24hrs to take thebackup of 28GB  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Kevin Brannen
Date:
Subject: RE: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB
Next
From: Thiemo Kellner
Date:
Subject: Re: What is the problem with this code?