Prerequisites

Postgresql user must have SUPERUSER role to apply the add_postgis migration. This role can be removed after applying the migration. Otherwise you can login as a superuser in pgsql and run CREATE EXTENSION postgis;, the add_postgis migration will automatically be skipped (source)

• NodeJS 18
• Setup a user and a database in postgresql (ubuntu doc)
• Install PostGIS (guides)

Install

• Copy/paste/rename .env.example to .env
• Configure the postgresql url in .env with the appropriate user, password and dbname
• pnpm i (libpg-query may need gcc, g++, make and cmake)
• pnpm db:seed

Run with pnpm dev