Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 34D739FB47D for ; Sun, 25 Feb 2007 19:15:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 31463-02 for ; Sun, 25 Feb 2007 19:15:40 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 7D6A49FB400 for ; Sun, 25 Feb 2007 19:15:40 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l1PNFdhA040053 for ; Sun, 25 Feb 2007 19:15:39 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l1PMwK06037456 for pgsql-admin@postgresql.org; Sun, 25 Feb 2007 18:58:20 -0400 (AST) (envelope-from news) From: "Ben Trewern" X-Newsgroups: pgsql.admin Subject: Re: Fastest DB restore options Date: Sun, 25 Feb 2007 22:58:15 -0000 Organization: Hub.Org Networking Services Lines: 43 Message-ID: References: <821429.69798.qm@web50304.mail.yahoo.com> Reply-To: "Ben Trewern" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/318 X-Sequence-Number: 24783 If you are just looking for the least down time between stopping one server and starting the new one you could try Slony see http://gborg.postgresql.org/project/slony1/projdisplay.php Regards, Ben wrote in message news:821429.69798.qm@web50304.mail.yahoo.com... > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >