Home

Welcome to the ayb wiki!

Unorganized for now, but will become a handbook eventually

Setting up PostgreSQL

In ayb.toml, set database_url = "postgresql://postgres_user:test@localhost:5432/test_db"

This database_url assumes you've created a postgres_user with password test and a test_db that this user can access. Here are the commands to make that possible, assuming you already have PostgreSQL installed (say, with sudo apt-get install postgresql on Debian-based systems):

$ sudo -u postgres createuser -P postgres_user  # Enter password `test`
$ sudo -u postgres psql -c "alter user postgres_user createdb;"
$ sudo -u postgres psql -c "GRANT CREATE ON DATABASE test_db to postgres_user;"
# Edit /etc/postgresql/14/main/pg_hba.conf to have an entry like:
# local   all             all                                     scram-sha-256
$ service postgresql restart
$ createdb -U postgres_user -W test_db