########################################################################## synctest before recovery Node1:~ # ./synctest.sh #! /bin/sh -xv psql -hPGPool -dpostgres -Upostgres -c 'CREATE DATABASE test;' + psql -hPGPool -dpostgres -Upostgres -c 'CREATE DATABASE test;' CREATE DATABASE psql -hNode1 -dpostgres -Upostgres -c "select oid,* from pg_database where datname = 'test';" + psql -hNode1 -dpostgres -Upostgres -c 'select oid,* from pg_database where datname = '\''test'\'';' oid | datname ----------+--------- 27427406 | test (1 row) psql -hNode2 -dpostgres -Upostgres -c "select oid,datname from pg_database where datname = 'test';" + psql -hNode2 -dpostgres -Upostgres -c 'select oid,datname from pg_database where datname = '\''test'\'';' oid | datname ----------+--------- 27427406 | test psql -hNode3 -dpostgres -Upostgres -c "select oid,* from pg_database where datname = 'test';" + psql -hNode3 -dpostgres -Upostgres -c 'select oid,* from pg_database where datname = '\''test'\'';' oid | datname ----------+--------- 27435591 | test (1 row) psql -hPGPool -dpostgres -Upostgres -c 'Drop DATABASE test;' + psql -hPGPool -dpostgres -Upostgres -c 'Drop DATABASE test;' DROP DATABASE ########################################################################## synctest after recovery Node1:~ # ./synctest.sh #! /bin/sh -xv psql -hPGPool -dpostgres -Upostgres -c 'CREATE DATABASE test;' + psql -hPGPool -dpostgres -Upostgres -c 'CREATE DATABASE test;' CREATE DATABASE psql -hNode1 -dpostgres -Upostgres -c "select oid,datname from pg_database where datname = 'test';" + psql -hNode1 -dpostgres -Upostgres -c 'select oid,datname from pg_database where datname = '\''test'\'';' oid | datname ----------+--------- 27427407 | test (1 row) psql -hNode2 -dpostgres -Upostgres -c "select oid,datname from pg_database where datname = 'test';" + psql -hNode2 -dpostgres -Upostgres -c 'select oid,datname from pg_database where datname = '\''test'\'';' oid | datname ----------+--------- 27427407 | test (1 row) psql -hNode3 -dpostgres -Upostgres -c "select oid,datname from pg_database where datname = 'test';" + psql -hNode3 -dpostgres -Upostgres -c 'select oid,datname from pg_database where datname = '\''test'\'';' oid | datname ----------+--------- 27435587 | test (1 row) psql -hPGPool -dpostgres -Upostgres -c 'Drop DATABASE test;' + psql -hPGPool -dpostgres -Upostgres -c 'Drop DATABASE test;' DROP DATABASE