Cloudera Docs

Configure Metadata Stores in Postgres

If you have already installed MySQL and configured the metadata store using MySQL, you do not need to configure additional metadata stores in Postgres.

  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;