Forum OpenACS Development: Any .deb package for PostgreSQL 7.1?
Woody contains a 7.0.3 package, and Oliver Elphick's site (the Debian maintainer for the PostgreSQL package) has a 7.1beta5 package.
Does anybody know where I might find a 7.1RC2 .deb? Alternately, is it OK to use the 7.1beta5 version?
I don't think it'd be too hard to get the source deb package for 7.1 beta 5 and upgrade it to RC2, then rebuild the package.
deb http://people.debian.org/~elphick/postgresql/pg7.1/potato/ ./Note that there are a few minor problems that I've come across.
- 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.
- 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