Brief Notes
Noteworthy links, summaries and concise prose on stuff.


All about using PostgreSQL in a technology stack.


lo_truncate64 issue on WebFaction:

  • PostgreSQL version 9.4.4 built from source and installed using Postgres-only installation instructions at Installing PostgreSQL with PostGIS - WebFaction Community
  • Python 3.4.3 virtualenv activated
  • pip install psycopg2 -> psycopg2-2.6.1
  • In a Python interpreter session, issue import psycopg2 statement, got error ImportError: /home/<user>/p343/lib/python3.4/site-packages/psycopg2/ undefined symbol: lo_truncate64

After much searching, the solution, based on reading PostgreSQL: Documentation: 9.4: Post-Installation Setup was to add the following (replace pg944sql with the actual folder Postgres was installed into) in .bash_profile: