Linux Mint - cannot find auto_explain extension

From: Keith Roberts <keith(at)karsites(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Linux Mint - cannot find auto_explain extension
Date: 2019-08-01 17:53:16
Message-ID: 23b8fd4e-1050-706b-ac22-37c6597ffb56@karsites.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I'm running Linux Mint 18 Sarah and have installed PostgreSQL 9.5.18 but
cannot load the auto_explain extension.

postgres=# SELECT * from pg_extension;
-[ RECORD 1 ]--+--------
extname        | plpgsql
extowner       | 10
extnamespace   | 11
extrelocatable | f
extversion     | 1.0
extconfig      |
extcondition   |

postgres=# SELECT * from pg_available_extensions;
-[ RECORD 1 ]-----+-----------------------------
name              | plpgsql
default_version   | 1.0
installed_version | 1.0
comment           | PL/pgSQL procedural language

postgres=#
postgres=# CREATE EXTENSION auto_explain;
ERROR:  could not open extension control file
"/usr/share/postgresql/9.5/extension/auto_explain.control": No such file
or directory
postgres=#

Does anyone have any idea what package I need to install to get the
auto_explain extension please?

TIA

Keith Roberts

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2019-08-01 18:01:11 Re: Linux Mint - cannot find auto_explain extension
Previous Message Adrian Klaver 2019-08-01 16:14:50 Re: PGAdmin4.11.1 on Ubuntu 18.04