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

On Wednesday 19 Mar 2003 4:17 pm, wsheldah(at)lexmark(dot)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