[GeoNetwork-devel] [GeoNetwork-users] PostGIS configuration in Geonetwork 3

Hi,

I don’t really understand your issue.
postgres/postgis is the same data connexion. The 2 options provided by geonetwork are

  • postgres/postgis in direct connexion

  • postgres/postgis through JNDI

If you configured the first one then it’s ok, you configured your postgres/postgis DB with geonetwork.

You can add postgis extension if you want to, but it’s not needed for geonetwork. You could however use a postgis DB for your index, but it’s a different issue there.

The second one is through JDNI, it means you need to create a JNDI connexion resource somewhere in your Tomcat config to use it with geonetwork.

You should’nt need to touch neither jndi-postgres-postgis.xml nor postgres.xml files.

···

On Tue, May 26, 2015 at 5:57 PM, Òscar Chic <ochic@anonymised.com> wrote:

Do you mena this file:
jndi-postgres-postgis.xml ?

It’s is needed to configure to connect to Postgres/postGIS DB?


<?xml version="1.0" encoding="UTF-8"?>

<beans default-lazy-init=“true”
xmlns=“http://www.springframework.org/schema/beans” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
">

---

Òscar

El 26/5/15 a les 17:05, Florent Gravin ha escrit:

Well, it’s JNDI, did you configure one ?

-- 
_______________________________________________________________________

Oscar Chic
Sotsdirector Tècnic
Institut de Ciències del Mar (ICM-CSIC)    Tel:   +34 932309529
Pg. Marítim de la Barceloneta, 37-49       Fax:   +34 932309555
08003 Barcelona, Spain                     email: [ochic@anonymised.com](mailto:ochic@anonymised.com..809...)
_______________________________________________________________________

On Tue, May 26, 2015 at 5:02 PM, Òscar Chic <ochic@anonymised.com> wrote:

Thanks Florent!. It works.
But when I try to tune to postgresql_postGIS it doesn’t

Òscar

El 26/5/15 a les 14:53, Florent Gravin ha escrit:

Hi, i think you just need one database.
Either postgres (with postgis or not), either JNDI.
Try to use just the postgres config, remove your DB, create a new one, and see if the serveur startup fills the new DB with correct tables.
You’re then free to enable postgis extension in that base if you want to.

-- 
_______________________________________________________________________

Oscar Chic
Sotsdirector Tècnic
Institut de Ciències del Mar (ICM-CSIC)    Tel:   +34 932309529
Pg. Marítim de la Barceloneta, 37-49       Fax:   +34 932309555
08003 Barcelona, Spain                     email: [ochic@anonymised.com](mailto:ochic@anonymised.com..809...)
_______________________________________________________________________

Florent Gravin
Camptocamp - Chambéry
0479444492

On Tue, May 26, 2015 at 2:36 PM, Òscar Chic <ochic@anonymised.com> wrote:

Hi,

I’m trying to configure a new Geonetwork 3 installed as a war file to
connect to postGIS

Before that I have a Geonetwork 2.10 running with this configuration
perfect:


main-db jeeves.resources.dbms.ApacheDBCPool geonetwork xxxxxx org.postgis.DriverWrapper

Then I update jdbc.properties (user, pass, host, db)

After that I create a clean PostGIS database with that parameters

Then reboot geonetwork but a lot of SEVERE errors related to datasource

Anybody knows the configuration of a GN 3 with PostGIS?

Thanks a lot
Òscar


Oscar Chic
Sotsdirector Tècnic
Institut de Ciències del Mar (ICM-CSIC) Tel: +34 932309529
Pg. Marítim de la Barceloneta, 37-49 Fax: +34 932309555
08003 Barcelona, Spain email: ochic@anonymised.com



One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y


GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Florent Gravin
Camptocamp - Chambéry
0479444492

Florent Gravin
Camptocamp - Chambéry
0479444492

Hi,

I was struggling with connecting with PostGIS, and I found this thread very
helpful.

Just a follow up question, now I am able to connect GNK with Postgre, but I
want to use PostGIS for my index since I have a large volume of datasets. I
have already create postgis extension in postgre DB, but I don't think
PostGIS is being used (C:\Program
Files\geonetwork\web\geonetwork\WEB-INF\data\index), because the spatial
index file keep getting larger as I add data. Could you help me out with
this?

Thanks in advance,
Cody

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Re-GeoNetwork-users-PostGIS-configuration-in-Geonetwork-3-tp5207644p5208504.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.