Re: Copying only incremental records to another DB..

On Jun 29, 1:10 pm, phoenix(dot)ki(dot)(dot)(dot)(at)gmail(dot)com (Phoenix Kiula) wrote:
> Hi
>
> We're trying PG on a new machine, so we copied our current (live)
> database to that server. Tested the code and it's all working. Now, to
> make that second server the main live server, we will need to copy the
> db again including the new records since we copied for testing. Is
> there any way to copy only the incremental records in all the tables?
>
> Thanks
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Hi Phoenix,

you could try using the tool "rubyrep". With rubyrep you can compare
one or multiple tables between databases and synchronize all changes.
http://www.rubyrep.org

Best Regards,
Arndt