On 2017-05-25 17:08:57 -0400, Peter Eisentraut wrote: > On 5/25/17 10:18, Masahiko Sawada wrote: > >> postgres=# alter subscription c1 connection 'port=4000'; > >> ALTER SUBSCRIPTION > >> postgres=# alter subscription c1 connection 'dbname=cc'; > >> ALTER SUBSCRIPTION > >> > > CREATE SUBSCRIPTION tries to connect to publisher to create > > replication slot or to get table list for table synchronization, not > > to check the connection parameter value. So if you specify connect = > > false then CREATE SUBSCRIPTION doesn't try to connect. > > We don't make a connection attempt as part of ALTER SUBSCRIPTION. I > guess we could just connect and disconnect to check that it works.
I think during reconfigurations it's quite useful to be able to do so even if the other hosts aren't reachable that second. - Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers