Re: PostgreSQL Dump rate is too slow

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL Dump rate is too slow
Date: 2015-01-08 15:38:37
Message-ID: CAKFQuwaCwXdkO_4a6-SsxX-_MOBNnZZQQF41R-YWphN5MwFkqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Jan 8, 2015 at 12:12 AM, Adalkonda Harshad [via PostgreSQL] <
ml-node+s1045698n5833283h97(at)n5(dot)nabble(dot)com> wrote:

>
> As the database size is too large and tweaking few database parameters
> will result towards performance improvement on pg_dump to some extent and
> pg_dump -j option would have helped if the DB version is PostgreSQL 9.3 but
> unfortunately your DB version is PostgreSQL 9.2
>
>
​pg_dump 9.3+ can be used against the 9.2 server without problems. Read
the documentation for the --jobs option for details.

David J.

--
View this message in context: http://postgresql.nabble.com/PostgreSQL-Dump-rate-is-too-slow-tp5833279p5833319.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ktm@rice.edu 2015-01-08 15:44:04 Re: PostgreSQL Dump rate is too slow
Previous Message Kevin Grittner 2015-01-08 13:58:11 Re: PostgreSQL Dump rate is too slow