Logical replication subscription owner

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Logical replication subscription owner
Дата
Msg-id 158695933852.25700.8124720971187835491@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Logical replication subscription owner  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/sql-altersubscription.html
Description:

If the logical replication subscription is owned by a role that is not
allowed to login (for example, if the LOGIN privilege is removed after the
subscription is created) then the logical replication worker (which uses the
owner to connect to the database) will start to fail with this error
(repeated every 5 seconds), which is pretty much undocumented:

FATAL:  role "XXX" is not permitted to log in
LOG:  background worker "logical replication worker" (PID X) exited with
exit code 1

You might want to include that error message in the docs, to ensure that web
searches for it bring the user to this documentation.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Marc Rechté
Дата:
Сообщение: Backend Flowchart / Developer doc
Следующее
От: PG Doc comments form
Дата:
Сообщение: Replication: Different naming policy