| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Cc: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: No parameter values checking while creating Alter subscription...Connection |
| Date: | 2017-05-25 21:18:52 |
| Message-ID: | 20170525211852.c5u5crw3pxwrueh2@alap3.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-05-25 21:24:57 | Re: Renaming a table to an array's autogenerated name |
| Previous Message | Michael Paquier | 2017-05-25 21:17:39 | Channel binding support for SCRAM-SHA-256 |