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

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 <adrian.klaver@aklaver.com>
wrote:

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