Re: PostgreSQL Dump rate is too slow

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.