Re: WAL archiving and backup TAR - Mailing list pgsql-admin

From Michael Monnerie
Subject Re: WAL archiving and backup TAR
Date
Msg-id 200906221104.48737@zmi.at
Whole thread Raw
In response to WAL archiving and backup TAR  (torrez <torrez@unavco.org>)
List pgsql-admin
On Freitag 19 Juni 2009 torrez wrote:
> time tar -czf /pbo/podbackuprecovery/tars/pod-backup-$
> {CURRDATE}.tar.gz /pbo/pod > /pbo/podbackuprecovery/pitr_logs/backup-
> tar-log-${CURRDATE}.log 2>&1

If you have a multi-core/multi-CPU machine, try to used pbzip2 (parallel
bzip2), which can use all CPU cores at the same time for compression.
The simplest might be
tar cf backup.tar ..... (first the tar without compression to finish
quickly)
pbzip2 backup.tar

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4


pgsql-admin by date:

Previous
From: rahimeh khodadadi
Date:
Subject: Ldap in postgre in windows 2003 server.
Next
From: Dimitri Fontaine
Date:
Subject: Re: partition insert performance