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 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