Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is a postgres superuser

Tags:

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?

like image 951
Binyamin Avatar asked Jul 04 '17 10:07

Binyamin


2 Answers

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

like image 182
Vao Tsun Avatar answered Sep 23 '22 04:09

Vao Tsun


A superuser in PostgreSQL is a user who bypasses all permission checks.

Superusers can run commands that can destabilize or crash the database server (e.g., create C functions) and access the operating system.

like image 29
Laurenz Albe Avatar answered Sep 23 '22 04:09

Laurenz Albe