We recommend using cloud managed databases which in general should come with the appropriate settings and permissions out of the box.
In case you need to configure these yourself, you'll find a detailed list of required settings and permissions in the table below. See also the official Postgres docs for more information on granting privileges.
Your PostgreSQL database will need to have the
uuid-osspextension installed. This is default for most cloud managed PostgreSQL databases. In case you need to install it manually, you can do so by running the following as an admin user in the database's
CREATE EXTENSION "uuid-ossp";
Furthermore, the following settings and permissions need to be applied at the database, schema, and user level: