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

PostgreSQL

All about using PostgreSQL in a technology stack.

Notes

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/_psycopg.cpython-34m.so: 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:

export LD_LIBRARY_PATH=$HOME/pgsql944/lib:$LD_LIBRARY_PATH