On Tue, Oct 6, 2015 at 8:54 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 10/05/2015 09:52 PM, Sachin Srivastava 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?
In addition to Scott's suggestions have you looked at replication?:
http://www.postgresql.org/docs/9.1/interactive/high-availability.html
Basically, continuous backup.
+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.
--
Scott Mead
Sr. Architect
OpenSCG
Sr. Architect
OpenSCG
*[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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
