Request a Demo
Home   >   mailing lists

Additional info for CREATE ROLE with REPLICATION - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Additional info for CREATE ROLE with REPLICATION
Date
Msg-id CAB-JLwZLgLNOkce=VsQOcThBy=xqZbELdQ-7cbYh2xucfwbgmQ@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Tree view
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.

[0] - https://www.postgresql.org/docs/current/sql-createrole.html

regards
Marcos

Attachment

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
Next
From: M.Atıf Ceylan
Date:
Subject: [PATCH] psql: add size-based sorting options (O/o) for tables and indexes