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

Last modified 5mo ago