Thread: pg_stat_statements extension
HI, Is there any good link that shows how to install pg_stat_statements extension
I am getting below error
postgres=# CREATE EXTENSION pg_stat_statements;
ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pg_stat_statements.control": No such file or directory
ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pg_stat_statements.control": No such file or directory
Thanks.
On 1/13/20 11:15 AM, Rushikesh socha wrote: > HI, Is there any good link that shows how to install pg_stat_statements > extension Postgres version? How did you install Postgres? > I am getting below error > > postgres=# CREATE EXTENSION pg_stat_statements; > ERROR: could not open extension control file > "/usr/pgsql-11/share/extension/pg_stat_statements.control": No such file > or directory > > > Thanks. > -- Adrian Klaver adrian.klaver@aklaver.com
HI its 11.5
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
---------------------------------------------------------------------------------------------------------
PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
Thanks.
Rushikesh Socha
Edison,NJ,USA
Cell : +1 860 794 4643
On Mon, Jan 13, 2020 at 2:24 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 1/13/20 11:15 AM, Rushikesh socha wrote:
> HI, Is there any good link that shows how to install pg_stat_statements
> extension
Postgres version?
How did you install Postgres?
> I am getting below error
>
> postgres=# CREATE EXTENSION pg_stat_statements;
> ERROR: could not open extension control file
> "/usr/pgsql-11/share/extension/pg_stat_statements.control": No such file
> or directory
>
>
> Thanks.
>
--
Adrian Klaver
adrian.klaver@aklaver.com
On 1/13/20 11:29 AM, Rushikesh socha wrote: > HI its 11.5 > version > --------------------------------------------------------------------------------------------------------- > PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 > 20150623 (Red Hat 4.8.5-36), 64-bit How did the above get installed, from source, RPM. other? > > Thanks. > * > * > Rushikesh Socha > Edison,NJ,USA > Cell : +1 860 794 4643 > > > On Mon, Jan 13, 2020 at 2:24 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > On 1/13/20 11:15 AM, Rushikesh socha wrote: > > HI, Is there any good link that shows how to > install pg_stat_statements > > extension > > Postgres version? > > How did you install Postgres? > > > I am getting below error > > > > postgres=# CREATE EXTENSION pg_stat_statements; > > ERROR: could not open extension control file > > "/usr/pgsql-11/share/extension/pg_stat_statements.control": No > such file > > or directory > > > > > > Thanks. > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
On 13 January 2020 20:15:21 CET, Rushikesh socha <rushikesh.s@gmail.com> wrote: >HI, Is there any good link that shows how to install pg_stat_statements >extension >I am getting below error > >postgres=# CREATE EXTENSION pg_stat_statements; >ERROR: could not open extension control file >"/usr/pgsql-11/share/extension/pg_stat_statements.control": No such >file or >directory > > >Thanks. Have you installed the contrib-package and also load the shared lib via postgresql.conf? Andreas -- 2ndQuadrant - The PostgreSQL Support Company
On Mon, Jan 13, 2020 at 11:41:36AM -0800, Adrian Klaver wrote: > How did the above get installed, from source, RPM. other? Rushikesh, depending on your environment, the way to install pg_stat_statements' libraries may change. On most Linux distributions, any extension modules are shipped with a package different than the main ones for the server and client binaries and libraries. Then, you would most likely look for a package named postgresql-11-contrib or similar. -- Michael