Re: [GENERAL] merge 2 dumps
On Tuesday 11 November 2008, Joao Ferreira gmail <[EMAIL PROTECTED]> wrote: > could I just get the "COPY TO" sections from the files and load them one > after the other ? > > I never tried this before... You might have drop foreign keys before doing so and recreate them after - the dumps aren't careful to maintain ordering. -- Alan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] merge 2 dumps
Joao Ferreira gmail wrote: > On Tue, 2008-11-11 at 11:16 +, 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
Re: [GENERAL] merge 2 dumps
On Tue, 2008-11-11 at 11:16 +, 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. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] merge 2 dumps
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] merge 2 dumps
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 this possible ? are there any helper tools to aid in dealing with text dump files ? thanks Joao -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general