Created
October 21, 2014 03:02
-
-
Save masbog/7991cab4fa9ffc6c2494 to your computer and use it in GitHub Desktop.
bucardo how to initialize 2 postgresql database server
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # slave ip server is 10.10.10.10 | |
| bucardo install --piddir=/tmp | |
| bucardo add database db_master dbname=database_test | |
| bucardo del database db_master | |
| bucardo add database db_master dbname=database_test addalltables addallsequences | |
| bucardo add database db_slave dbname=database_test host=10.10.10.10 addalltables addallsequences | |
| bucardo add all table --herd=db_master_to_db_slave db=db_master | |
| bucardo add all sequence --herd=db_master_to_db_slave db=db_master | |
| bucardo add all table --herd=db_slave_to_db_master db=db_slave | |
| bucardo add all sequence --herd=db_slave_to_db_master db=db_slave | |
| bucardo add sync sync_db_master_to_db_slave relgroup=db_master_sync_db_slave dbs=db_master,db_slave | |
| bucardo add sync sync_db_slave_to_db_master relgroup=db_slave_sync_db_master dbs=db_slave,db_master |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment