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)
- 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