Re: [GENERAL] Fast backup/restore

2006-10-18 Thread Jim C. Nasby
On Tue, Oct 17, 2006 at 02:43:28PM -0400, Vivek Khera wrote: > > On Oct 17, 2006, at 2:35 PM, Steve Poe wrote: > > >Vivek, > > > >What methods of backup do you recommend for medium to large > >databases? In our example, we have a 20GB database and it takes 2 > >hrs to load from a pg_dump file

Re: [GENERAL] Fast backup/restore

2006-10-17 Thread Vivek Khera
On Oct 17, 2006, at 2:35 PM, Steve Poe wrote: Vivek, What methods of backup do you recommend for medium to large databases? In our example, we have a 20GB database and it takes 2 hrs to load from a pg_dump file. my largest db is about 60Gb with indexes. reloading the data (about 30G

Re: [GENERAL] Fast backup/restore

2006-10-17 Thread Steve Poe
Vivek,What methods of backup do you recommend for medium to large databases? In our example, we have a 20GB database and it takes 2 hrs to load from a pg_dump file.Thanks.Steve Poe On 10/17/06, Vivek Khera <[EMAIL PROTECTED]> wrote: On Oct 17, 2006, at 10:43 AM, [EMAIL PROTECTED] wrote: We just ta

Re: [GENERAL] Fast backup/restore

2006-10-17 Thread Vivek Khera
On Oct 17, 2006, at 10:43 AM, [EMAIL PROTECTED] wrote:We just tar/gzip the entire data directory.  It takes all of 20 sec.  We've successfully restored from that also.  The machine you are restoring to *must* be running the save version of postgresql you backed up from. If you successfully backed u

Re: [GENERAL] Fast backup/restore

2006-10-17 Thread Tom Lane
[EMAIL PROTECTED] writes: > We just tar/gzip the entire data directory. It takes all of 20 sec. We've > successfully restored from that also. You've been very lucky ... unless you stopped the postmaster while taking the backup. Without that, this method WILL screw you someday. (But as long as

Re: [GENERAL] Fast backup/restore

2006-10-17 Thread mengel
L PROTECTED] 10/16/2006 02:35 PM To Gandalf <[EMAIL PROTECTED]> cc pgsql-general@postgresql.org Subject Re: [GENERAL] Fast backup/restore On Mon, 2006-10-16 at 16:29 +0530, Gandalf wrote: > I am looking for a *fast* backup/restore tools for Postgres. I've > found th

Re: [GENERAL] Fast backup/restore

2006-10-16 Thread Jeff Davis
On Mon, 2006-10-16 at 16:29 +0530, Gandalf wrote: > I am looking for a *fast* backup/restore tools for Postgres. I've > found the current used tools pg_dump and pg_restore to be very slow on > large databases (~30-40GB). Restore takes time in the tune of 6 hrs on > a Linux, 4 proc, 32 G RAM machine

Re: [GENERAL] Fast backup/restore

2006-10-16 Thread Harald Armin Massa
Gandald,have a look athttp://momjian.us/main/writings/pgsql/administration.pdfpage 44ffThere are descriptions how to do database-backups at the speed of raw file system operations. Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-P