Postgres Pro
Downloads
Home   >   mailing lists

Re: Replication: Different naming policy - Mailing list pgsql-docs

From Euler Taveira
Subject Re: Replication: Different naming policy
Date
Msg-id CAH503wCmmfDBB18HFh8yqB6wxOV_zUAUsMyUaPzX84GMDhwHAA@mail.gmail.com
Whole thread Raw
In response to Replication: Different naming policy  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
Tree view
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

pgsql-docs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Backend Flowchart / Developer doc
Next
From: PG Doc comments form
Date:
Subject: pg_stat_statements showing passwords while create or alter users.