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 do I go about importing sql data?
thanks...
Webmasters Stack Exchange is a question and answer site for webmasters. It only takes a minute to sign up.
Sign up to join this communityAssuming this is Windows only. Its a 4 step process:
Restore the demo database using psql. You may need to create a database and its user in pgAdmin, or CLI. use google here.
C:\...\PostgreSQL\bin
. You can use Windows search.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.
Please check your database server version with the version of dump you are going to import. Your dumped database server version mentioned above of the sample database dumped file
Example:
I have found the similar issues with Postgres 11 later downgrade of my database server to 10 worked fine for me.