From: | "Oeschey, Lars (I/EK-142, extern)" <extern(dot)Lars(dot)Oeschey(at)AUDI(dot)DE> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | sync two databases |
Date: | 2008-02-07 08:12:30 |
Message-ID: | 17A09E9509BB354E95C2FEE5102B0F5F0242090B@audiinsx0036.audi.vwg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I have two databases (8.1.11) where the content of some tables should be
synced nightly. I tried to dump the contents with a script (similar to a
pg_backup script), and then load them again, but there is a DROP
statement in the dump, that doesn't work on restore since there are
dependencies between tables (restore says I should use DROP CASCADED,
which I don't dare...). Is there a way to only dump the data? I can't
seem to find the respective parameters in pg_dump documentation.
Another thing: I have seen that database grow to 48Mio rows in one table
(I didn't do the design ;)), so I'm afraid a standard dump using "COPY"
could give me problems later on... though a "INSERT" is said to be slow?
Any ideas on this?
From | Date | Subject | |
---|---|---|---|
Next Message | Smita Vijayakumar | 2008-02-07 09:44:27 | Problem integrating C stub |
Previous Message | Marc Abbott | 2008-02-06 07:33:46 | PG Newbie |