Skip to content

watiko/bucardo-exp

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

try

terminal A:

$ docker-compose up -d postgres{9,11}
$ docker-compose run --rm clean
$ docker-compose run --rm init
$ docker-compose run --rm bucardo
docker#

terminal B:

$ docker-compose run --rm psql
docker# psql service=a < /sql/delta.sql
docker# psql service=a -c 'SELECT (SELECT count(*) FROM users) AS users, (SELECT count(*) FROM todos) AS todos'
 users | todos 
-------+-------
     4 |    15
(1 row)

docker# psql service=b -c 'SELECT (SELECT count(*) FROM users) AS users, (SELECT count(*) FROM todos) AS todos'
 users | todos 
-------+-------
     3 |    10
(1 row)

terminal A:

docker# bucardo start

terminal B:

docker# psql service=a -c 'SELECT (SELECT count(*) FROM users) AS users, (SELECT count(*) FROM todos) AS todos'
 users | todos 
-------+-------
     4 |    15
(1 row)

docker# psql service=b -c 'SELECT (SELECT count(*) FROM users) AS users, (SELECT count(*) FROM todos) AS todos'
 users | todos 
-------+-------
     4 |    15
(1 row)

terminal A:

docker# tail -f /var/log/bucardo/log.bucardo

check whether replication completed

docker# bucardo stop
docker# pg_dump service=a --schema=public --section=post-data | psql -q service=b
docker# bucardo remove sync migrate_db
docker# bucardo remove db A B --force

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published