The host when creating the subscription is not correct. I couldn't find because by creating the subscription it changes the host that was not defined by one "generic" in format postgres-${node_name}:
image in use: pgedge-postgres:17.7-spock5.0.4-standard-1
LOGS:
[wire] Creating full-mesh subscriptions (idempotent; providers use 'replicacion')...
[wire] ensuring sub_wyse1_rasp1 exists on wyse1 -> rasp1 ...
ERROR: could not connect to the postgresql server: could not translate host name "postgres-wyse1" (not correct host, it should be: "example-host") to address: Name or service not known
DETAIL: dsn was: host=postgres-wyse1 (not correct host, it should be: "example-host") port=5432 dbname=example user=replicacion password=PASSWORD
IN COMPOSE FILE:
environment: (in spock-wire)
PGADMIN_USER: ${ADMIN_USER}
PGADMIN_PASSWORD: ${ADMIN_PASSWORD}
REPL_USER: ${REPL_USER}
REPL_PASSWORD: ${REPL_PASSWORD}
DBNAME: ${POSTGRES_DB}
# name:host:port entries (extend for more nodes)
NODES: "wyse1:example-host:5432,rasp1:192.168.120.91:7941,rasp2:192.168.120.92:7942" # the "host" is: example-host
The host when creating the subscription is not correct. I couldn't find because by creating the subscription it changes the host that was not defined by one "generic" in format postgres-${node_name}:
image in use: pgedge-postgres:17.7-spock5.0.4-standard-1
LOGS:
[wire] Creating full-mesh subscriptions (idempotent; providers use 'replicacion')...
[wire] ensuring sub_wyse1_rasp1 exists on wyse1 -> rasp1 ...
ERROR: could not connect to the postgresql server: could not translate host name "postgres-wyse1" (not correct host, it should be: "example-host") to address: Name or service not known
DETAIL: dsn was: host=postgres-wyse1 (not correct host, it should be: "example-host") port=5432 dbname=example user=replicacion password=PASSWORD
IN COMPOSE FILE:
environment: (in spock-wire)
PGADMIN_USER: ${ADMIN_USER}
PGADMIN_PASSWORD: ${ADMIN_PASSWORD}
REPL_USER: ${REPL_USER}
REPL_PASSWORD: ${REPL_PASSWORD}
DBNAME: ${POSTGRES_DB}
# name:host:port entries (extend for more nodes)
NODES: "wyse1:example-host:5432,rasp1:192.168.120.91:7941,rasp2:192.168.120.92:7942" # the "host" is: example-host