Sunday, May 24, 2009

Checked-out branch and installed mapbender

Checked out the GSoC branch for the CSW development, and installed it under Postgres. The installation is a bit tricky, as the version numbers of the SQL files still are 2.5 etc - which doesn't help when installing from the trunk, a.k.a latest version. A look at the installation script helps determine the order. Thus under postgres, the installation would be as such, where $dbname should be replaced with the name of your database that you create:

Assuming UTF8

createdb -E UTF-8 $dbname

Move to the folder where mapbender is installed/extracted, and do the following
psql -f pgsql/pgsql_schema_2.5.sql $dbname
psql -f pgsql/UTF-8/pgsql_data_2.5.sql $dbname
psql -f pgsql/pgsql_serial_set_sequences_2.5.sql $dbname
psql -f pgsql/UTF-8/update/update_2.5_to_2.5.1rc1_pgsql_UTF-8.sql $dbname
psql -f pgsql/UTF-8/update/update_2.5.1rc1_to_2.5.1_pgsql_UTF-8.sql $dbname
psql -f pgsql/UTF-8/update/update_2.5.1_to_2.6rc1_pgsql_UTF-8.sql $dbname

once this is done, you can install the postgis data into the database, by going to the folder where postgis is installed, and,
psql -f lwpostgis.sql -d $dbname
psql -f spatial_ref_sys.sql -d $dbname

No comments:

Post a Comment