Re: merge 2 dumps

On Tue, 2008-11-11 at 11:16 +0000, Richard Huxton wrote:
> 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?

no. I don't expect that there might be overlaps. any simpler solution in
this case ?

could I just get the "COPY TO" sections from the files and load them one
after the other ?

I never tried this before...

j


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