On Thu, 16 Apr 2020 at 04:36, PG Doc comments form <nore...@postgresql.org> wrote:
> > I get the naming error (Replication slot names may only contain lower case > letters, numbers, and underscore character. > > This is not a bug. The message is clear. Postgres uses the subscription name to name replication slot and since it uses a limited set of characters, you get this error. If you want to use such a weird name, specify a slot name such as: postgres=# Create subscription "suball master(192.168.1.180) slave(192.168.1.185)" connection 'port=5432 dbname=test' publication "PubAll Master(192.168.1.180) Slave(192.168.1.185)" with (slot_name = foobar); NOTICE: created replication slot "foobar" on publisher CREATE SUBSCRIPTION Regards, -- Euler Taveira http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services