EnterpriseDB/repmgr

Repmgr clone in SSL network

seunofk opened this issue · 0 comments

Hello. Everyone,

I tried repmgr clone in SSL network environment and got below error.

Repmgr version 5.2.1

PostgreSQL 10.8

[postgres@kmddb01 ~]$ repmgr standby clone -d repmgr -U repmgr -h kmddb02 -F NOTICE: destination directory "/postgres/data/default" provided
INFO: connecting to source node
DETAIL: connection string is: user-repmgr host-kmddb02 dbname-exper db DETAIL: current installation size is 381 GB
31
NOTICE: checking for available walsenders on the source node (2 required)
exists but is not empty
NOTICE: checking replication connections can be made to the source server (2 required) WARNING: directory /postgres/data/default'
NOTICE: F/--force provided deleting existing data directory "/postgres/data/default" INFO: creating replication slot as user "repmgr"
NOTICE: starting backup (using pg_basebackup)...
HINT: this may take some time; consider using the -c/--fast-checkpoint option INFO: executing:
/postgres/app/postgres/bin/pg_basebackup -1 "repmgr base backup" -D /postgres/data/default -h kmddb02 -p 20402 -U repmgr -x stream -s repmgr_slot_3

ERROR: _get_node_record(): unable to execute query
DETAIL:
SSL SYSCALL error: EOF detected

DETAIL: query text is:
SELECT n. node_id, n. type, n. upstream_node_id, n. node_name, n. conninfo, n.repluser, n. slot_name, n. location, n. priority, n. active, n. config file, AS upstream_node_name, NULL AS attached FROM repmgr. nodes n WHERE n. node_id = 1 WARNING: no record exists for designated upstream node 1
HINT: you'll need to create the replication slot ("repmgr_slot_3") manually
ERROR: get_slot_record(): unable to query pg_replication slots
DETAIL:
no connection to the server
DETAIL: query text is:
SELECT slot_name, slot_type, active FROM pg catalog.pg_replication_slots NOTICE: replication slot repmgr slot 3" deleted on source node NOTICE: standby clone (using pg_basebackup) complete NOTICE: you can now start your PostgreSQL server
HINT: for example: pg_ctl -D /postgres/data/default start ERROR: _get_node_record(): unable to execute query DETAIL:
SSL SYSCALL error: EOF detected
DETAIL: query text is:
SELECT n. node_id, n. type, n. upstream_node_id, n. node_name,
AS attached FROM repmgr. nodes n WHERE n. node_id=3
WHERE slot_name 'repmgr_slot_3'
n. conninfo, n.repluser, n. slot_name, n. location, n. priority, n. active, n. config file, AS upstream_node_name, NULL
HINT: after starting the server, you need to register this standby with "repmgr standby register"

What is the problem and what is the solution?

I'm new to github, so I apologize in advance if I'm not polite. :)