Jeff Davis wrote:
On Mon, 2006-11-27 at 19:13 +0200, Andrus wrote:
I need to create nightly backups to separate computer over internet from 8.1
server
I tried to run pg_dump to make backup using command
"..\pg_dump\pg_dump.exe" -i -Z9 -b -v -f "C:\061127 mybackup.backup" -F c -h
81.50.12.18 -U myuser -p 5431 mydb
but this takes 4.5 hours to complete.
How to increace backup speed ?
I agree to use online backups. But, I bet the majority of your backup
time is spent compressing your data (-Z9).
The solution I'm currently using (both with online backups and pg_dump)
is to copy all the data to an alternate volume uncompressed, then
compress it (nice gzip -1). This allows the backup itself to happen as
quickly as possible, and then the compression can run for awhile without
having a large IO impact on the main data volumes. I worry about how
long the initial copy/dump takes, but not so much after that.
-Glen
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
