Replication: Different naming policy

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Replication: Different naming policy

apt.postgresql.org Repository Update
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.
Reply | Threaded
Open this post in threaded view
|

Re: Replication: Different naming policy

Euler Taveira-2
On Thu, 16 Apr 2020 at 04:36, PG Doc comments form <[hidden email]> 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