Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrus
Subject How to increace nightly backup speed
Date
Msg-id ekf6da$kq3$1@news.hub.org
Whole thread Raw
Responses Re: How to increace nightly backup speed  (Alexander Staubo <alex@purefiction.net>)
Re: How to increace nightly backup speed  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Tree view 
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 ?

Andrus.

pgsql-general by date:

Previous
From: Bret Schuhmacher
Date:
Subject: Returning multiple rows from a function?
Next
From: brian
Date:
Subject: Re: Returning multiple rows from a function?