Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to increace nightly backup speed
- From: Alexander Staubo <alex(at)purefiction(dot)net>
- To: "Andrus" <eetasoft(at)online(dot)ee>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: How to increace nightly backup speed
- Date: Mon, 27 Nov 2006 18:23:04 +0100
- Message-id: <7A366B0C-213D-4D8A-846F-44E047B955E5(at)purefiction(dot)net>
On Nov 27, 2006, at 18:13 , Andrus wrote:
I need to create nightly backups to separate computer over internet from 8.1server 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 -h81.50.12.18 -U myuser -p 5431 mydb
Reducing compression (change -Z9 to something like -Z0) might help a little, depending on the processing power of the server and available bandwidth. If you really want compression, you could do the dump over a SSH connection and gzip on the client end:
$ ssh 81.50.12.18 "pg_dump -Z0 -Fc -ibv -U myuser mydb" | gzip -9 >mybackup.backup
Alexander.
- Follow-Ups:
- Re: How to increace nightly backup speed
- From: Andrus
- Re: How to increace nightly backup speed
- References:
- How to increace nightly backup speed
- From: Andrus
- How to increace nightly backup speed
- Prev by Date: Re: Returning multiple rows from a function?
- Next by Date: Re: IS it a good practice to use SERIAL as Primary Key?
- Previous by thread: How to increace nightly backup speed
- Next by thread: Re: How to increace nightly backup speed
- Indexes: