can't get pg_stat_statements to work

From: richard(at)xentu(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: can't get pg_stat_statements to work
Date: 2015-09-19 09:37:13
Message-ID: a4b5725b98802e048fdc17d2e46cdec4@xentu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Ubuntu 11.04
Postgresql 8.4

I've installed postgresql-contrib:

# sudo apt-get install postgresql-contrib

I now have a directory:
/usr/share/postgresql/8.4/contrib
I've added a line in postgresql.conf:

shared_preload_libraries = 'pg_stat_statements'

and I connected to postgres using pgAdmin and inside a test database, I
ran the

/usr/share/postgresql/8.4/contrib/pg_stat_statements.sql

However, unless I comment out the new line in postgresql.conf, the
server won't start.

Could anyone tell me how to make this work?

Richard

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2015-09-19 14:37:38 Re: can't get pg_stat_statements to work
Previous Message Gurunadh Venkata 2015-09-18 08:18:44 Reg Automatic Fail over & Automatic Failback in Pgpool.