Re: Replication: Different naming policy

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: Replication: Different naming policy
Дата
Msg-id CAH503wCmmfDBB18HFh8yqB6wxOV_zUAUsMyUaPzX84GMDhwHAA@mail.gmail.com
обсуждение исходный текст
Ответ на Replication: Different naming policy  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Backend Flowchart / Developer doc
Следующее
От: PG Doc comments form
Дата:
Сообщение: pg_stat_statements showing passwords while create or alter users.