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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
