| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: merge 2 dumps |
| Date: | 2008-11-11 12:46:20 |
| Message-ID: | 49197E9C.7030705@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-11-11 13:10:49 | Re: SQL injection, php and queueing multiple statement |
| Previous Message | Richard Huxton | 2008-11-11 12:45:19 | Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) |