Re: How to reduce pg_dump backup time

> On Oct 6, 2015, at 00:52, Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> 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(at)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