Externalizing the Relational Database

If desired, you can bring your own Postgres instance to use as your Arthur’s relational database. Follow the steps on this page to prepare your Postgres instance.

First, deploy your Postgres instance in your desired environment with appropriate ingress firewall configuration.

Create databases for the Arthur platform.

CREATE DATABASE alert_service;
CREATE DATABASE dataset_service;
CREATE DATABASE metric_service;
CREATE DATABASE arthurai;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

-- for stand alone instance
create user arthurai password 'SuperSecret';
alter user arthurai with SUPERUSER;

-- for RDS instance
CREATE ROLE arthurai WITH PASSWORD 'SuperSecret' CREATEDB CREATEROLE LOGIN;
GRANT rds_superuser TO arthurai;

If you have been using the embedded database and you wish to switch to using an external Postgres, backup the embedded database and restore it to the new external Postgres with pg_dump and pg_restore.