listen_addresses = '*' port = 5432 # vi /var/lib/pgsql/13/data/pg_hba.conf #pg-13版本，添加以下一行表示允 许所有客户端ip远程连接 #若修改了存储路径，则在新的路径下/data_pg/data/pg_hba.conf host all all 0.0.0.0/0 listen_addresses = '*' port = 5432 # vi /var/lib/pgsql/data/pg_hba.conf #pg-10版本，添加以下一行表示允许 所有客户端ip远程连接 #若修改了存储路径，则在新的路径下/data_pg/data/pg_hba.conf host all all 0.0.0.0/0 ★防火墙放通5432/tcp # firewall-cmd --add-port=5432/tcp --permanent # firewall-cmd --reload pg_hba.conf 配 置 保 存 在 postgres 库 下 面 的 名 为 pg_catalg 的 schema 下 的 pg_hba_file_rules表里： INSERT INTO "pg_hba_file_rules"

...............................................................................499 19.1. The pg_hba.conf File........................................................................................499 PostgreSQL relies on the system’s getaddrinfo function to parse IP addresses in listen_addresses, pg_hba.conf, etc. Older versions of AIX have assorted bugs in this function. If you have problems related to -A password so that the default trust authentication mode is not used; or modify the generated pg_hba.conf file after run- ning initdb, but before you start the server for the first time. (Other reasonable

...............................................................................530 19.1. The pg_hba.conf File.......................................................................................... PostgreSQL relies on the system’s getaddrinfo function to parse IP addresses in listen_addresses, pg_hba.conf, etc. Older versions of AIX have assorted bugs in this function. If you have problems related to -A password so that the default trust authentication mode is not used; or modify the generated pg_hba.conf file after running initdb, but be- fore you start the server for the first time. (Other reasonable

...............................................................................483 19.1. The pg_hba.conf File........................................................................................483 PostgreSQL relies on the system’s getaddrinfo function to parse IP addresses in listen_addresses, pg_hba.conf, etc. Older versions of AIX have assorted bugs in this function. If you have problems related to -A password so that the default trust authentication mode is not used; or modify the generated pg_hba.conf file after run- ning initdb, but before you start the server for the first time. (Other reasonable

...............................................................................515 19.1. The pg_hba.conf File.......................................................................................... PostgreSQL relies on the system’s getaddrinfo function to parse IP addresses in listen_addresses, pg_hba.conf, etc. Older versions of AIX have assorted bugs in this function. If you have problems related to -A password so that the default trust authentication mode is not used; or modify the generated pg_hba.conf file after running initdb, but be- fore you start the server for the first time. (Other reasonable

...............................................................................461 19.1. The pg_hba.conf File........................................................................................461 PostgreSQL relies on the system’s getaddrinfo function to parse IP addresses in listen_addresses, pg_hba.conf, etc. Older versions of AIX have assorted bugs in this function. If you have problems related to -A password so that the default trust authentication mode is not used; or modify the generated pg_hba.conf file after run- ning initdb, but before you start the server for the first time. (Other reasonable

..........................................................................490 xii 19.1. The pg_hba.conf File.......................................................................................... PostgreSQL relies on the system’s getaddrinfo function to parse IP addresses in listen_addresses, pg_hba.conf, etc. Older versions of AIX have assorted bugs in this function. If you have problems related to -A password so that the default trust authentication mode is not used; or modify the generated pg_hba.conf file after running initdb, but be- fore you start the server for the first time. (Other reasonable

...............................................................................470 19.1. The pg_hba.conf file.......................................................................................... of course not be included. If necessary, edit the permissions in the file /usr/local/pgsql/data/pg_hba.conf (or equivalent) to disallow access from everyone except you. To back up your database installation are upgrading). /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data 6. Restore your previous pg_hba.conf and any postgresql.conf modifications. 7. Start the database server, again using the special database

...............................................................................439 19.1. The pg_hba.conf file.........................................................................................439 of course not be included. If necessary, edit the permissions in the file /usr/local/pgsql/data/pg_hba.conf (or equivalent) to disallow access from everyone except you. To back up your database installation are upgrading). /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data 6. Restore your previous pg_hba.conf and any postgresql.conf modifications. 7. Start the database server, again using the special database

...............................................................................345 20.1. The pg_hba.conf file.......................................................................................... of course not be included. If necessary, edit the permissions in the file /usr/local/pgsql/data/pg_hba.conf (or equivalent) to disallow access from everyone except you. 2. To back up your database installation -A password so that the default trust authentication mode is not used; or modify the generated pg_hba.conf file after running initdb, before you start the server for the first time. (Other reasonable approaches