<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>Dreaded DBD::Pg errors</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Again DBD::Pg has reared it's ugly head.<BR>
<BR>
I'm installing OME_2_6_0 from cvs. I have DBD:Pg v 1.43 and Postgres 8.1.4 installed.<BR>
<BR>
The perl installer dies after creating a new ome database with:<BR>
<BR>
Database Delegate Class: OME::Database::PostgresDelegate<BR>
Database Name: ome<BR>
Host: undefined (local)<BR>
Port: undefined (default)<BR>
Username for DB connection: undefined (process owner)<BR>
<BR>
Are these values correct ? [y/n]:<BR>
Creating OME PostgreSQL SUPERUSER (ome)[SUCCESS].<BR>
Creating Apache PostgreSQL SUPERUSER (apache)[SUCCESS].<BR>
Creating Admin PostgreSQL SUPERUSER (mrmike)[SUCCESS].<BR>
Checking database<BR>
Creating PostgreSQL database ome... [Done.]<BR>
Fixing OID/INTEGER compatability bug...DBD::Pg::db do failed: ERROR: could not access file "$libdir/plpgsql": No such file or directory<BR>
<BR>
<BR>
Errors executing task: DBD::Pg::db do failed: ERROR: could not access file "$libdir/plpgsql": No such file or directory<BR>
<BR>
at install.pl line 82<BR>
main::run_tasks() called at install.pl line 266<BR>
# Looks like your test died before it could output anything.<BR>
<BR>
Oddly enough, plpgsql.so exists in /usr/local/pgsql/lib.<BR>
<BR>
The source of the fault seems to be line 143 in PostgresDelegate.pm It's not obvious where $libdir gets set.<BR>
<BR>
Incidentally, if you already have DBD:Pg 1.49 (latest version) installed, the perl installer happily uses it (and then blows up with errors) instead of rejecting it as PerlModuleTask.pm implies.<BR>
<BR>
Any suggestions on what to look for?<BR>
<BR>
Michael J. McCaughey, PhD<BR>
Molecular Physiology and Biophysics<BR>
U9203 MRBIII<BR>
6-6175<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>