ERROR: permission denied for schema pglogical

[2ndquadrant]

ERROR: permission denied for schema pglogical

[vojtech-filipec]

I encountered the same behavior and it was resolved by grant usage on schema pglogical to .... Just mentioning it here so that it is clear the issue persists.

Greetings from PostgreSQL 10.13!

[PJMODOS]

You need to have usage privileges on pglogical schema to be able to execute some DDL. This is because we are using event trigger mechanism. We will probably grant usage to public in next version automatically.

[grahamb]

I encountered this issue during a Rails migration that drops and adds indexes. Doing GRANT USAGE ON SCHEMA pglogical TO my_user wasn't sufficient; I had to do GRANT ALL ON SCHEMA pglogical TO my_user in order for it to work. (Postgresql-9.6).

[tarunjain01]

I encountered the same behavior and it was resolved by grant usage on schema pglogical to .... Just mentioning it here so that it is clear the issue persists.

Greetings from PostgreSQL 10.13!

It exists in 12.6 as well.