External DB for Databand MetaData

How to create and set up the RDS PostgreSQL for using with Databand.

We highly recommend using an external managed SQL engine for your Databand production deployment. Follow these steps to create and set up the RDS PostgreSQL.

  1. Connect to the PostgreSQL instance with the master user:
psql -h <RDS Postgress URL> -U postgres_user -d postgres
  1. Create the Databand db user:
create database databand;
create user databand with encrypted password 'databand';
grant all privileges on database databand to databand;
  1. Connect to the Databand db with the master user:
psql -h <RDS Postgress url> -U postgres_user -d databand
  1. Create the uuid-ossp extension:
CREATE EXTENSION "uuid-ossp" SCHEMA pg_catalog;
  1. Find your sql_alchemy_conn in postgresql+psycopg2://username:[email protected]:5432/databand

MYSQL

Please, make sure you have this property configured
set explicit_defaults_for_timestamp to 1


Did this page help you?