PostgreSQL 流复制

master端:

创建流复制用户

postgres=# CREATE USER repuser replication LOGIN CONNECTION LIMIT 3 ENCRYPTED PASSWORD 'ze0321';
CREATE ROLE

slave端:

/usr/local/pgsql/bin/pg_basebackup -h p0-tkjt-ylcloud-db01-primary -p 5432 -U repuser -w -Fp -Xs -Pv -R -D /data/pgsql_5432/pgdata/

原文地址:https://www.cnblogs.com/elontian/p/13438791.html