On Fri, Sep 24, 2021 at 7:28 AM tushar <tushar.ah...@enterprisedb.com> wrote: > On 9/23/21 8:35 PM, Robert Haas wrote: > > Thanks. Looks like that version had some stupid mistakes. Here's a new one. > > Thanks, the reported issue seems to be fixed now for HEAD w/patch > (publication) to HEAD w/patch (subscription) but still getting the same > error if we try to perform v12(publication) to HEAD > w/patch(subscription) . I checked there is no such issue for > v12(publication) to v14 RC1 (subscription) > > postgres=# create subscription sub123s CONNECTION 'host=127.0.0.1 > user=edb port=4444 dbname=postgres' PUBLICATION pp with (slot_name = > from_v14); > ERROR: could not create replication slot "from_v14": ERROR: syntax error > postgres=#
I am not able to reproduce this failure. I suspect you made a mistake
in testing, because my test case before sending the patch was
basically the same as yours, except that I was testing with v13. But I
tried again with v12 and it seems fine:
[rhaas pgsql]$ createdb -p 5412
[rhaas pgsql]$ psql -c 'select version()' -p 5412
version
----------------------------------------------------------------------------------------------------------------
PostgreSQL 12.3 on x86_64-apple-darwin19.4.0, compiled by clang
version 5.0.2 (tags/RELEASE_502/final), 64-bit
(1 row)
[rhaas pgsql]$ psql
psql (15devel)
Type "help" for help.
rhaas=# create subscription sub123s CONNECTION 'port=5412' PUBLICATION
pp with (slot_name =
from_v14);
NOTICE: created replication slot "from_v14" on publisher
CREATE SUBSCRIPTION
Here's v9, fixing the issue reported by Fujii Masao.
--
Robert Haas
EDB: http://www.enterprisedb.com
v9-0001-Flexible-options-for-BASE_BACKUP.patch
Description: Binary data
v9-0002-Flexible-options-for-CREATE_REPLICATION_SLOT.patch
Description: Binary data
