Run Aidbox on managed PostgreSQL

This quickstart guide explains how to run Aidbox on managed PostgreSQL instance.

Aurora PostgreSQL

Prerequisites

• aws CLI

• psql

Connect to db cluster

Follow AWS documentation to connect to cluster using aws-cli and psql

Create role

Execute following sql in psql

CREATE USER aidbox WITH CREATEDB ENCRYPTED PASSWORD 'aidboxpass';

Azure Database for PostgreSQL flexible server

Prerequisites

• azure CLI

Create Role

Follow Azure Documentation and execute following SQL to create role:

CREATE USER aidbox WITH CREATEDB ENCRYPTED PASSWORD 'aidboxpass';

Setup Aidbox to use new user

You may encounter permission denied error when creating extensions. Just connect to PostgreSQL database using user that can create extension (usually admin user created with a server) and create failed extension manually.

Setup following environment variables. If you're using existing PGDATABASE make sure aidbox role has CREATE privilege on it. Otherwise Aidbox won't be able to install most of the extensions.

PGUSER=aidbox
PGPASSWORD=aidboxpass
PGDATABASE=aidbox