Re: Incremental Dump

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Cc: Herbie McDuck <herbie(at)faams(dot)net>
Subject: Re: Incremental Dump
Date: 2003-06-26 14:05:29
Message-ID: 1056636328.1270.2.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Am Don, 2003-06-26 um 15.52 schrieb Tom Lane:

> I'd try pg_dump -s (schema only) and diff the two dumps. You might have
> to do some fooling around if objects were created in different orders in
> the two databases, though, since that would affect the dump order.

I'd also remove all comments:

pg_dump -s dbname |egrep -v "^\-\-"

HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Joe Conway 2003-06-26 16:26:05 Re: [NOVICE] connectby(... pos_of_sibling)
Previous Message Tom Lane 2003-06-26 13:52:44 Re: Incremental Dump