Importing issue in importing sample postgres data in postgres database which is available on dhis2.org

Support - Assistance technique
1

Hi,

when i am trying to import postgres sample database available on https://www.dhis2.org/downloads , it seems after some times like given below on command line. Can somebody helps me in this regard ?

psql:D:/Sorce/demo.sql:4467876: invalid command \N

psql:D:/Sorce/demo.sql:4467877: invalid command \N

psql:D:/Sorce/demo.sql:4467878: invalid command \N

psql:D:/Sorce/demo.sql:4467879: invalid command \N

psql:D:/Sorce/demo.sql:4467880: invalid command \N

psql:D:/Sorce/demo.sql:4467881: invalid command \N

psql:D:/Sorce/demo.sql:4467882: invalid command \N

psql:D:/Sorce/demo.sql:4467883: invalid command \N

psql:D:/Sorce/demo.sql:4467884: invalid command \N

psql:D:/Sorce/demo.sql:4467885: invalid command \N

psql:D:/Sorce/demo.sql:4467886: invalid command \N

psql:D:/Sorce/demo.sql:4467887: invalid command \N

psql:D:/Sorce/demo.sql:4467888: invalid command \N

psql:D:/Sorce/demo.sql:4467889: invalid command \N

psql:D:/Sorce/demo.sql:4467890: invalid command \N

psql:D:/Sorce/demo.sql:4467891: invalid command \N

psql:D:/Sorce/demo.sql:4467892: invalid command \N

psql:D:/Sorce/demo.sql:4467893: invalid command \N

psql:D:/Sorce/demo.sql:4467894: invalid command \N

psql:D:/Sorce/demo.sql:4467895: invalid command \N

psql:D:/Sorce/demo.sql:4467896: invalid command \N

psql:D:/Sorce/demo.sql:4467897: invalid command \N

psql:D:/Sorce/demo.sql:4467898: invalid command \N

psql:D:/Sorce/demo.sql:4467899: invalid command \N

psql:D:/Sorce/demo.sql:4467900: invalid command \N

psql:D:/Sorce/demo.sql:4467901: invalid command \N

psql:D:/Sorce/demo.sql:4467902: invalid command \N

···

Thanks and Regards

Brajesh Murari

1 Like
2

Hi Brajesh Murari,
I experienced the similar issues. It seems this relevant with postgres version. I tried to import sample postgres database dump in my postgres server. My server version was postgres 11 it was giving exactly the same error you mentioned but later I have found dump was taken from postgres version 10 and downgraded my database server then it works fine for me.