Skip to content
Stable

This component is complete and can be used. The interfaces will be supported until the function is removed from the project via the deprecation process. There will be ongoing extensions to this function, but it will be done to ensure backward compatibility as far as possible. If there is a need to break backward compatibility, this will be discussed and reviewed in the community, with a documented timeline.

PostgreSQL Repository Connector

Connector summary

The PostgreSQL OMRS Repository Connector provides a repository implementation that stores metadata in a PostgreSQL Database. Each Open Metadata Repository uses the same table structure within its own Database Schema. This database schema is managed by a single instance of the PostgreSQL Repository Connector.

Access to the PostgreSQL Database Schema is provided by the JDBC Resource Connector. This connector manages the SQL Queries, connection management and use of the secrets store for security connections.

The diagram below shows the tables used in the PostgreSQL Database Schema.

Postgres Schema

Debugging

Logging levels can be set up in the application.properties file. To log each SQL command issues, add the following:

logging.level.org.odpi.openmetadata.adapters.connectors.resource.jdbc=DEBUG

To log how queries are built up from the values supplied on the repository API, add the following:

logging.level.org.odpi.openmetadata.adapters.repositoryservices.postgres.repositoryconnector.database=DEBUG

Raise an issue or comment below