Run Aidbox on managed PostgreSQL
This quickstart guide explains how to run Aidbox on managed PostgreSQL instance.
- aws CLI
- psql
Execute following sql in psql
CREATE USER aidbox WITH CREATEDB ENCRYPTED PASSWORD 'aidboxpass';
- azure CLI
CREATE USER aidbox WITH CREATEDB ENCRYPTED PASSWORD 'aidboxpass';
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