How to allow users to create and modify tables only in their own schemas, but with generic table owner

Hi List I'd like to setup my database in a way that only a superuser may create schemas, then grants permission to a specific user to create tables inside this schema. This should work so far with GRANT CREATE ON SCHEMA ... TO user_a. However I want the table owner not to be the user that creat

PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

Hi I'm trying to install the postgresql-17 Debian package from PGDG apt repo alongside an already existing PostgreSQL 16 installation. So there is already a PostgreSQL 16 cluster on my machine (which I want to upgrade to version 17 using the pg_upgrade command later on). If I'm not wrong, the

AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

> -Ursprüngliche Nachricht- > On Wed, 2025-02-19 at 08:45 +, Schmid Andreas wrote: > > I'm trying to install the postgresql-17 Debian package from PGDG apt > > repo alongside an already existing PostgreSQL 16 installation. So > > there is already a Postgr

AW: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

> -Ursprüngliche Nachricht- > I think that lives here: > https://salsa.debian.org/postgresql/postgresql-common Yes, thanks for the hint. The commit which apparently introduced the change is https://salsa.debian.org/postgresql/postgresql-common/-/commit/d9139fa42a39b5b6fabbffc9f020fad4