Importing sample data to DHIS2 instance

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Shivaraj_mahato
I found a similar discussion in another post and would like to quote what lead to the solution:

@jaime.bosque

If I remember correctly that \N is related to the postgis extension not being installed.

@jaime.bosque

sudo -u postgres psql -c "create extension postgis;" dhis2

Taken from: Home - DHIS2 Documentation

@Ulanbek

I installed it by following the instructions. And I am using Windows 10pro, installed locally. Main intention is to understand how it works and to learn how to create registry for the local community.
I think after I will seek the answer how to complete those tasks

@Ulanbek

Solved:
0. Stopped everything

1. removed dhis2 database.
2. Recrecreated new database
3. Restored all data
4. Restarted all services

Thanks community🙋‍♂️

I really recommend you remove the dhis2 database you tried to install and then try to recreate because trying over and over before removing will probably fail. Hopefully the steps shared by Ulanbek will solve the issue.

And if that doesn’t work, please share versions used in your environment specifically Postgresql version?

Thank you!