TL;DR Link to heading I moved object ownership in Postgres from a shared role to a dedicated role per service, one environment at a time, with the application serving throughout. REASSIGN OWNED does it in one statement and moves every object class. A FOR ALL TABLES publication blocked it on one database, so I went per-object and left functions, types, and schemas behind. A pg_shdepend sweep caught the gap before production, and it is my completeness check now.
No comments yet. Log in to reply on the Fediverse. Comments will appear here.