On Jun 29, 1:10 pm, phoenix.ki...@xxxxxxxxx (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...@xxxxxxxxxxxxxx) > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
