Обсуждение: 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
NOTICE: created replication slot "foobar" on publisher
CREATE SUBSCRIPTION
Regards,
Euler Taveira http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services