- install postgresql[version]-server
- install postgresql[version]-contrib (to get pg_trgm)
- sudo -u www composer require 'drupal/pgsql_fallback:^2.0'
- turn on logging in postgres.conf
- start postgres
- su postgres
- psql
- create user
- create extension pg_trgm;
- start site and install Drupal