Re: How to increace nightly backup speed - Mailing list pgsql-general

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 ?
>

You might try using online backups. By following the steps in this
document:

http://www.postgresql.org/docs/8.1/static/backup-online.html

you can back up the data at the speed of your filesystem. There's no way
to make it faster than that.

Hope this helps,
     Jeff Davis