PostgreSQL ERROR: could not open extension control file "/usr/share/postgresql/11/extension/plperl.control" No such file or directory,
Install the package in your Ubuntu machine using the command below,
$ sudo apt-get install -y postgresql-plperl-11
$ psql -U postgres
Then, create a PL/Perl extension in
postgres=> CREATE EXTENSION plperl;
CREATE EXTENSION
postgres=> 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 | 13994 | 13995 | 13996 |
plperl | 10 | t | t | 1254632 | 1254633 | 1254634 |
(5 rows)
Comments (0)