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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
