pgReplicationTutorial.md

run docker

docker run -it jberkus/pgreplicationtutorial

tmux

[ctrl]+b c
su - postgres
[ctrl]+b n
[ctrl]+b n
(you should be in "postgres" shell)
pg_ctl -D 9.4/master start

create replica of master

cd 9.4
ls
(all the directory are separate data directory for postgres)
pg_basebackup -x -P -D replica1 -p 5432 -h localhost
cp /setup/postgres/replica1/* replica1/
chown postgres:postgres replica1
pg_ctl -D replica1 start
ps aux | grep postgres
psql -p 5432 libdata
\dt
\q
psql -p 5433 libdata
\dt
\q

create traffic on master

createdb -p 5432 bench
pgbench -i -s 10 -U bench bench
psql -p 5432 bench
\dt
\q
psql -p 5433 bench
\dt
\q