patternsqlMinor
can't install citext extension: could not access file "$libdir/citext": No such file or directory
Viewed 0 times
suchcaninstallfiledirectorycitextcouldlibdirextensionnot
Problem
I'm trying to get citext available as a type in a specific database. The Postgres database server is 9.4. I see it on the server in the pg_catalog's pg_available_extensions view.
From the psql console I try to install it and get this error:
Is there a configuration problem? I'm not sure why it would not have the $libdir variable populated.
From the psql console I try to install it and get this error:
create extension citext;
ERROR: could not access file "$libdir/citext": No such file or directoryIs there a configuration problem? I'm not sure why it would not have the $libdir variable populated.
Solution
Did you perhaps install multiple instances of Postgres on the same server? Standard Postgres is not built for that,
Related:
$libdir is compiled into the program. If so, you could fix your problem by uninstalling all other instances and and re-installing your current Postgres version.Related:
- Could not access file “$libdir/plpgsql”: No such file or directory
Context
StackExchange Database Administrators Q#118297, answer score: 2
Revisions (0)
No revisions yet.