Re: [HACKERS] No parameter values checking while creating Alter subscription...Connection

2017-05-25 Thread Petr Jelinek
On 25/05/17 23:18, Andres Freund wrote: > 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

Re: [HACKERS] No parameter values checking while creating Alter subscription...Connection

2017-05-25 Thread Andres Freund
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 t

Re: [HACKERS] No parameter values checking while creating Alter subscription...Connection

2017-05-25 Thread Peter Eisentraut
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

Re: [HACKERS] No parameter values checking while creating Alter subscription...Connection

2017-05-25 Thread Masahiko Sawada
On Thu, May 25, 2017 at 9:43 AM, tushar wrote: > 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 con