Hi, >From pgadmin4 or CLI interface run the following command in your DB, CREATE EXTENSION postgis;
Then restart your database and tomcat. Hope this would help you. Thanks, Sohel Sarder On Wed, Dec 5, 2018 at 1:15 PM 林晓东 <lin...@126.com> wrote: > hi,all > > I have created the postgis extension, stil error : > > * WARN 2018-12-05 14:56:52,604 A C3P0Registry mbean is already > registered. This probably means that an application using c3p0 was > undeployed, but not all PooledDataSources were closed prior to > undeployment. This may lead to resource leaks over time. Please take care > to close all PooledDataSources. (Slf4jMLog.java [localhost-startStop-2]) > * INFO 2018-12-05 14:56:54,275 Hibernate configuration loaded: dialect: > 'org.hisp.dhis.hibernate.dialect.DhisPostgresDialect', region factory: > 'org.hibernate.cache.ehcache.EhCacheRegionFactory', connection pool max > size: 80 (DefaultHibernateConfigurationProvider.java > [localhost-startStop-2]) > * ERROR 2018-12-05 14:56:54,730 Postgis extension is not installed. > Execute "CREATE EXTENSION postgis;" as a superuser and start the > application again. (HibernateDatabaseInfoProvider.java > [localhost-startStop-2]) > * WARN 2018-12-05 14:56:54,731 Exception encountered during context > initialization - cancelling refresh attempt: > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'databaseInfoProvider' defined in URL > [jar:file:/home/wcrmyy2017/tomcat534-1/webapps/dhis/WEB-INF/lib/dhis-support-system-2.32-SNAPSHOT.jar!/META-INF/dhis/beans.xml]: > Invocation of init method failed; nested exception is > java.lang.IllegalStateException: Postgis extension is not installed. > Execute "CREATE EXTENSION postgis;" as a superuser and start the > application again. (AbstractApplicationContext.java [localhost-startStop-2]) > * ERROR 2018-12-05 14:56:54,741 Context initialization failed > (ContextLoader.java [localhost-startStop-2]) > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'databaseInfoProvider' defined in URL > [jar:file:/home/wcrmyy2017/tomcat534-1/webapps/dhis/WEB-INF/lib/dhis-support-system-2.32-SNAPSHOT.jar!/META-INF/dhis/beans.xml]: > Invocation of init method failed; nested exception is > java.lang.IllegalStateException: Postgis extension is not installed. > Execute "CREATE EXTENSION postgis;" as a superuser and start the > application again. > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1631) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761) > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) > at > org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:443) > at > org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:325) > > > Thanks. > -- > 此致 > > 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 >
_______________________________________________ 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