: Import sample data into DHIS2 Live I've set up DHIS2 Live on my computer. I would like to import the sample data that is supplied along with DHIS2 Live, it's a file called "default.sql". How

@Fox8124981

Assuming this is Windows only. Its a 4 step process:


Download the demo database from the dhis download site. It's about 188 MB.
Unzip it to get a 2.4GB sql file!
Restore the demo database using psql. You may need to create a database and its user in pgAdmin, or CLI. use google here.


Find psql somewhere in C:...PostgreSQLbin. You can use Windows search.
Open CMD here by holding shift then right-click on a whitespace.
Run psql -d dbname -U username -f demo.sql

After the database is setup. Configure the hibernate.properties or
create a new dhis.conf file under the /conf folder then paste
the orginal dhis.conf contents as in the implementation guide,
ensure your password and username is as in step 3.


You may also refer to this article from the dhis-users group on launchpad.

Vote Up Vote Down