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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
