sqlpostgresql

What is a postgres superuser

I couldn't find the answer in the docs, what exactly is a superuser in postgres?

Does the superuser have all privileges? Is it per database? Per instance?

Solution

  • https://www.postgresql.org/docs/current/static/sql-createrole.html

    These clauses determine whether the new role is a "superuser", who can override all access restrictions within the database.

    yes - all privileges in all databases on the specified cluster