| 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 05:45:37 |
| Message-ID: | 1420695937661-5833280.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
girish R G peetle wrote
> Hi all,
> We have a customer who has 1TB database on a production server. They are
> trying dump based backup of this large database. Following dump command is
> being used.
> Dump rate is around 12 GB/hr, which will take lot of time for the backup
> to
> complete. This is affecting their production server.
> Is there is a way to increase dump data rate ?
>
> pg_dump -U
> <User>
> -Fc -b --port=
> <Port>
> '
> <Db-Name>
> '
>
>
> PostgreSQL version : 9.2.4
> Platform : Linux
>
> Thanks
> Girish
Use a 9.3+ version of pg_dump with the --jobs option and directory output.
David J.
--
View this message in context: http://postgresql.nabble.com/PostgreSQL-Dump-rate-is-too-slow-tp5833279p5833280.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2015-01-08 05:50:19 | Re: PostgreSQL Dump rate is too slow |
| Previous Message | girish R G peetle | 2015-01-08 05:35:54 | PostgreSQL Dump rate is too slow |