Hi, On 2 September 2011 03:09, Jerry LeVan <jerry.levan@xxxxxxxxx> wrote: > I keep registration numbers for software and login/passwords for > various organizations, etc… > > As time goes by the tables on the various computers get out of > sync. > > Is there an elegant way I can get all of the differences (uniquely) I would copy data from the other machines to the "master" one: on the "master", under postgres user (data only dump; -a options): pg_dump -a -h <host1> -t registrations -U <user> <database> -F c | pg_restore -d <database> pg_dump -a -h <host2> -t registrations -U <user> <database> -F c | pg_restore -d <database> ... pg_dump -a -h <hostN> -t registrations -U <user> <database> -F c | pg_restore -d <database> and then do the following: begin; insert into tmp select distinct * from registrations; truncate registrations; insert into registrations select * from tmp; commit; -- Ondrej Ivanic (ondrej.ivanic@xxxxxxxxx) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
