On Jun 29, 1:10 pm, phoenix.ki...@gmail.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...@postgresql.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