Forum OpenACS Development: Response to Any .deb package for PostgreSQL 7.1?

Collapse
Posted by Edmund Lian on
7.1RC3 debs, built for potato, are aptable at:

deb http://people.debian.org/~elphick/postgresql/pg7.1/potato/ ./
Note that there are a few minor problems that I've come across.
  1. The default security policy is to ask for passwords. But the postgres superuser is installed either with an unknown (to me) password, or one that is undefined. To get around this, you must change your /etc/postgresql/pg_hba.conf so that localhost has a default "trust" policy (from "password"). Then crank up psql and change the password of postgres to something you want, then change the localhost security policy back to "password" if you're paranoid.

  2. pgaccess expects to find the file /usr/lib/postgresql/lib/libpgtcl.so, but the debs install it in /usr/lib/libpgtcl.so. Fix this with a symlink ln -s /usr/lib/libpgtcl.so /usr/lib/postgresql/lib/libpgtcl.so