Обсуждение: pg_stat_statements extension

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