OpenMetadata with Azure Postgresql

[sreejith-geodis]

I installed openmetadata 1.6.3 version using docker compose method. I would like to use Azure Postgresql instead of the docker postgresql. I tried to setup this but the table is not getting created and the openmetadata-server container is not getting started due to that.
Could you please suggest some docs or steps to configure?

[Prajwal214]

To configure OpenMetadata to use Azure PostgreSQL instead of the default Docker PostgreSQL, you need to ensure that the database schema is properly initialized. Here are the steps you can follow:

1. Database Connection Configuration: Update your environment variables to point to your Azure PostgreSQL instance. Ensure that the connection details (host, port, database name, username, password) are correctly specified.

https://docs.open-metadata.org/latest/deployment/docker#3.-update-environment-variables-required-for-openmetadata-dependencies

2. Run Database Migrations: Since the tables are not being created automatically, you need to run the database migrations manually. Use the following commands to check and apply migrations:

• To create the necessary tables:

     ./bootstrap/openmetadata-ops.sh drop-create

3. Permissions and Extensions: Ensure that the database user has sufficient permissions to create tables and that all required PostgreSQL extensions (like pgcrypto) are enabled.