Docker + PostgreSQL 主从环境搭建

    docker run --name pgsmaster -p 5500:5432 -e POSTGRES_PASSWORD=pgsmaster -v $(pwd)/pgsmaster:/var/lib/postgresql/data -d postgres

    docker run --name pgsslave -p 5501:5432 -e POSTGRES_PASSWORD=pgsslave -v $(pwd)/pgsslave:/var/lib/postgresql/data -d postgres

    // replication_username: 复制账号; slave_ip: 从库所在的服务器ip
    host    replication     <replication_username>      <slave_ip>/32          md5

    synchronous_standby_names = '*'

# 1.进入容器
        docker exec -it pgsmaster bash
# 2.连接PostgreSQL
        psql -U postgres
# 3.创建用户
        set synchronous_commit =off;
        // replication_username: 对应上面设置的复制账号; replication_username_password: 认证密码
        create role <replication_username> login replication encrypted password '<replication_username_password>';  
# 4.验证用户
        \du

    hot_standby_feedback = on

    standby_mode = 'on'
    // replication_username: 复制账号(同主库); master_ip: 主库所在的服务器ip; master_port: 主库端口; replication_username_password: 认证密码
    primary_conninfo = 'host=<master_ip> port=<master_port> user=<replication_username> password=<replication_username_password>'

    docker stop pgsmaster 
    docker stop pgsslave

    // 1.1 已ssh认证，请将$(pwd)更改为实际的路径
    rsync -cva --inplace --exclude=*pg_xlog* $(pwd)/pgsmaster/ <slave_ip>:$(pwd)/pgsslave/
    // 1.2 无ssh认证，请将$(pwd)更改为实际的路径
    rsync -cva --inplace --exclude=*pg_xlog* $(pwd)/pgsmaster/ ssh root@<slave_ip>:$(pwd)/pgsslave/

    docker start pgsmaster 
    docker start pgsslave

    // 进入主库容器
    docker exec -it pgsmaster bash
    // 查看复制状态
    psql -U postgres -x -c "select * from pg_stat_replication;"