Hi,
We usually check connection parameter values while creating create
subscription
\\port is WRONG
postgres=# create subscription c1 connection 'port=4000 ' publication pub;
ERROR: could not connect to the publisher: could not connect to server:
No such file or directory Is the server running locally and accepting connections on Unix domain socket
"/tmp/.s.PGSQL.4000"?
postgres=#
\\when database doesn't exist
postgres=# create subscription c1 connection 'dbname=postgre '
publication pub;
ERROR: could not connect to the publisher: FATAL: database "postgre"
does not exist
postgres=#
but such checking is not done at the time of alter subscription ..
connection
postgres=# alter subscription c1 connection 'port=4000';
ALTER SUBSCRIPTION
postgres=# alter subscription c1 connection 'dbname=cc';
ALTER SUBSCRIPTION
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company