Install: PostgreSQL 7.2.1

This is my attempt at installing database PostgreSQL 7.2.1 on Linux Debian 3, as required by the Learning Management System .LRN 1.0.1 which is built on the web application server OpenACS 4.6.3. Apparently, on my machine someone has already installed the PostGreSQL 7.2.1-2woody2 package. But the post-installation script was not run; in other words, no functioning database is up and running.

Upgrade

There was a 7.1 database installed on the machine, which had not yet been updated and which no one was claiming. Instead of letting the postgresql post-installation script update this probably useless database, I just moved the /var/lib/postgresql/data directory out of the way.

Default database

Then I unleashed /var/lib/dpkg/info/postgresql.postinst configure, which created the default template1 database.

From now on, the database should be automatically restarted upon booting via /etc/init.d/postgresql start

.LRN/OpenACS installation instructions

I followed .LRN installation instructions with respect to postgresql.

Added plpgsql support to template1:
createlang plpgsql template1
createlang -l template1
Actually, it was already done.

Tested PostgreSQL by creating a temporary database.

Tuned PostgreSQL.

Posted by juliob at September 23, 2003 09:04 PM