Restore Demo Data base is not working

Implementation - Implémentation
1

Hi!

I´m try to restore a demo data base on ubuntu 22.4, tomcat9, java 17, dhis2-db-sierra-leone.sql

but it is not working.
the message.

psql:dhis2-db-sierra-leone.sql:5747759: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747760: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747761: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747762: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747763: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747764: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747765: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747766: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747767: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747768: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747769: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747770: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747771: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747772: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747773: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747774: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747775: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747776: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747777: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747778: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747779: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747780: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747781: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747782: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747783: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747784: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747785: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747786: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747787: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747788: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747789: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747790: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747791: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747792: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747793: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747794: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747795: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747796: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747797: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747798: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747799: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747800: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747801: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747802: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747803: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747804: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747805: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747806: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747807: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747808: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747809: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747810: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747811: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747812: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747813: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747814: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747815: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747816: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747817: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747818: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747819: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747820: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747821: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747822: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747823: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747824: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747825: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747826: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747827: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747828: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747829: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747830: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747831: error: invalid command \N
psql:dhis2-db-sierra-leone.sql:5747832: error: invalid command \N

2

Hi

Where did you get the demo database from? Did you download it directly from the dhis2 website?

What method are you using to deploy the instance and how are you setting up the database?

Thanks!

3

I get from DHIS 2 Databases, I´m restoring on fisic server. Without LXD container.

4

Hello @witney,

Please check if you have the required Postgres extension installed, especially PostGIS, which was the issue when I got a similar error

Regards.

1 Like
5

I have.

6

Another way of figuring out the issue is looking at a few lines prior to this error occurring when the restoration is happening, I believe there may have been an error that occurred before it started printing out this error.

7

The restore has happend but, there is nothing on DHIS2. Now i have not the script becouse it paste time.