I am using PostgreSQL 9.1 on Redhat Linux on my Production environment. My database size is 680 GB and it take 7 hour for completion the pg_dump backup.
I want that my pg_dump backup should be fast and take less time.
In PostgresQL 9.3 there is “ -j /njobs” /option is available for fast pg_dump backup.
There is any way, that I will use *“ **-j /njobs”/*/option /in “PostgreSQL 9.1 “ so that my backup is completed in less time or any other way in ”PostgreSQL 9.1” to take the backup fast. Kindly suggest?
In addition to Scott's suggestions have you looked at replication?:
+1 - It doesn't actually lower the base backup time, but, there's little overhead for archiving (other than storage space) and restoration is just starting an instance and replaying a few logs. Much faster. You can use a tool like WAL-E or barman to build out a nice strategy.
At the end of the day, you'll still want to do a periodic, logical backup (make sure your phyiscal backups are sane), but, using physical backups will open you up to many more options.
