{"id":41556,"date":"2023-05-22T22:38:40","date_gmt":"2024-01-22T16:04:19","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/"},"modified":"2024-04-30T05:29:05","modified_gmt":"2024-04-29T21:29:05","slug":"%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/","title":{"rendered":"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd"},"content":{"rendered":"

\u9996\u5148<\/h1>\n

\u7531\u4e8e\u4e0a\u6b21\u5df2\u7ecf\u5728CentOS\u4e0a\u5b89\u88c5\u4e86PostgreSQL-14\uff0c\u6240\u4ee5\u8fd9\u6b21\u6211\u4eec\u5c06\u5c1d\u8bd5\u4f7f\u7528\u590d\u5236\u529f\u80fd\u3002<\/p>\n

\u53ef\u4ee5\u70b9\u51fb\u8fd9\u91cc\u67e5\u770b\u4e4b\u524d\u7684\u6587\u7ae0\u3002<\/p>\n

\u64cd\u4f5c\u7cfb\u7edf\u662fCentOS\uff0c\u7248\u672c\u5982\u4e0b\u3002<\/p>\n

[root@db-server-01 ~]# cat \/etc\/redhat-release\r\nCentOS Linux release 7.9.2009 (Core)\r\n<\/code><\/pre>\n
\u8fd9\u6b21\u6211\u4eec\u8981\u7528\u4e24\u53f0DB\u670d\u52a1\u5668\u8fdb\u884c\u540c\u6b65\uff0c\u6240\u4ee5\u8bf7\u51c6\u5907\u4e24\u53f0\u72b6\u6001\u76f8\u540c\u7684DB\u670d\u52a1\u5668\u3002
\n\u7b14\u8005\u5df2\u7ecf\u51c6\u5907\u4e86\u4e24\u53f0\u4e0e\u4e0a\u4e00\u7bc7\u6587\u7ae0\u4e2d\u670d\u52a1\u5668\u72b6\u6001\u76f8\u540c\u7684\u670d\u52a1\u5668\u3002<\/p>\n
\u5c1d\u8bd5\u4f7f\u7528\u590d\u5236\u529f\u80fd<\/h1>\n
DB\u670d\u52a1\u5668#01<\/h2>\n
\u9996\u5148\uff0c\u5728DB\u670d\u52a1\u5668#01\u4e0a\u8fdb\u884c\u5de5\u4f5c\u3002<\/p>\n
\u4fee\u6539postgresql.conf\u6587\u4ef6<\/h3>\n
\u9996\u5148\uff0c\u4ece\u4fee\u6539postgresql.conf\u6587\u4ef6\u5f00\u59cb\u3002
\n\u5728\u6b64\u4e4b\u524d\uff0c\u5148\u505a\u597d\u5907\u4efd\u4ee5\u9632\u4e07\u4e00\u3002
\n\u6ce8\u610f\uff0cpostgresql.conf\u6587\u4ef6\u9ed8\u8ba4\u4f4d\u4e8e\/var\/lib\/pgsql\/data\/\u4e4b\u7c7b\u7684\u4f4d\u7f6e\u3002
\n\u203b \u6211\u6545\u610f\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3a\/database\/\u7684\u6570\u636e\u5e93\u96c6\u7fa4\u3002<\/p>\n
[root@db-server-01 ~]# cp -p \/database\/data\/postgresql.conf \/database\/data\/postgresql.conf_bk\r\n[root@db-server-01 ~]# ls -al \/database\/data\/postgresql.conf*\r\n-rw------- 1 postgres postgres 28782 Jul 21 03:17 \/database\/data\/postgresql.conf\r\n-rw------- 1 postgres postgres 28782 Jul 21 03:17 \/database\/data\/postgresql.conf_bk\r\n<\/code><\/pre>\n
\u53bb\u4fee\u6539postgresql.conf\u6587\u4ef6\u3002<\/p>\n
[root@db-server-01 ~]# vi \/database\/data\/postgresql.conf]\r\n\r\n#60\u884c\u76ee\r\nlisten_addresses = '*'\r\n\r\n#205\u884c\u76ee\r\nwal_level = replica\r\n\r\n#210\u884c\u76ee\r\nsynchronous_commit = on\r\n\r\n# 298\u884c\u76ee\r\nmax_wal_senders = 10\r\n\r\n#312\u884c\u76ee\r\nsynchronous_standby_names = '*'\r\n<\/code><\/pre>\n
\u6682\u4e14\u8bb0\u5f55\u5728\u8868\u4e0a\u3002<\/p>\n
\n
\u884c\u6570\u4fee\u6b63\u524d\u4fee\u6b63\u5f8c\u53c2\u800360#listen_addresses = ‘localhost’listen_addresses = ‘*’https:\/\/postgresqlco.nf\/doc\/ja\/param\/listen_addresses\/<\/a>205#wal_level = replicawal_level = replicahttps:\/\/postgresqlco.nf\/doc\/ja\/param\/wal_level\/<\/a>210#synchronous_commit = onsynchronous_commit = onhttps:\/\/postgresqlco.nf\/doc\/ja\/param\/synchronous_commit\/<\/a>298#max_wal_senders = 10max_wal_senders = 10https:\/\/postgresqlco.nf\/doc\/ja\/param\/max_wal_senders\/<\/a>312#synchronous_standby_names = ”synchronous_standby_names = ‘*’https:\/\/postgresqlco.nf\/doc\/ja\/param\/synchronous_standby_names\/<\/a><\/div>\n<\/div>\n
\u4f7f\u7528diff\u547d\u4ee4\u8fdb\u884c\u5dee\u5f02\u786e\u8ba4\u65f6\uff0c\u7ed3\u679c\u4f1a\u50cf\u8fd9\u6837\u5b50\u3002<\/p>\n
[root@db-server-01 ~]# diff \/database\/data\/postgresql.conf_bk \/database\/data\/postgresql.conf\r\n60c60\r\n< #listen_addresses = 'localhost'               # what IP address(es) to listen on;\r\n---\r\n> listen_addresses = '*'               # what IP address(es) to listen on;\r\n205c205\r\n< #wal_level = replica                  # minimal, replica, or logical\r\n---\r\n> wal_level = replica                   # minimal, replica, or logical\r\n210c210\r\n< #synchronous_commit = on              # synchronization level;\r\n---\r\n> synchronous_commit = on               # synchronization level;\r\n298c298\r\n< #max_wal_senders = 10         # max number of walsender processes\r\n---\r\n> max_wal_senders = 10          # max number of walsender processes\r\n312c312\r\n< #synchronous_standby_names = ''       # standby servers that provide sync rep\r\n---\r\n> synchronous_standby_names = '*'       # standby servers that provide sync rep\r\n<\/code><\/pre>\n
\u4fee\u6539 pg_hba.conf<\/h3>\n
\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u4fee\u6539pg_hba.conf\u6587\u4ef6\u3002
\n\u4e3a\u4e86\u5b89\u5168\u8d77\u89c1\uff0c\u5148\u521b\u5efa\u4e00\u4e2a\u5907\u4efd\u3002<\/p>\n
[root@db-server-01 ~]# cp -p \/database\/data\/pg_hba.conf \/database\/data\/pg_hba.conf_bk\r\n[root@db-server-01 ~]# ls -al \/database\/data\/pg_hba.conf*\r\n-rw------- 1 postgres postgres 4789 Jul 21 03:17 \/database\/data\/pg_hba.conf\r\n-rw------- 1 postgres postgres 4789 Jul 21 03:17 \/database\/data\/pg_hba.conf_bk\r\n<\/code><\/pre>\n
\u90a3\u4e48\uff0c\u6211\u4f1a\u8fdb\u884c\u4fee\u6b63\u3002<\/p>\n
[root@db-server-01 ~]# vi \/database\/data\/pg_hba.conf\r\n\r\n#\u6700\u7d42\u884c\u306b\u4e0b\u8a18\u3092\u8ffd\u52a0\uff08\u63a5\u7d9a\u8a31\u53ef\u306e\u8a2d\u5b9a\r\nhost    replication     repl_user       192.168.255.129\/32      md5\r\nhost    replication     repl_user       192.168.255.130\/32      md5\r\n<\/code><\/pre>\n
192.168.255.129\u662fDB\u670d\u52a1\u5668#01\u7684IP\u5730\u5740\u3002
\n192.168.255.130\u662fDB\u670d\u52a1\u5668#02\u7684IP\u5730\u5740\u3002
\n\u8bf7\u63d0\u4f9b\u6bcf\u53f0\u670d\u52a1\u5668\u7684IP\u5730\u5740\u3002<\/p>\n
repl_user\u662f\u5141\u8bb8\u8fde\u63a5\u7684\u7528\u6237\u3002
\n\u7a0d\u540e\u5c06\u521b\u5efa\u3002<\/p>\n
\u4f7f\u7528diff\u547d\u4ee4\u8fdb\u884c\u5dee\u5f02\u786e\u8ba4<\/p>\n
[root@db-server-01 ~]# diff \/database\/data\/pg_hba.conf_bk \/database\/data\/pg_hba.conf\r\n98a99,100\r\n> host    replication     repl_user       192.168.255.129\/32      md5\r\n> host    replication     repl_user       192.168.255.130\/32      md5\r\n<\/code><\/pre>\n
\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u7528\u4e8e\u590d\u5236\u7684\u7528\u6237\uff08\u89d2\u8272\uff09\u3002
\n\u5207\u6362\u5230postgres\u7528\u6237\u5e76\u6267\u884ccreateuser\u547d\u4ee4\u3002<\/p>\n
[root@db-server-01 ~]# su - postgres\r\n[postgres@db-server-01 ~]$ createuser --replication -P repl_user\r\nEnter password for new role:        ## \u30d1\u30b9\u30ef\u30fc\u30c9\u4e00\u56de\u76ee\r\nEnter it again:                     ## \u30d1\u30b9\u30ef\u30fc\u30c9\u4e8c\u56de\u76ee\r\n<\/code><\/pre>\n
\u5728\u8fd9\u91cc\u53d1\u751f\u9519\u8bef\u7684\u4eba\u53ef\u4ee5\u53c2\u8003\u8fde\u63a5\u5931\u8d25\u3002<\/p>\n
\u5982\u679c\u770b\u8d77\u6765\u6ca1\u6709\u95ee\u9898\uff0c\u5c31\u91cd\u65b0\u542f\u52a8 postgresql-14\u3002<\/p>\n
[postgres@db-server-01 ~]$ exit\r\n\r\n[root@db-server-01 ~]# systemctl restart postgresql-14\r\n<\/code><\/pre>\n
DB\u670d\u52a1\u5668\uff0301\u7684\u5de5\u4f5c\u5df2\u7ecf\u5b8c\u6210\u3002<\/p>\n
\u6570\u636e\u5e93\u670d\u52a1\u5668#02<\/h2>\n
\u9996\u5148\u505c\u6b62 PostgreSQL-14\uff0c\u5e76\u5220\u9664\u6240\u6709\u6587\u4ef6\u3002<\/p>\n
[root@db-server-02 ~]# systemctl stop postgresql-14\r\n[root@db-server-02 ~]# rm -rf \/database\/data\/*\r\n<\/code><\/pre>\n
\u5207\u6362\u8d26\u6237\u5e76\u6267\u884cpg_basebackup\u547d\u4ee4\uff01<\/p>\n
[root@db-server-02 ~]# su - postgres\r\n[postgres@db-server-02 ~]$pg_basebackup -R -h 192.168.255.129 -U repl_user -D \/database\/data -P\r\nPassword:\r\n26941\/26941 kB (100%), 1\/1 tablespace\r\n<\/code><\/pre>\n
\u5728\u8fd9\u91cc\u9047\u5230\u9519\u8bef\u7684\u4eba\u53ef\u4ee5\u53c2\u8003\u201cNo route to host\u201d\u9519\u8bef\u3002<\/p>\n
\u53c2\u8003pg_basebackup\u547d\u4ee4\u7684\u9009\u9879\u8bf7\u70b9\u51fb\u6b64\u5904\u3002<\/p>\n
\u6211\u5011\u4f86\u6aa2\u67e5\u4e00\u4e0b\/database\/data\/\u7684\u5167\u5bb9\u5427\u3002<\/p>\n
[postgres@db-server-02 ~]$ls -al \/database\/data\/\r\ntotal 204\r\ndrwx------. 20 postgres postgres   4096 Jul 21 04:41 .\r\ndrwxr-xr-x   4 postgres postgres     32 Jul 18 05:10 ..\r\n-rw-------   1 postgres postgres    225 Jul 21 04:41 backup_label\r\n-rw-------   1 postgres postgres 137646 Jul 21 04:41 backup_manifest\r\ndrwx------   5 postgres postgres     41 Jul 21 04:41 base\r\n-rw-------   1 postgres postgres     30 Jul 21 04:41 current_logfiles\r\ndrwx------   2 postgres postgres   4096 Jul 21 04:41 global\r\ndrwx------   2 postgres postgres     32 Jul 21 04:41 log\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_commit_ts\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_dynshmem\r\n-rw-------   1 postgres postgres   4925 Jul 21 04:41 pg_hba.conf\r\n-rw-------   1 postgres postgres   1636 Jul 21 04:41 pg_ident.conf\r\ndrwx------   4 postgres postgres     68 Jul 21 04:41 pg_logical\r\ndrwx------   4 postgres postgres     36 Jul 21 04:41 pg_multixact\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_notify\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_replslot\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_serial\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_snapshots\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_stat\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_stat_tmp\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_subtrans\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_tblspc\r\ndrwx------   2 postgres postgres      6 Jul 21 04:41 pg_twophase\r\n-rw-------   1 postgres postgres      3 Jul 21 04:41 PG_VERSION\r\ndrwx------   3 postgres postgres     60 Jul 21 04:41 pg_wal\r\ndrwx------   2 postgres postgres     18 Jul 21 04:41 pg_xact\r\n-rw-------   1 postgres postgres    337 Jul 21 04:41 postgresql.auto.conf\r\n-rw-------   1 postgres postgres  28770 Jul 21 04:41 postgresql.conf\r\n-rw-------   1 postgres postgres      0 Jul 21 04:41 standby.signal\r\n<\/code><\/pre>\n
\u542f\u52a8 PostgreSQL-14\u3002<\/p>\n
[postgres@db-server-02 ~]$ exit\r\n[root@db-server-02 ~]# systemctl start postgresql-14\r\n<\/code><\/pre>\n
DB\u670d\u52a1\u5668 #01<\/h2>\n
\u5c1d\u8bd5\u8fde\u63a5\u5230DB\u670d\u52a1\u5668#01\u5e76\u9a8c\u8bc1\u540c\u6b65\u72b6\u6001\u3002<\/p>\n
[postgres@db-server-01 ~]$ psql\r\npostgres=# select * from pg_stat_replication;\r\n pid  | usesysid |  usename  | application_name |   client_addr   | client_hostname | client_port | backend_start | backend_xmin |   state   | sent_lsn  | write_lsn | flush_lsn | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_state | reply_time\r\n------+----------+-----------+------------------+-----------------+-----------------+-------------+-------------------------------+--------------+-----------+-----------+-----------+-----------+------------+-----------+-----------+------------+---------------+------------+-------------------------------\r\n 4848 |    16384 | repl_user | walreceiver      | 192.168.255.130 |                 |       59322 | 2023-07-21 04:44:53.702684-07 || streaming | 0\/3000060 | 0\/3000060 | 0\/3000060 | 0\/3000060  |           |           |            |             1 | sync       | 2023-07-21 04:45:23.758623-07\r\n(1 row)\r\n<\/code><\/pre>\n
\u5982\u679csync_state\u5904\u4e8esync\u72b6\u6001\uff0c\u90a3\u5c31OK\uff01\u987a\u4fbf\u8bf4\u4e00\u4e0b\uff0casync\u662f\u5f02\u6b65\u72b6\u6001\u3002<\/p>\n
\u5982\u679c\u5728”select * from pg_stat_replication;”\u67e5\u8be2\u8bed\u53e5\u4e2d\u6ca1\u6709\u4efb\u4f55\u8f93\u51fa\u7ed3\u679c\uff0c\u90a3\u4e48\u8bf4\u660e\u5904\u4e8e\u65e2\u975e\u540c\u6b65\u4e5f\u975e\u5f02\u6b65\u7684\u72b6\u6001\u3002<\/p>\n
\u786e\u8ba4\u52a8\u4f5c<\/h2>\n
\u6211\u5011\u4f86\u8a66\u8a66\u505a\u500b\u6372\u9905\u5427\u3002<\/p>\n
\u7b2c\u4e00\u4e2aDB\u670d\u52a1\u5668<\/p>\n
postgres=# CREATE ROLE test;\r\nCREATE ROLE\r\npostgres=# DROP ROLE test;\r\nDROP ROLE\r\n<\/code><\/pre>\n
\u6570\u636e\u5e93\u670d\u52a1\u5668#02<\/p>\n
postgres=# \\du\r\n                                   List of roles\r\n Role name |                         Attributes                         | Member of\r\n-----------+------------------------------------------------------------+-----------\r\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}\r\n repl_user | Replication                                                | {}\r\n test      | Cannot login                                               | {}\r\n\r\npostgres=# \\du\r\n                                   List of roles\r\n Role name |                         Attributes                         | Member of\r\n-----------+------------------------------------------------------------+-----------\r\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}\r\n repl_user | Replication\r\n<\/code><\/pre>\n
\u597d\u50cf\u53ef\u4ee5\u5728\u540c\u4e00\u65f6\u95f4\u5b8c\u6210\uff01<\/p>\n
\u9519\u8bef\u5904\u7406<\/h1>\n
\u6211\u4f1a\u8bb0\u4e0b\u81ea\u5df1\u9047\u5230\u7684\u9519\u8bef\u3002
\n\u4f9b\u53c2\u8003\u3002<\/p>\n
\u8fde\u63a5\u5931\u8d25<\/h2>\n
\u5728\u5c1d\u8bd5\u521b\u5efa repl_user \u65f6\uff0c\u6267\u884c createuser \u547d\u4ee4\u65f6\u9047\u5230\u4ee5\u4e0b\u9519\u8bef…<\/p>\n
[postgres@db-server-01 ~]$ createuser --replication -P repl_user\r\nEnter password for new role:\r\nEnter it again:\r\ncreateuser: error: connection to server on socket \"\/var\/run\/postgresql\/.s.PGSQL.5432\" failed: No such file or directory\r\n        Is the server running locally and accepting connections on that socket?\r\n<\/code><\/pre>\n
\u7531\u4e8e\u670d\u52a1\u672a\u542f\u52a8\uff0c\u8fd9\u662f\u539f\u56e0\u3002\u670d\u52a1\u5904\u4e8e”\u4e0d\u6d3b\u8dc3\uff08\u65e0\u54cd\u5e94\uff09”\u72b6\u6001\u3002<\/p>\n
[root@db-server-01 ~]# systemctl status postgresql-14\r\n\u25cf postgresql-14.service - PostgreSQL 14 database server\r\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql-14.service; enabled; vendor preset: disabled)\r\n   Active: inactive (dead) since Fri 2023-07-21 03:14:37 PDT; 26min ago\r\n     Docs: https:\/\/www.postgresql.org\/docs\/14\/static\/\r\n  Process: 1100 ExecStart=\/usr\/pgsql-14\/bin\/postmaster -D ${PGDATA} (code=exited, status=0\/SUCCESS)\r\n  Process: 1077 ExecStartPre=\/usr\/pgsql-14\/bin\/postgresql-14-check-db-dir ${PGDATA} (code=exited, status=0\/SUCCESS)\r\n Main PID: 1100 (code=exited, status=0\/SUCCESS)\r\n\r\nJul 21 03:09:27 db-server-01 systemd[1]: Starting PostgreSQL 14 database server...\r\nJul 21 03:14:37 db-server-01 systemd[1]: Stopped PostgreSQL 14 database server.\r\nHint: Some lines were ellipsized, use -l to show in full.\r\n<\/code><\/pre>\n
\u56e0\u6b64\uff0c\u6211\u5011\u5c07\u958b\u59cb\u64cd\u4f5c\u3002<\/p>\n
[root@db-server-01 ~]# systemctl start postgresql-14\r\n[root@db-server-01 ~]# systemctl status postgresql-14\r\n\u25cf postgresql-14.service - PostgreSQL 14 database server\r\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql-14.service; enabled; vendor preset: disabled)\r\n   Active: active (running) since Fri 2023-07-21 03:57:26 PDT; 7s ago\r\n     Docs: https:\/\/www.postgresql.org\/docs\/14\/static\/\r\n  Process: 3278 ExecStartPre=\/usr\/pgsql-14\/bin\/postgresql-14-check-db-dir ${PGDATA} (code=exited, status=0\/SUCCESS)\r\n Main PID: 3284 (postmaster)\r\n    Tasks: 8\r\n   CGroup: \/system.slice\/postgresql-14.service\r\n           tq3284 \/usr\/pgsql-14\/bin\/postmaster -D \/database\/data\/\r\n           tq3286 postgres: logger\r\n\r\nJul 21 03:57:26 db-server-01 systemd[1]: Started PostgreSQL 14 database server.\r\nHint: Some lines were ellipsized, use -l to show in full.\r\n<\/code><\/pre>\n
\u518d\u6b21\u5c1d\u8bd5\u6267\u884ccreateuser\u3002<\/p>\n
[postgres@db-server-01 ~]$ createuser --replication -P repl_user\r\nEnter password for new role:\r\nEnter it again:\r\n\r\n<\/code><\/pre>\n
\u90a3\u4e2a…\uff1f
\n\u6ca1\u6709\u6536\u5230\u56de\u5e94..
\n\u5148\u6309Ctrl + C\u952e\u8fde\u63a5\u5230\u6570\u636e\u5e93\uff0c\u7136\u540e\u68c0\u67e5\u89d2\u8272\u662f\u5426\u5df2\u521b\u5efa\u3002<\/p>\n
[postgres@db-server-01 ~]$ psql\r\npostgres=# \\du\r\n                                   List of roles\r\n Role name |                         Attributes                         | Member of\r\n-----------+------------------------------------------------------------+-----------\r\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}\r\n<\/code><\/pre>\n
\u539f\u56e0\u662f\u56e0\u4e3a synchronous_standby_names = ‘*’\u3002<\/p>\n
\u8fd9\u4e2a\u53c2\u6570\u662f\u7528\u6765\u8bbe\u7f6e\u540c\u6b65\u7684\u5907\u673a\u670d\u52a1\u5668\u7684\uff0c\u4f46\u76ee\u524d\u65e0\u6cd5\u4e0e\u4efb\u4f55\u5730\u65b9\u8fdb\u884c\u540c\u6b65\uff0c\u56e0\u4e3a\u65e0\u6cd5\u5c06\u201crepl_user\u5df2\u521b\u5efa\u201d\u7684\u4fe1\u606f\u53d1\u9001\u5230\u5907\u673a\u670d\u52a1\u5668\uff0c\u6240\u4ee5\u6ca1\u6709\u8fd4\u56de\u54cd\u5e94\u3002<\/p>\n
\u5728\u91cd\u65b0\u5f00\u59cb\u4e4b\u524d\uff0c\u6211\u672c\u4ee5\u4e3a\u5728DB\u670d\u52a1\u5668#01\u4e0a\u5e76\u6ca1\u6709\u521b\u5efa\u89d2\u8272\uff0c\u4f46\u4e8b\u5b9e\u4e0a\u786e\u5b9e\u6709\u3002<\/p>\n
\u91cd\u65b0\u542f\u52a8 PostgreSQL-14 \u5e76\u518d\u6b21\u786e\u8ba4\uff0c\u53ef\u4ee5\u770b\u5230\u89d2\u8272\u5b58\u5728\u3002<\/p>\n
[postgres@db-server-01 ~]$ exit\r\n[root@db-server-01 ~]# systemctl restart postgresql-14\r\n[root@db-server-01 ~]# su - postgres\r\n[postgres@db-server-01 ~]$ psql\r\npostgres=# \\du\r\n                                   List of roles\r\n Role name |                         Attributes                         | Member of\r\n-----------+------------------------------------------------------------+-----------\r\n postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}\r\n repl_user | Replication                                                | {}\r\n<\/code><\/pre>\n
\u6682\u65f6\u505a\u597d\u4e86\u5377\u997c\uff0c\u6ca1\u95ee\u9898\uff01<\/p>\n
\u65e0\u6cd5\u8fde\u63a5\u5230\u4e3b\u673a<\/h2>\n
\u6267\u884c pg_basebackup \u547d\u4ee4\u65f6\u51fa\u73b0\u9519\u8bef\u3002\u3002<\/p>\n
[postgres@db-server-02 ~]$pg_basebackup -R -h 192.168.255.129 -U repl_user -D \/database\/data -P\r\npg_basebackup: error: connection to server at \"192.168.255.129\", port 5432 failed: No route to host\r\n        Is the server running on that host and accepting TCP\/IP connections?\r\n<\/code><\/pre>\n
192.168.255.129\uff08DB\u670d\u52a1\u5668#01\uff09\u76845432\u7aef\u53e3\u597d\u50cf\u65e0\u6cd5\u8fde\u63a5\uff01\u770b\u8d77\u6765\u5f88\u751f\u6c14\u7684\u6837\u5b50\u3002<\/p>\n
\u9996\u5148\uff0c\u6211\u4eec\u5c1d\u8bd5\u4f7f\u7528ping\u547d\u4ee4\u6d4b\u8bd5\u662f\u5426\u53ef\u4ee5\u4e0e192.168.255.129\u8fdb\u884c\u901a\u4fe1\u3002
\n\u4e22\u5305\u7387\u4e3a0%\uff0c\u770b\u8d77\u6765\u6ca1\u6709\u4efb\u4f55\u95ee\u9898\u3002<\/p>\n
[root@db-server-02 ~]$ping 192.168.255.129\r\nPING 192.168.255.129 (192.168.255.129) 56(84) bytes of data.\r\n64 bytes from 192.168.255.129: icmp_seq=1 ttl=64 time=0.530 ms\r\n64 bytes from 192.168.255.129: icmp_seq=2 ttl=64 time=0.631 ms\r\n^C\r\n--- 192.168.255.129 ping statistics ---\r\n2 packets transmitted, 2 received, 0% packet loss, time 2005ms\r\nrtt min\/avg\/max\/mdev = 0.530\/0.614\/0.683\/0.069 ms\r\n<\/code><\/pre>\n
\u90a3\u5c31\u610f\u5473\u77405432\u7aef\u53e3\u662f\u5173\u95ed\u7684\uff0c\u9700\u8981\u53bb\u68c0\u67e5\u4e00\u4e0bfirewalld\u3002<\/p>\n
[root@db-server-02 ~]$systemctl status firewalld\r\n\u25cf firewalld.service - firewalld - dynamic firewall daemon\r\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/firewalld.service; enabled; vendor preset: enabled)\r\n   Active: active (running) since Fri 2023-07-21 03:09:36 PDT; 1h 18min ago\r\n     Docs: man:firewalld(1)\r\n Main PID: 660 (firewalld)\r\n    Tasks: 2\r\n   CGroup: \/system.slice\/firewalld.service\r\n           mq660 \/usr\/bin\/python2 -Es \/usr\/sbin\/firewalld --nofork --nopid\r\n<\/code><\/pre>\n
\u7531\u4e8e\u6d3b\u52a8\u72b6\u6001\uff08\u6b63\u5728\u8fd0\u884c\uff09\u65e0\u6cd5\u505c\u6b62\u6b64\u5b50\u7a0b\u5e8f\u3002
\n\u505c\u6b62\u5728DB\u670d\u52a1\u5668\uff0301\u548cDB\u670d\u52a1\u5668\uff0302\u4e0a\u3002
\n\u203b\u8fd9\u6b21\u662f\u4e3a\u4e86\u5b66\u4e60\u6570\u636e\u5e93\u800c\u505c\u6b62\uff0c\u4f46\u8bf7\u786e\u8ba4\u505c\u6b62\u4e0d\u4f1a\u6709\u95ee\u9898…..<\/p>\n
\u987a\u4fbf\u628a\u81ea\u52a8\u542f\u52a8\u4e5f\u5173\u95ed\u4e86\u3002<\/p>\n
[root@db-server-02 ~]# systemctl stop firewalld\r\n[root@db-server-02 ~]# systemctl disable firewalld\r\nRemoved symlink \/etc\/systemd\/system\/multi-user.target.wants\/firewalld.service.\r\nRemoved symlink \/etc\/systemd\/system\/dbus-org.fedoraproject.FirewallD1.service.\r\n[root@db-server-02 ~]# systemctl is-enabled firewalld\r\ndisabled\r\n<\/code><\/pre>\n
\u4e3a\u4e86\u786e\u5b9a\uff0c\u786e\u8ba4\u4e00\u4e0b SELinux\u3002
\n\u5b83\u5df2\u7ecf\u88ab\u7981\u7528\u4e86\uff0c\u770b\u8d77\u6765\u6ca1\u95ee\u9898\uff01<\/p>\n
[root@db-server-02 ~]# getenforce\r\nDisabled\r\n<\/code><\/pre>\n
\u518d\u6b21\u6267\u884cpg_basebackup\u65f6\uff0c\u4e00\u5207\u90fd\u987a\u5229\u8fdb\u884c\u3002<\/p>\n
[root@db-server-02 ~]# su - postgres\r\n[postgres@db-server-02 ~]$pg_basebackup -R -h 192.168.255.129 -U repl_user -D \/database\/data -P\r\nPassword:           ## createuser \u306e\u6642\u306b\u8a2d\u5b9a\u3057\u305f repl_user \u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\r\n26941\/26941 kB (100%), 1\/1 tablespace\r\n<\/code><\/pre>\n
\u4ee5\u4e0a<\/p>\n
\u6700\u540e<\/h1>\n
\u611f\u8c22\u60a8\u4e00\u76f4\u4ee5\u6765\u7684\u89c2\u770b\u3002<\/p>\n
\u5f88\u9ad8\u5174\u6211\u80fd\u987a\u5229\u4f7f\u7528\u4e86\u590d\u5236\u529f\u80fd\u3002<\/p>\n
\u6211\u60f3\u5c1d\u8bd5\u4e00\u4e0b\u5173\u4e8ewal\u6587\u4ef6\u7684\u90e8\u5206\u4ee5\u53ca\u5907\u4efd\u548c\u6062\u590d\u7684\u90e8\u5206\u3002<\/p>\n
\u8bf7\u52a1\u5fc5\u9605\u8bfb\u5176\u4ed6\u7684\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9996\u5148 \u7531\u4e8e\u4e0a\u6b21\u5df2\u7ecf\u5728CentOS\u4e0a\u5b89\u88c5\u4e86PostgreSQL-14\uff0c\u6240\u4ee5\u8fd9\u6b21\u6211\u4eec\u5c06\u5c1d\u8bd5\u4f7f\u7528\u590d\u5236\u529f\u80fd\u3002 \u53ef\u4ee5\u70b9\u51fb […]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41556","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u4f7f\u7528postgresql-14\u7684\u590d\u5236\u529f\u80fd\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u7531\u4e8e\u4e0a\u6b21\u5df2\u7ecf\u5728CentOS\u4e0a\u5b89\u88c5\u4e86PostgreSQL-14\uff0c\u6240\u4ee5\u8fd9\u6b21\u6211\u4eec\u5c06\u5c1d\u8bd5\u4f7f\u7528\u590d\u5236\u529f\u80fd\u3002 \u53ef\u4ee5\u70b9\u51fb […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u4f7f\u7528postgresql-14\u7684\u590d\u5236\u529f\u80fd\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-22T16:04:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T21:29:05+00:00\" \/>\n<meta name=\"author\" content=\"\u96c5, \u609f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u96c5, \u609f\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/\",\"name\":\"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2024-01-22T16:04:19+00:00\",\"dateModified\":\"2024-04-29T21:29:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\",\"name\":\"\u96c5, \u609f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"caption\":\"\u96c5, \u609f\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u4f7f\u7528postgresql-14\u7684\u590d\u5236\u529f\u80fd\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd","og_description":"\u9996\u5148 \u7531\u4e8e\u4e0a\u6b21\u5df2\u7ecf\u5728CentOS\u4e0a\u5b89\u88c5\u4e86PostgreSQL-14\uff0c\u6240\u4ee5\u8fd9\u6b21\u6211\u4eec\u5c06\u5c1d\u8bd5\u4f7f\u7528\u590d\u5236\u529f\u80fd\u3002 \u53ef\u4ee5\u70b9\u51fb […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u4f7f\u7528postgresql-14\u7684\u590d\u5236\u529f\u80fd\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2024-01-22T16:04:19+00:00","article_modified_time":"2024-04-29T21:29:05+00:00","author":"\u96c5, \u609f","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u96c5, \u609f","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/","name":"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2024-01-22T16:04:19+00:00","dateModified":"2024-04-29T21:29:05+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c1d\u8bd5\u4f7f\u7528PostgreSQL-14\u7684\u590d\u5236\u529f\u80fd"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6","name":"\u96c5, \u609f","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","caption":"\u96c5, \u609f"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e4%bd%bf%e7%94%a8postgresql-14%e7%9a%84%e5%a4%8d%e5%88%b6%e5%8a%9f%e8%83%bd%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=41556"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41556\/revisions"}],"predecessor-version":[{"id":89975,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/41556\/revisions\/89975"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=41556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=41556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=41556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}