sync two databases
От | Oeschey, Lars (I/EK-142, extern) |
---|---|
Тема | sync two databases |
Дата | |
Msg-id | 17A09E9509BB354E95C2FEE5102B0F5F0242090B@audiinsx0036.audi.vwg обсуждение исходный текст |
Ответы |
Re: sync two databases
|
Список | 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?
В списке pgsql-novice по дате отправления: