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?
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