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
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
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
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
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