What level of permission is needed for the postgre...
# ask-ai
r
What level of permission is needed for the postgres user? we are getting this error when trying to launch airbyte with helm with our own RDS instance
Copy code
2023-05-17T18:24:14.367Z	ERROR	Unable to create SQL database.	{"error": "pq: permission denied to create database", "logging-call-at": "handler.go:97"}
2023/05/17 18:24:14 Loading config; env=docker,zone=,configDir=config
2023/05/17 18:24:14 Loading config files=[config/docker.yaml]
{"level":"info","ts":"2023-05-17T18:24:14.680Z","msg":"Updated dynamic config","logging-call-at":"file_based_client.go:143"}
{"level":"info","ts":"2023-05-17T18:24:14.680Z","msg":"Starting server for services","value":["history","matching","frontend","worker"],"logging-call-at":"server.go:123"}
Unable to start server. Error: sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: pq: relation "schema_version" does not exist
k
A message from kapa.ai
New message text here
r
still getting Unable to start server. Error: sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: pq: relation "schema_version" does not exist
q
The user that will create and grant privilege to Airbyte user must be a root user. Secondly, this root user will create publication and slot. The new created airbyte user must be add to RDS_replication group on RDS
🙏 1