Forum OpenACS Q&A: Postgres7.1 Redhat RPM and installation instructions

Section 5.5 from the Installation Guide

I've installed PostgreSQL7.1 from the RPM for Redhat and when attempting to load the data model, (psql -f load-data-model.sql ...) However, it appears that most of the definitions in postgres.sql are already defined (line 18, 27, 38, 44, 52, 61, 71, 81, 102 ...) Ideas?

Ok, I understand what's going on but am not sure how best to proceed. In following the RPM install doc

rpm -ivh postgresql-7.1-1.i386.rpm

had a dependency that required the library package (this isn't one of the packages listed in the doc). I downloaded postgresql-libs-7.1-1.i386.rpm and used the command

rpm -ivh postgresql-libs-7.1-1.i386.rpm

to install it and proceeded with the instructions. Everything appeared to be OK - I could start postgres, create a db, load-geo-tables - until I get to the load the data model section.

Since I installed from an RPM, I have to edit the postgres.sql file to remove the comments:

--create function plpgsql_call_handler() RETURNS opaque
--as '/usr/lib/pgsql/plpgsql.so' language 'c';

The first thing that I notice is that the plpgsql.so library file installed via the RPM is NOT in the pgsql subdirectory. It has been installed (together with the other library files) in the /usr/lib directory.

Changing the postgres.sql line above to exclude the pgsql subdirectory

as '/usr/lib/plpgsql.so' language 'c';

doesn't solve the problem as I expect there are other dependencies on the libraries being in the usr/lib/pgsql subdirectory.

I'm a Linux novice and not sure how to proceed. How do I get the library files in the /usr/lib/pgsql directory via the RPM command. Do I have to uninstall all of the Postgres RPM packages and start again or is there a way to move the postgresql-libs-7.1-1.i386.rpm library package into the pgsql directory?

By creating a pgsql subdirectory under /usr/lib and manually moving files into this directory I was able to get the load to work. I queried the lib package and all of it's contents get installed at /usr/lib not /usr/lib/pgsql. However, the offending file appears to have been plpgsql.so which isn't part of any packages according to rpm. I don't know where this file comes from in the install process or why I had to make a pgsql subdirectory for this file. Now, on to tweaking NSD.TCL...