After upgrading Ubuntu from Precise to Trusty, I was attempting to upgrade PostgreSQL from 9.1 to 9.3 and have hit a bit of a snag. When I ran
pg_upgrade in "check" mode, it complained about being unable to load the library
pljava even after I had dropped the language.
After much head-scratching, I had the brilliant idea to try a clean reinstall of PostgreSQL 9.1 and so blithely uninstalled the package, only to discover that I cannot now install it again, as Synaptic reports the package as being broken. Thus, I now have the 9.3 binaries and a set of data files created with 9.1 and no idea how to safely access them.
Could someone please tell me EITHER
- how to reinstall PostgreSQL 9.1 so I may complete the migration process, or
- how to complete the migration process safely without reinstalling the old binaries?