The workaround is to to create the postgis extension manually in the
database and then restart the application server (tomcat), eg on
ubuntu:
echo "create extension if not exists postgis;" | sudo -u postgres psql dhis
···
On 10 September 2018 at 14:25, Lukas Wijgaart-van Dijk <lukasewvd@gmail.com> wrote:
Hi,
This is a confirmed issue, you can track the progress here: [DHIS2-4464] - Jira
Best regards,
Lukas Wijgaart van Dijk
10. sep. 2018 kl. 16.11 skrev 林晓东 <lin_xd@126.com>:
hi,all
when I install a new fresh dhis2 ver 2.30, startup error:
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"programstageinstance" not exist
位置:22
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at
org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:461)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
... 159 more