Advertisement
cnemelka

pg_hba.conf connection anomaly

May 8th, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. pg_hba.conf:
  2. hostssl replication all 0.0.0.0/0 md5
  3. host replication all 0.0.0.0/0 md5
  4.  
  5. from: pg_hba_file_rules:
  6. ──────────┬─────────┬───────────────┬──────────────┬───────────┬─────────────┬─────────────┬─────────┬───────┐
  7. │ line_number │ type │ database │ user_name │ address │ netmask │ auth_method │ options │ error │
  8. ├─────────────┼─────────┼───────────────┼──────────────┼───────────┼─────────────┼─────────────┼─────────┼───────┤
  9. │ 112 │ hostssl │ {replication} │ {all} │ 0.0.0.0 │ 0.0.0.0 │ md5 │ ¤ │ ¤ │
  10. │ 113 │ host │ {replication} │ {all} │ 0.0.0.0 │ 0.0.0.0 │ md5 │ ¤ │ ¤ │
  11.  
  12. from log:
  13. 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
  14. 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