Postgres Pro
Downloads
Home   >   mailing lists

Thread: Replication: Different naming policy

Replication: Different naming policy

From
PG Doc comments form
Date:
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.

Re: Replication: Different naming policy

From
Euler Taveira
Date:
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