X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C73C1474E4F; Thu, 13 Feb 2003 09:14:00 -0500 (EST) Received: from ada (pD9588DD4.dip.t-dialin.net [217.88.141.212]) by postgresql.org (Postfix) with ESMTP id 10CA5474E42; Thu, 13 Feb 2003 09:14:00 -0500 (EST) Received: from rehmann by ada with local (Exim 3.35 #1 (Debian)) id 18jK7l-0002jC-00; Thu, 13 Feb 2003 15:14:01 +0100 To: xzilla@users.sourceforge.net Cc: pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org In-reply-to: <1045144176.12930.438.camel@camel> (message from Robert Treat on 13 Feb 2003 08:49:36 -0500) Subject: Re: postgresql 7.3 versus 7.2 References: <1045144176.12930.438.camel@camel> Message-Id: From: Ulf Rehmann Date: Thu, 13 Feb 2003 15:14:01 +0100 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/50 X-Sequence-Number: 3671 | Create a schema only dump with the 7.2 pg_dump. | Create a data only dump (possibly with INSERT output) with the 7.3 | pg_dump. Assuming you haven't done anything too wacky, you should be | able to drop your 7.2 database, reload the 7.2 schema, then load up the | 7.3 data. As always, test this out before doing it on a production | system. | Thanks a lot for this quick explanation, this is very helpful! By the way, is there a possibility to just do incremental dumps/restores? Say, since a given date? Ulf