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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general