Catalog installation

Download new version

• Catalog are created on every commit by http://ci.titellus.net/job/GeoNetwork-eea/
• Download WAR files from http://files.titellus.net/geonetwork/eea/

export CATALOG_DIR=/home/paul/deliveries
cd $CATALOG_DIR

todaydate=$(date +%Y%m%d)
mkdir $todaydate
cd $todaydate

wget http://files.titellus.net/geonetwork/eea/eea-catalogues.tar.gz
tar zxf eea-catalogues.tar.gz

Backup databases

dblist="geonetwork_sdi geonetwork_sdi_public geonetwork_sdi_editor"
dbserver=iguana.eea.europa.eu
dbuser=geonetwork
for db in $dblist; do
  pg_dump -h $dbserver -p 5432 -U $dbuser --role $dbuser -f $db_$todaydate.tar --format tar --blobs --encoding UTF8 -v --inserts  $db
done;

or in PgAdmin

• connect to Iguana
• Backup database (right click on database name)
• Format: Tar
• Encoding: UTF-8
• Rolename: geonetwork
• File: in .../EEA-SDI/catalogue_backup/xyz.tar

Migrate database if needed

Note: do not use postgres, use the owner (ie. geonetwork)

wget https://github.com/eea/geonetwork-eea/blob/eea-develop/web/src/main/webapp/WEB-INF/classes/setup/sql-eea/db-migrate-201604.sql
for db in $dblist; do
  psql -h $dbserver -p 5432 -U $dbuser -f db-migrate-201604.sql $db
done;

or in PgAdmin

• connect to Iguana
• connect to target database
• open SQL windows and use it to apply the changes.

Stop tomcat

service tomcat-catalogues stop

Update WAR

rm $CATALINA_HOME/webapps/*
cp $CATALOG_DIR/$todaydate/target/*.war $CATALINA_HOME/webapps/.

Start tomcat

service tomcat-catalogues start