Skip site navigation (1) Skip section navigation (2)

Fastest DB restore options

From: ogjunk-pgjedan(at)yahoo(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Fastest DB restore options
Date: 2007-02-22 15:43:13
Message-ID: 821429.69798.qm@web50304.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello,

I have a fairly large DB to dump and restore as fast as possible.  I'm moving from 8.0.3 to 8.2.3! :)

I normally dump with these options:

  -d MyDB --clean --inserts --column-inserts --format=P

But the last time I tried that, the restore took foreeeeeeeeeeeeeever.  So I'm looking for the fastest way to import data from the old DB to the new one.  Judging from pg_dump man page the following should be the fastest dump & restore:

  -d MyDB --format=c --ignore-version
 
Is there anything else I can do to make the restore as fast as possible?

Thanks,
Otis

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Simpy -- http://www.simpy.com/  -  Tag  -  Search  -  Share



Responses

pgsql-admin by date

Next:From: Naomi WalkerDate: 2007-02-22 15:58:31
Subject: Re: Fastest DB restore options
Previous:From: Ian ChartersDate: 2007-02-22 14:28:37
Subject: Silent Install of 8.2 on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group