Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- FOLLOWING ENTRIES ON PUBLISHER:
- hostssl replication ps_ro 10.0.0.0/8 md5
- hostssl replication ps_ro 10.19.0.0/16 md5
- hostssl replication ps_ro 10.19.165.0/24 md5
- hostssl replication ps_ro 10.19.165.190/32 md5
- "/etc/postgresql/10/main/select * from pg_hba_file_rules where database='{replication}'; 117,26-32 Bot
- ┌─────────────┬─────────┬───────────────┬──────────────┬───────────────┬─────────────────┬─────────────┬─────────┬───────┐
- │ line_number │ type │ database │ user_name │ address │ netmask │ auth_method │ options │ error │
- ├─────────────┼─────────┼───────────────┼──────────────┼───────────────┼─────────────────┼─────────────┼─────────┼───────┤
- │ 112 │ hostssl │ {replication} │ {replicator} │ 10.17.0.0 │ 255.255.0.0 │ md5 │ ¤ │ ¤ │
- │ 114 │ hostssl │ {replication} │ {ps_ro} │ 10.0.0.0 │ 255.0.0.0 │ md5 │ ¤ │ ¤ │
- │ 115 │ hostssl │ {replication} │ {ps_ro} │ 10.19.0.0 │ 255.255.0.0 │ md5 │ ¤ │ ¤ │
- │ 116 │ hostssl │ {replication} │ {ps_ro} │ 10.19.165.0 │ 255.255.255.0 │ md5 │ ¤ │ ¤ │
- │ 117 │ hostssl │ {replication} │ {ps_ro} │ 10.19.165.190 │ 255.255.255.255 │ md5 │ ¤ │ ¤ │
- └─────────────┴─────────┴───────────────┴──────────────┴───────────────┴─────────────────┴─────────────┴─────────┴───────┘
- FOLLOWING ERROR ON SUBSCRIBER:
- psql:create_ro_admin_subscription.sql:3: ERROR: XX000: could not connect to the publisher: FATAL: no pg_hba.conf entry for replication connection from host "10.19.165.190", user "ps_ro", SSL on
- FATAL: no pg_hba.conf entry for replication connection from host "10.19.165.190", user "ps_ro", SSL off
- LOCATION: CreateSubscription, subscriptioncmds.c:429
Advertisement
Add Comment
Please, Sign In to add comment
