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?
