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.
- Connect to the PostgreSQL instance with the master user:
psql -h <RDS Postgress URL> -U postgres_user -d postgres
- Create the Databand DB and User:
create database databand;
create user databand with encrypted password 'databand';
grant all privileges on database databand to databand;
- Connect to the Databand db with the master user:
psql -h <RDS Postgress url> -U postgres_user -d databand
- Create the
uuid-ossp
extension:
CREATE EXTENSION "uuid-ossp" SCHEMA pg_catalog;
- Your
sql_alchemy_conn
ispostgresql+psycopg2://username:[email protected]:5432/databand
MYSQL
Please, make sure you have this property configured
set explicit_defaults_for_timestamp to 1
Updated about 1 year ago