Skip site navigation (1) Skip section navigation (2)

Re: could not access file "$libdir/plpgsql": No such file or directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Victor Whiskey Yankee <victor(dot)whiskey(dot)yankee(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: could not access file "$libdir/plpgsql": No such file or directory
Date: 2012-05-26 19:23:53
Message-ID: 27602.1338060233@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Victor Whiskey Yankee <victor(dot)whiskey(dot)yankee(at)gmail(dot)com> writes:
> loading PL/pgSQL server-side language ... FATAL:  could not access file "$libdir/plpgsql": No such file or directory

> I don't know what this means nor how to fix it.

It means you don't have a plpgsql.so file, and the reason is here:

> My configuration line when building was:
> ./configure --prefix=$MY_PREFIX --disable-nls --disable-shared --disable-rpath --enable-thread-safety --without-tcl --without-perl 

--disable-shared has been deprecated for awhile, and it's evidently flat
out broken as of 9.1, since plpgsql.so is now effectively required.
Do you really need that?

(We should either fix this or remove the option, but in the meantime,
don't use it.)

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Victor Whiskey YankeeDate: 2012-05-26 22:16:53
Subject: Re: could not access file "$libdir/plpgsql": No such file or directory
Previous:From: Victor Whiskey YankeeDate: 2012-05-26 16:25:34
Subject: could not access file "$libdir/plpgsql": No such file or directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group