Thread

1. Error loading /usr/lib/postgresql/plpgsql.so

   wsheldah@lexmark.com — 2003-03-19T16:17:37Z

   Hi,
   
   I've recently upgraded a test server from postgresql 7.2.2 to version
   7.3.2, and also rebuilt perl 5.8.0 on a gentoo linux system. Restoring the
   databases worked fine, selecting from tables works fine, but a simple
   insert statement generates this error:
   
   ERROR:  Load of file /usr/lib/postgresql/plpgsql.so failed: /lib/libc.so.6: version `GLIBC_2.3' not found (required by /usr/lib/postgresql/plpgsql.so)
   
   The same error is generated whether the insert is done from the psql prompt or through a perl script using DBI and DBD::PG (latest versions of both).
   The insert statement is:
   
   insert into testrun(f1, f2, f3, f4, f5, f6, f7 ) values( 'aa', 'bb', 'cc', 'ddd', 'eee', 'ffff', 'ggggg') ;
   
   (with actual field names and values altered)
   
   The testrun table has a trigger that runs before insert or update, that calls a plpgsql function. This is evidently where the problem is. However,
   /lib/libc.so.6 clearly exists, and my current version of glibc appears to be 2.3
   
   What's the best way to go about fixing it?
   
   Thanks,
   
   Wes
   
   
   
   

2. Re: Error loading /usr/lib/postgresql/plpgsql.so

   Richard Huxton <dev@archonet.com> — 2003-03-19T19:17:41Z

   On Wednesday 19 Mar 2003 4:17 pm, wsheldah@lexmark.com wrote:
   > Hi,
   >
   > I've recently upgraded a test server from postgresql 7.2.2 to version
   > 7.3.2, and also rebuilt perl 5.8.0 on a gentoo linux system. Restoring the
   > databases worked fine, selecting from tables works fine, but a simple
   > insert statement generates this error:
   >
   > ERROR:  Load of file /usr/lib/postgresql/plpgsql.so failed: /lib/libc.so.6:
   > version `GLIBC_2.3' not found (required by /usr/lib/postgresql/plpgsql.so)
   
   > The testrun table has a trigger that runs before insert or update, that
   > calls a plpgsql function. This is evidently where the problem is. However,
   > /lib/libc.so.6 clearly exists, and my current version of glibc appears to
   > be 2.3
   >
   > What's the best way to go about fixing it?
   
   Very peculiar - all I can think is that there's some old library files 
   somewhere. You might want to check the plpgsql.so is the new version, since 
   it looks like your libc is OK. Perhaps try "locate plpgsql.so" and see if 
   there is another version somewhere else.
   
   Failing that, a make clean, and complete configure/make cycle for PostgreSQL 
   should deal with it I'd have thought.
   
   -- 
     Richard Huxton