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

2018-10-19 Thread Jeff Janes
On Thu, Oct 18, 2018 at 8:26 AM Raghavendra Rao J S V < raghavendra...@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 t

RE: pg_dump backup utility is taking more time around 24hrs to take the backup of 28GB

2018-10-19 Thread Kevin Brannen
From: Raghavendra Rao J S V [mailto:raghavendra...@gmail.com] Sent: Thursday, October 18, 2018 7:26 AM To: pgsql-general@lists.postgresql.org Subject: pg_dump backup utility is taking more time around 24hrs to take the backup of 28GB Hi All, We are using pg_dump backup utility in order to take t

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

2018-10-18 Thread Ozz Nixon
There are many possible problems, could you share your command line? For example. Dump on SAME drive as the DB files, can produce disk contention. Dump across the network, can have packet collision of network latency. I dump 20gb test server in a matter of a couple minutes here. But, I run multipl