Sample database loading error into postgres 11

Sorry, maybe I should have said “created”.

Are you sure you did this:
sudo -u postgres psql -c "create extension postgis;" dhis2

Taken from: Home - DHIS2 Documentation