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

Reply via email to