Upgrading PostGIS
I am upgrading a PostgreSQL test server from 8.3 to 9.0, as well as PostGIS from 1.3 to 1.5. At one stage I kept getting the following error while trying to install the PostGIS database.
$ psql mydb -f postgis.sql SET BEGIN psql:postgis.sql:59: ERROR: could not load library "/usr/pgsql-9.0/lib/postgis-1.5.so": /usr/pgsql-9.0/lib/postgis-1.5.so: undefined symbol: GEOSHausdorffDistance psql:postgis.sql:65: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:postgis.sql:70: ERROR: current transaction is aborted, commands ignored until end of transaction block -snip-
After a lot of head banging (the brick wall kind, not the heavy metal kind), I figured out I still had the old version of the GEOS library:
# yum list geos Loaded plugins: rhnplugin, security Excluding Packages from rhel5s-x86_64 - Base (RPData) Finished Excluding Packages from rhel5s-x86_64 - Updates (RPData) Finished Installed Packages geos.x86_64 2.2.3-2.rhel5 installed Available Packages geos.x86_64 3.2.2-1.rhel5 postgresql9
A quick upgrade of GEOS to v3 and all was well.
$ psql mydb -f postgis.sql SET BEGIN CREATE FUNCTION CREATE FUNCTION -snip-
Article Series
Kick Ass PostgreSQL Books
Recent Posts
Kick Ass Oracle Books
Popular Posts
- Top 10 Missing PostgreSQL Features 574 view(s)
- PostgreSQL vs Oracle Differences #4 - Shared Memory Usage 383 view(s)
- pg_restore: [archiver] unsupported version (1.12) in file header 349 view(s)
- PostgreSQL vs Oracle Differences #3 - System Resources 305 view(s)
- PostgreSQL - Dropping a template database 253 view(s)
- PostgreSQL Database Capacity Planning 1 - Disk Space 201 view(s)
- Windows PostgreSQL and the case of the vanishing libint.dll 185 view(s)
- PostgreSQL backup crashed - PANIC! 147 view(s)
Archives
- September 2011 (1)
- August 2011 (2)
- July 2011 (3)
- June 2011 (10)
- May 2011 (10)
- April 2011 (7)
- March 2011 (10)
- February 2011 (5)
- January 2011 (1)
- December 2010 (4)
- November 2010 (2)
- October 2010 (3)
Tags
Alerts
Analyze
Backup
Bloat
Catalog
Checkpoints
compression
Copy
Disk
Disk Space
gzip
Index
Install
Kill
Linux
Locking
Logs
Monitoring
Oracle
Parallel
Parameter
Partition
Performance
pg_ctl
pg_dump
pg_restore
pg_xlog
PostgreSQL
psql
Roles
Scripts
Security
ssh
Stats
Support
Tablespace
Template
Temporary
toast
Transactions
Upgrade
UTF
Vacuum
Versions
Windows
Categories
- Linux (23)
- Oracle (5)
- PostgreSQL (55)
- Uncategorized (1)
- Windows (7)



