Re: merge 2 dumps - Mailing list pgsql-general

From Richard Huxton
Subject Re: merge 2 dumps
Date
Msg-id 49196986.3000203@archonet.com
Whole thread Raw
In response to merge 2 dumps  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
Responses Re: merge 2 dumps
List pgsql-general
Joao Ferreira gmail wrote:
> hello all,
>
> I have 2 dumps of the same Pg database in diferent instants.
>
> I'dd like to merge the two dumps into one single dump in order to
> restore all data at one time.

Is there any overlap in the data?

If so, simplest might be to restore dump1, rename all the tables,
restore dump2 then run queries to rationalise your two sets of tables.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Question about weird construct
Next
From: Joao Ferreira gmail
Date:
Subject: Re: merge 2 dumps