pg_stat_statements extension

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

pg_stat_statements extension

Rushikesh socha
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.

Reply | Threaded
Open this post in threaded view
|

Re: pg_stat_statements extension

Adrian Klaver-4
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
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: pg_stat_statements extension

Rushikesh socha
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

Thanks.

Rushikesh Socha
Edison,NJ,USA
Cell : +1 860 794 4643


On Mon, Jan 13, 2020 at 2:24 PM Adrian Klaver <[hidden email]> 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
[hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: pg_stat_statements extension

Adrian Klaver-4
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 <[hidden email]
> <mailto:[hidden email]>> 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
>     [hidden email] <mailto:[hidden email]>
>


--
Adrian Klaver
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: pg_stat_statements extension

Andreas Kretschmer-3
In reply to this post by Rushikesh socha
On 13 January 2020 20:15:21 CET, Rushikesh socha <[hidden email]> 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


Reply | Threaded
Open this post in threaded view
|

Re: pg_stat_statements extension

Michael Paquier-2
In reply to this post by Adrian Klaver-4
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

signature.asc (849 bytes) Download Attachment