Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.

[Raghavendra Rao J S V <raghavendrajsv@xxxxxxxxx>]

We are using postgresql 9.2. It doesn't contain the option. 

Please guide me any other approaches to improve the performance of pg_dump.

On Thu 11 Oct, 2018, 8:05 AM Pavan Teja, <pavan.postgresdba@xxxxxxxxx> wrote:

Hi,

You can use -j jobs option to speed up the process.

Hope it works.

Regards,

Pavan

On Thu, Oct 11, 2018, 8:02 AM Raghavendra Rao J S V <raghavendrajsv@xxxxxxxxx> wrote:

Hi All,

pg_dump is taking more time. Please let me know which configuration setting we need to modify to speedup the pg_dump backup.We are using 9.2 version on Centos Box.

--

Regards,
Raghavendra Rao J S V