Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pg_hba.conf:
- hostssl replication all 0.0.0.0/0 md5
- host replication all 0.0.0.0/0 md5
- from: pg_hba_file_rules:
- ──────────┬─────────┬───────────────┬──────────────┬───────────┬─────────────┬─────────────┬─────────┬───────┐
- │ line_number │ type │ database │ user_name │ address │ netmask │ auth_method │ options │ error │
- ├─────────────┼─────────┼───────────────┼──────────────┼───────────┼─────────────┼─────────────┼─────────┼───────┤
- │ 112 │ hostssl │ {replication} │ {all} │ 0.0.0.0 │ 0.0.0.0 │ md5 │ ¤ │ ¤ │
- │ 113 │ host │ {replication} │ {all} │ 0.0.0.0 │ 0.0.0.0 │ md5 │ ¤ │ ¤ │
- from log:
- May 8 13:37:40 ln-admindb01 postgres[20818]: [16-1] appname=[unknown],user=ps_ro,db=admin,pid=20818,txid=0,vtxid=81/61391 FATAL: no pg_hba.conf entry for replication connection from host "10.19.165.190", user "ps_ro", SSL on
- May 8 13:37:40 ln-admindb01 postgres[20819]: [16-1] appname=[unknown],user=ps_ro,db=admin,pid=20819,txid=0,vtxid=81/61392 FATAL: no pg_hba.conf entry for replication connection from host "10.19.165.190", user "ps_ro", SSL off
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement