← Back to team overview

dhis2-users team mailing list archive

Trouble Importing Database into DHIS2-Live

 

Hi Everyone,

I am having some trouble importing a database into a local DHIS2-Live instance in Windows 7. When I check pgadmin it looks like it's been imported correctly. I have tried both restoring/importing the database using
psql -U dhis -f databasename.dump -d dhis2 to recover and
psql -U dbuser dbname < filename.sql to import

However when I check the dhis instance it is just a blank instance with none of the data/metadata present. I also have created a hibernate.propties file containing the following:
hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:dhis2

hibernate.connection.username = dhis
hibernate.connection.password = dhis
hibernate.hbm2ddl.auto = update

Just wondering where I might be going wrong here? Thanks

Nick


[cid:image001.png@01CF7A81.BAF015E0]


[cid:image002.png@01CF7A81.BAF015E0]




====================================================
This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and  GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific.  However, the recipient is advised to scan this e-mail and any attached files for viruses.

Disclaimer:

This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law.

If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.

PNG image

PNG image


Follow ups