Postgres Pro
Downloads
Home   >   mailing lists

pg_dump backup utility is taking more time around 24hrs to take thebackup of 28GB - Mailing list pgsql-general

From Raghavendra Rao J S V
Subject pg_dump backup utility is taking more time around 24hrs to take thebackup of 28GB
Date
Msg-id CAEHH7R4iZVS7Ew9iyGtMAu+yjZgpoZ-uq_hZqSaYHAgxH-nysQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB  (Ozz Nixon <ozznixon@gmail.com>)
RE: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB  (Kevin Brannen <KBrannen@efji.com>)
Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Alessandro Aste
Date:
Subject: convert real to numeric.
Next
From: Ozz Nixon
Date:
Subject: Re: pg_dump backup utility is taking more time around 24hrs to takethe backup of 28GB