can't get pg_stat_statements to work - Mailing list pgsql-novice

From richard@xentu.com
Subject can't get pg_stat_statements to work
Date
Msg-id a4b5725b98802e048fdc17d2e46cdec4@xentu.com
Whole thread Raw
Responses Re: can't get pg_stat_statements to work  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-novice by date:

Previous
From: Gurunadh Venkata
Date:
Subject: Reg Automatic Fail over & Automatic Failback in Pgpool.
Next
From: Tom Lane
Date:
Subject: Re: can't get pg_stat_statements to work