Re: [Gnumed-devel] database replication with bucardo

[Slappinjohn]

> can you describe the other solution. I would like to put something in
the blog and in the wiki

as Karsten suggested in the first place, I did the diff-patch-workaround:

As far as I won't need access on both places this will work quite well.

on the first PC I run this script as root:

#!/bin/bash

cd /home/marc/gnumed/backups

pg_dump -C -v -U gm-dbo -f new.sql gnumed_v17 2>/dev/null

diff old.sql new.sql > diff.sql

su marc -c "scp -P 10022 diff.sql
destinationserver:/home/marc/gnumed/backups/"

mv new.sql old.sql


on the remote side (or via ssh in the same script, however you like it):

#!/bin/bash

cd /home/marc/gnumed/backups

patch old.sql diff.sql

cp old.sql /tmp/

su postgres -c "psql -c 'drop database gnumed_v17;'"

su postgres -c "psql < /tmp/old.sql"

gm-adjust_db_settings gnumed_v17

/etc/init.d/postgresql reload


Will have a look at Postgres-XC as Dave suggested

Marc