Thread: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need to change with SETkeyword
[HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need to change with SETkeyword
From
tushar
Date:
Hi,
There is small issue in the HINT message which we provide at the time of dropping subscription ,where we are saying -WITH (slot_name) which need to change with SET (slot_name).
postgres=# drop subscription sub;
ERROR: could not connect to publisher when attempting to drop the replication slot "pub"
DETAIL: The error was: 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.5432"?
HINT: Use ALTER SUBSCRIPTION ... WITH (slot_name = NONE) to disassociate the subscription from the slot.
expected = "HINT: Use ALTER SUBSCRIPTION ... SET (slot_name = NONE) to disassociate the subscription from the slot."
-- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company
Re: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need tochange with SET keyword
From
Dilip Kumar
Date:
On Fri, May 19, 2017 at 3:41 PM, tushar <tushar.ahuja@enterprisedb.com> wrote: > postgres=# drop subscription sub; > ERROR: could not connect to publisher when attempting to drop the > replication slot "pub" > DETAIL: The error was: 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.5432"? > HINT: Use ALTER SUBSCRIPTION ... WITH (slot_name = NONE) to disassociate > the subscription from the slot. > > expected = "HINT: Use ALTER SUBSCRIPTION ... SET (slot_name = NONE) to > disassociate the subscription from the slot." Seems like syntax got changed in b807f59828fbc02fea612e1cbc0066c6dfa3be9b commit but missed to change the hint. Attached patch fixes that. -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Attachment
Re: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need tochange with SET keyword
From
Peter Eisentraut
Date:
On 5/19/17 06:58, Dilip Kumar wrote: > On Fri, May 19, 2017 at 3:41 PM, tushar <tushar.ahuja@enterprisedb.com> wrote: >> postgres=# drop subscription sub; >> ERROR: could not connect to publisher when attempting to drop the >> replication slot "pub" >> DETAIL: The error was: 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.5432"? >> HINT: Use ALTER SUBSCRIPTION ... WITH (slot_name = NONE) to disassociate >> the subscription from the slot. >> >> expected = "HINT: Use ALTER SUBSCRIPTION ... SET (slot_name = NONE) to >> disassociate the subscription from the slot." > > Seems like syntax got changed in > b807f59828fbc02fea612e1cbc0066c6dfa3be9b commit but missed to change > the hint. Attached patch fixes that. Fixed, thanks. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services