Hello everyone, I want to setup an external database (RDS aurora postgreSQL cluster) for a vanilla docker compose stack. I start commenting the db service/volume and start to see than I need temporal and temporal_visibility database after digging errors logs, and now airbyte_metadata relation is missing .... It seems than the documentation isn't explicit enough on it (but maybe i'm wrong), and I want to setup the least privileges. Do someone can shared me some insights about what's really needed to doing this properly ? like a SQL script will be perfect 😄 Thanks !

For a vanilla Docker Compose stack, I believe the following privileges are required for the database user: • CREATE TABLE • CREATE SEQUENCE • CREATE PROCEDURE • CREATE TYPE • CREATE VIEW In addition to these privileges, the database user will also need SELECT, INSERT, UPDATE, DELETE, and TRUNCATE privileges on the

airbyte_metadata

table.

Thanks. Now i just bypass the problem and use a super-user. But even given all privileges on a normal user didn't work so I will take time and check if what you list are all we need 😉