Error Could Not Access File $libdir/plpgsql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow postgres set libdir the company Business Learn more about hiring developers or posting ads with us Stack Overflow libdir linux Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of
Postgres Change Libdir
4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Could not access file “$libdir/plpgsql”: No such file or directory up vote 2 down vote favorite 1 I'm
"postgis" "libdir"
at a loss, I'm having issues creating a stored proc in my local Postgres server (postgres.app, Mac OS X 10.7), as so $ psql psql (9.3.0) Type "help" for help. dchaston=# CREATE OR REPLACE FUNCTION table_update() dchaston-# RETURNS TRIGGER AS $$ dchaston$# BEGIN dchaston$# NEW.last_edit = now(); dchaston$# RETURN NEW; dchaston$# END; dchaston$# $$ language 'plpgsql'; ERROR: could not access file "$libdir/plpgsql": No such file or directory I've checked the following: Languages installed: could not access file "$libdir/plpython2 dchaston=# select * from pg_language; lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid | laninline | lanvalidator | lanacl ---------+----------+---------+--------------+---------------+-----------+--------------+-------- internal | 10 | f | f | 0 | 0 | 2246 | c | 10 | f | f | 0 | 0 | 2247 | sql | 10 | f | t | 0 | 0 | 2248 | plpgsql | 10 | t | t | 12019 | 12020 | 12021 | (4 rows) lib directory (and pkglibdir just in case): $ pg_config --libdir /Applications/Postgres.app/Contents/MacOS/lib $ pg_config --pkglibdir /Applications/Postgres.app/Contents/MacOS/lib File present: $ cd /Applications/Postgres.app/Contents/MacOS/lib; ls plpg* plpgsql.so DLSUFFIX set correctly: lib/pgxs/src/Makefile.shlib:135: DLSUFFIX = .so Have tried uninstalling and reinstalling, but made no difference. Any ideas? postgresql osx-lion plpgsql postgresql-9.3 postgres.app share|improve this question edited Dec 30 '13 at 19:35 Erwin Brandstetter 218k29353465 asked Dec 29 '13 at 17:03 CaffeinatedDave 7517 add a comment| 1 Answer 1 active oldest votes up vote 5 down vote accepted Did you install multiple instances (multiple versions or multiple instances of the same version) of Postgres on the same box? Standard Postgres is not fit for that. Debian or Ubuntu have additional infrastructure to allow multiple versions in parallel. I don't know about OS X, though. In standard Postgres the path for $libdir is compile
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow http://stackoverflow.com/questions/20827761/could-not-access-file-libdir-plpgsql-no-such-file-or-directory is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up could not access file “$libdir/plpgsql” while creating template_postgis up vote 0 down vote favorite I have installed PostgreSQL and Postgis on my Mac before when it's 9.3 and 2.1 but http://stackoverflow.com/questions/33890045/could-not-access-file-libdir-plpgsql-while-creating-template-postgis never used. After upgrading pg to 4.5_2 and postgis to 2.2 (the latest now), I try to build my first postgis based app and creating template_postgis like this: createdb template_postgis psql -d template_postgis -f /usr/local/share/postgis/postgis.sql And got this error: SET BEGIN psql:/usr/local/share/postgis/postgis.sql:77: ERROR: could not access file "$libdir/plpgsql": No such file or directory ... So I run pg_config --libdir it says /usr/local/lib, and pg_config --pkglibdir returns /usr/local/lib/postgresql. And I found plpgsql.so under pkglibdir not libdir, so I create a symbol link named plpgsql.so and another plpgsql under libdir, but it still not works. What really is the problem there? How can I fix this? My Mac is running the newest OS X 10.11 and both of them are installed and upgraded by homebrew. Update: Inspired by @Stefan D. , I run psql -c "\dx" to list all the installed extensions which results: Name | Version | Schema | Description ---------+---------+------------+--------------------------------------------------------------------- plpgsql | 1.0 | pg_
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer https://www.postgresql.org/message-id/27602.1338060233@sss.pgh.pa.us lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News Re: could not access file "$libdir/plpgsql": No such file or directory From: Tom Lane