Re: How to reduce pg_dump backup time

[Scott Mead <scottm@xxxxxxxxxxx>]

On Oct 6, 2015, at 00:52, Sachin Srivastava <ssr.teleatlas@xxxxxxxxx> wrote:

Dear Team,

 

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?

 

If you're using compression, disable it. It'll require more space, but would be faster. Honestly, you should upgrade to a newer version, 9.1 is EOL in slightly less than 1 year. 

  For the upgrade, you can use a newer version of pg_dump. I'm not sure if the parallel option would be available against a 9.1 server (but it's worth a try). I wouldn't try restoring that dump to a 9.1 server, just use it to upgrade to 9.4. 

 

[root]# lsb_release –a

 

LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: RedHatEnterpriseServer

Description:    Red Hat Enterprise Linux Server release 6.7 (Santiago)

Release:        6.7

Codename:       Santiago

 

[root@CPPMOMA_DB01 even]# psql

Password:

psql.bin (9.1.2)

Type "help" for help.

 

postgres=# select version();

                                                    version

---------------------------------------------------------------------------------------------------------------

 PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit

(1 row)

 

postgres=#

 

 

 

 

Regards,

Sachin Srivastava