Postgresql 主从
主库配置 修改 postgresql.conf 1 2 3 4 5 listen_address = '*' wal_level = replica wax_wal_senders = 10 wal_keep_segments = 64 hot_standby = on 启动主库 postgresql-10 服务 1 systemctl start postgresql-10 创建同步账户 1 2 create user replica superuser password '123456'; -- 这里可以只赋予 replication 权限,后面从库复制