Replication: Different naming policy
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-createsubscription.html
Description:
Hi, i'm using v10 and
Create publication "PubAll Master(192.168.1.180) Slave(192.168.1.185)"
....
Works fine, but
Create publication "suball master(192.168.1.180) slave(192.168.1.185)"
....
I get the naming error (Replication slot names may only contain lower case
letters, numbers, and underscore character.
Don't know about other versions but
Thought to imply to this matter, thanks.
On Thu, 16 Apr 2020 at 04:36, PG Doc comments form <noreply@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