Re: pg_stat_statements extension

2020-01-16 Thread Andreas Kretschmer
On 13 January 2020 20:15:21 CET, Rushikesh socha 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

Re: pg_stat_statements extension

2020-01-13 Thread Michael Paquier
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 p

Re: pg_stat_statements extension

2020-01-13 Thread Adrian Klaver
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 201506

Re: pg_stat_statements extension

2020-01-13 Thread 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

Re: pg_stat_statements extension

2020-01-13 Thread Adrian Klaver
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 fil