Re: Replication: Different naming policy

On Thu, 16 Apr 2020 at 04:36, PG Doc comments form <noreply(at)postgresql(dot)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