Hi,all,
I have git clone v2.30 from git hub, and build sucessful. deploy to tomcat with empty db.when startup got :
Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” does not exist.
and then startup over ,dhis2 can work, but no response when clicking the import button within importing/export app’s importing metadata
…
–
此致
easy
莫愁前路无知己，天下谁人不识君。
Hi 此致,
Seems like the database tables have not been created yet during setup or there is some error in the backend API.
On Tue, 4 Sep 2018 at 02:13, 林晓东 lin_xd@126.com wrote:
Hi,all,
I have git clone v2.30 from git hub, and build sucessful. deploy to tomcat with empty db.when startup got :
Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” does not exist.
and then startup over ,dhis2 can work, but no response when clicking the import button within importing/export app’s importing metadata
…
–
此致easy
莫愁前路无知己，天下谁人不识君。
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Hi,
Yes, dhis2 could not properly start - check if you have installed the Postgis extension -
in the database, enter:
\dx
and you need to see postgis as an output, otherwise you need to install the extension.
Regards,
David
林晓东 lin_xd@126.com schrieb am Di., 4. Sep. 2018, 02:13:
Hi,all,
I have git clone v2.30 from git hub, and build sucessful. deploy to tomcat with empty db.when startup got :
Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” does not exist.
and then startup over ,dhis2 can work, but no response when clicking the import button within importing/export app’s importing metadata
…
–
此致easy
莫愁前路无知己，天下谁人不识君。
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
I have installed postgis extension using apt install postgresql-10-postgis-2.4.
but in psql, there is only:
pgpool_recovery | 1.1 | public | recovery functions for pgpool-II for V3.4 or later
pgpool_regclass | 1.0 | public | replacement for regclass
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
but in pgadmin ,there is showing postgis extension.
why?
–
此致
林晓东
莫愁前路无知己，天下谁人不识君。
在 2018-09-04 15:18:05，“David Huser” dhuser@baosystems.com 写道：
Hi,
Yes, dhis2 could not properly start - check if you have installed the Postgis extension -
in the database, enter:
\dx
and you need to see postgis as an output, otherwise you need to install the extension.
Regards,
David
林晓东 lin_xd@126.com schrieb am Di., 4. Sep. 2018, 02:13:
Hi,all,
I have git clone v2.30 from git hub, and build sucessful. deploy to tomcat with empty db.when startup got :
Caused by: org.postgresql.util.PSQLException: ERROR: relation “programstageinstance” does not exist.
and then startup over ,dhis2 can work, but no response when clicking the import button within importing/export app’s importing metadata
…
–
此致easy
莫愁前路无知己，天下谁人不识君。
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
Sounds like it an issue with the user you are connecting to your database with. Are you using multiple postgres users, or just one superuser? did you create the database with the owner flag set to your dhis2 db user?
–
Morten Olav Hansen
Senior Engineer, DHIS 2
Team Integration Lead
University of Oslo
use postgres user.
–
Morten Olav Hansen
Senior Engineer, DHIS 2
Team Integration Lead
University of Oslo