Aidbox
Search…
Run Aidbox with non-privileged postgresql role
This quickstart guide explains how to run Aidbox using non-privileged postgresql role.

docker compose up aidbox-db -d

docker compose exec aidbox-db psql postgres

CREATE USER aidbox WITH CREATEDB ENCRYPTED PASSWORD 'aidboxpass';

Modify .env file by replacing following vales. If you're using existing database 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

Aidbox can install most of the required extensions (by having CREATE privilege on database), but some require superuser. You can install them manually by executing folowing commands in psql:
CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION jsquery;
CREATE EXTENSION jsonknife;

Copy link
Edit on GitHub
On this page
Prerequisites
Run aidboxdb image
Execute psql inside container
Create role
Setup Aidbox to use new user
Create extensions as superuser
Next steps