From: | Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to reduce pg_dump backup time |
Date: | 2015-10-06 04:52:16 |
Message-ID: | CAFzqEhLkQgyOxm=XpG0DCmnFJ=6Lws5rHu+abUsvHDrE9U4b7g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
*[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
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Clavadetscher | 2015-10-06 05:15:39 | Re: Selecting pairs of numbers |
Previous Message | Bruce Momjian | 2015-10-06 01:03:58 | Re: to_number, to_char inconsistency. |