Configuring Postgres for Streaming Components

If you are installing Schema Registry or Streams Messaging Manager (SMM), you must configure the database to store metadata.

After you install Postgres and download the JDBC drivers, you must configure the database to store:
  • Schema Registry data such as the schemas and their metadata, all the versions and branches.
  • SMM data such as Kafka metadata, stores metrics, and alert definitions.
.
  1. Log in to Postgres:
    
    sudo su postgres
    psql
    
  2. For the Schema Registry metadata store, create a database called registry with the password registry:
    
    create database registry;
    CREATE USER registry WITH PASSWORD 'registry';
    GRANT ALL PRIVILEGES ON DATABASE "registry" to registry;
    
  3. For the SMM metadata store, create a database called streamsmsgmgr with the password streamsmsgmgr:
    
    create database streamsmsgmgr;
    CREATE USER streamsmsgmgr WITH PASSWORD 'streamsmsgmgr';
    GRANT ALL PRIVILEGES ON DATABASE "streamsmsgmgr" to streamsmsgmgr;