Re: merge 2 dumps

Joao Ferreira gmail wrote:
> 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 ?

Great - if it's something like log data for different years that makes
it much simpler. Just do a --data-only restore with the second dump,
that should work just fine.

--
  Richard Huxton
  Archonet Ltd