Skip to content
Advertisement

Postgres database migrations with vault

I am currently using vault to generate database credentials.
The service itself handles migrations against the database.
I end up with tables owned by the generated vault role. the database administrator loses access to these tables and is not able to generate a new user against the same set of tables.
Any tips or ideas on how to solve this in a good way?

Advertisement

Answer

Solution is to create a trigger on create table to alter the table owner to a shared admin group.
https://www.postgresql.org/docs/9.1/sql-createtrigger.html

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement