Re: [GENERAL] merge 2 dumps

2008-11-12 Thread Alan Hodgson
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

Re: [GENERAL] merge 2 dumps

2008-11-11 Thread Richard Huxton
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 o

Re: [GENERAL] merge 2 dumps

2008-11-11 Thread Joao Ferreira gmail
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 o

Re: [GENERAL] merge 2 dumps

2008-11-11 Thread Richard Huxton
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

[GENERAL] merge 2 dumps

2008-11-11 Thread Joao Ferreira gmail
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-gener