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