Thanks to @jomutsani and @Ameen. The issue was with the DB dump obtained which had non standard geometry type. I had to change the PostGIS path initially to get it restored which I guess affected DHIS2 application which did not see PostGIS extension installed.
2 Likes