Dear all,
We have made our first attemp to install Geonetwork 2.6.3 for a production environment, following the "Mastering Advanced GeoNetwork" documentation (http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf). Everything is fine when creating tables and loading initial data into a non-spatial PostgreSQL database using create-db-postgres.sql and data-db-postgres.sql. However, when trying to do the same with a PostGIS database we got some problems. The script create-db-postgis.sql works fine. However, when loading initial data with data-db-postgres.sql (also tried data-db-postgis.sql), we got some insert errors. It seems that some tables created with the postgis script does not have the righ number of columns (eg. table 'languages' appears with 2 columns instead of 3), which is reponsible of the insert errors.
Could someone provide some insights on this issue?
Thanks in advance,
David
--
David March Morlà
PhD candidate
Fisheries-GIS Spatial Ecologist
Email: david@anonymised.com
IMEDEA
Instituto Mediterraneo de Estudios Avanzados (UIB-CSIC)
C/Miquel Marquès 21, 07190 Esporles, Balearic Islands. Spain
www.imedea.uib.es
SOCIB
Balearic Islands Coastal Observing and Forecasting System
Strategic Issues and Applications for Society (SIAS Division)
Parc Bit, Naorte, Bloc A 2ºp. pta. 3, 07121 Palma de Mallorca. Spain
Tel: +034 971 43 99 98
www.socib.es
Hi Mark,
Thanks a lot! It has worked!
Best regards,
David
El 14/03/2011 10:36, Maik Wannink escribió:
Am 14.03.2011 10:15, schrieb David March Morla:
Dear all,
We have made our first attemp to install Geonetwork 2.6.3 for a
production environment, following the "Mastering Advanced GeoNetwork"
documentation
(http://geonetwork-opensource.org/_static/foss4g2010/FOSS4G_Mastering_Advanced_GeoNetwork.pdf).
Everything is fine when creating tables and loading initial data into a
non-spatial PostgreSQL database using create-db-postgres.sql and
data-db-postgres.sql. However, when trying to do the same with a PostGIS
database we got some problems. The script create-db-postgis.sql works
fine. However, when loading initial data with data-db-postgres.sql (also
tried data-db-postgis.sql), we got some insert errors. It seems that
some tables created with the postgis script does not have the righ
number of columns (eg. table 'languages' appears with 2 columns instead
of 3), which is reponsible of the insert errors.
Could someone provide some insights on this issue?
Thanks in advance,
David
Hi David,
I had the same problem like you. There is a bug in the script. You can download from here:
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/branches/2.6.x/web/src/main/webapp/WEB-INF/classes/setup/sql/create/create-db-postgis.sql
It works fine.
Have a nice day
Regards Maik
--
David March Morlà
PhD candidate
Fisheries-GIS Spatial Ecologist
Email: david@anonymised.com
IMEDEA
Instituto Mediterraneo de Estudios Avanzados (UIB-CSIC)
C/Miquel Marquès 21, 07190 Esporles, Balearic Islands. Spain
www.imedea.uib.es
SOCIB
Balearic Islands Coastal Observing and Forecasting System
Strategic Issues and Applications for Society (SIAS Division)
Parc Bit, Naorte, Bloc A 2ºp. pta. 3, 07121 Palma de Mallorca. Spain
Tel: +034 971 43 99 98
www.socib.es