nn
Size: a a a
nn
СГ
nn
nn
# TYPE DATABASE USER ADDRESS METHOD/du+
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
#host all all 127.0.0.1/32 trust
host all all 0.0.0.0/0 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication all trust
#host replication all 127.0.0.1/32 trust
#host replication all ::1/128 trust
host replication replic 127.0.0.1/32 trust
host replication replic 172.24.4.152/32 trust
host replication replic 172.24.4.153/32 trust
postgres=# \du+pg_basebackup -h 172.27.4.152 (ip master) -U replica -D /var/lib/postgresql/11/data/ -P
List of roles
Role name | Attributes | Member of | Description
-------------+------------------------------------------------------------+-----------+-------------
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} |
replica | Replication +| {} |
| 1 connection | |
replication | Replication +| {} |
| 1 connection | |
СГ
nn
nn
t
СГ
nn
nn
СГ
nn
СГ
nn
< 2021-06-11 17:15:51.039 MSK >FATAL: no pg_hba.conf entry for replication connection from host "172.27.4.153", user "replica", SSL offnn
host replication replica 172.24.4.153/32 trustСГ
СГ