so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and following the instructions of the documentation i've found myself in a major issue which has overwhelmed my little knowledge. these were the steps i followed:
1)downloand and install 9.2.4, with the contrib packages. 2)init the 9.2.4 cluster in /usr/local/pgsql9.2.4/data, i also have the 8.3.2 cluster in /usr/local/pgsql/data 3) stop both servers 4)change the 9.2.4 port to 5433 5) i run this command: /usr/local/pgsql9.2.4/bin/./pg_upgrade -b /usr/local/pgsql/bin/ -B /usr/local/pgsql9.2.4/bin/ -c -d /usr/local/pgsql/data/ -D /usr/local/pgsql9.2.4/data/ -p 5432 -P 5433 -v so after some 30 seconds the upgrade process seemed like "working" but after it crashed with this message: Checking for presence of required libraries fatal Your installation references loadable libraries that are missing from the new installation. You can add these libraries to the new installation, or remove the functions using them from the old installation. A list of problem libraries is in the file: loadable_libraries.txt Failure, exiting "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/" -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1 so i went to check the log and found: ERROR: could not access file "$libdir/liblwgeom": No such file or directory STATEMENT: LOAD '$libdir/liblwgeom' command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/" -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1 LOG: received fast shutdown request LOG: aborting any active transactions waiting for server to shut down....FATAL: terminating connection due to administrator command LOG: could not send data to client: Broken pipe LOG: shutting down LOG: database system is shut down done server stopped please help as i dont have any idea what's going wrong