On Thu, Oct 18, 2018 at 8:26 AM Raghavendra Rao J S V <raghavendrajsv@xxxxxxxxx> 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
