Additional info for CREATE ROLE with REPLICATION

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Additional info for CREATE ROLE with REPLICATION
Дата
Msg-id CAB-JLwZLgLNOkce=VsQOcThBy=xqZbELdQ-7cbYh2xucfwbgmQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Additional info for CREATE ROLE with REPLICATION
Список pgsql-hackers
When a logical replication is created and a ROLE with REPLICATION clause is used for that, there is no info on [0] that that role needs to have read permission on those tables. CREATE PUBLICATION and CREATE SUBSCRIPTION commands works as expected but replication doesn't work, only a "access denied" is added on logs.

So it would be good to explain that a GRANT is needed.


regards
Marcos

Вложения

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