dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

I just made a quick comment on that issue.

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@xxxxxxxxx> wrote:
> Hi,
> This is a confirmed issue, you can track the progress here:
> https://jira.dhis2.org/browse/DHIS2-4464
>
> Best regards,
> Lukas Wijgaart van Dijk
>
> 10. sep. 2018 kl. 16.11 skrev 林晓东 <lin_xd@xxxxxxx>:
>
> 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
>
>
>
> --
> 此致
>
>    林晓东
>
> 莫愁前路无知己，天下谁人不识君。
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>