permission denied
when i run a ALTER SYSTEM COMMAND , i get ERROR: permission denied to set parameter "wal_level" (SQLSTATE 42501) , i'm a neon superuser , so why could this be happening , or i don't have permission to run a ALTER SYSTEM command in neon db ?
1 Reply
adverse-sapphire•2y ago
Hey, the neon_superuser does not include that privilege: https://neon.tech/docs/manage/roles#the-neonsuperuser-role
However, you can set wal_level=logical for your project in the Neon Console. See: https://neon.tech/docs/manage/projects#enable-logical-replication
Neon
Manage projects - Neon Docs
With Neon, everything starts with the project. It is the top level object in the Neon object hierarchy. A project can hold as many databases, and with the Neon Pro Plan, as many branches of those data...
Neon
Manage roles - Neon Docs
In Neon, roles are Postgres roles. Each Neon project is created with a default Postgres role that takes its name from your Neon account (the email, GitHub, Google, or partner account that you register...