Installation

The Land Terrier Database was created with the following software versions. It should work on newer versions and it might work on older versions…

PostgreSQL 16.4, compiled by Visual C++ build 1940, 64-bit
POSTGIS 3.4.2
QGIS 3.34.8-Prizren

Download the creation sql script:

It’s easiest to create the database using the psql.exe. Which can be found here:

C:\Program Files\PostgreSQL\16\bin

The sql script will create a new database called land_terrier so it doesn’t matter which database the script is executed in. I have used the default postgres database in this example:

psql -U postgres -d postgres -f "\db\land_terrier.sql" 

Configuration

The QGIS project is configured to connect to a service called land-terrier. A .pg_service.conf service file needs to be created with the connection parameters to your PostgreSQL server and it needs to be available on the QGIS path.

For instructions, follow this guide.

Once configured, you can connect to the database like this and the QGIS project should work correctly: