Write-up of how I created LPIS database on a local PostgreSQL 14 cluster

In early February 2026 I manage to install PostgreSQL 14 (this was the highest version I have successfully installed on that machine) on my Ubuntu 20.04 system that had already entered EOL since December 2025. You may read the full transcript here.

Following that, I set out to create the LPIS database locally. So first I created a user lpis and gave him superuser privilleges (note: this is not part of the normative instructions handed to us by the previous team).

sudo -u postgres psql -c "CREATE USER lpis WITH PASSWORD 'xxxx';"
sudo -u postgres psql -c "ALTER USER lpis WITH SUPERUSER"