Compiler errors on make about pg_stat_plans HOT 4 CLOSED

On Thu, May 23, 2013 at 1:08 PM, samthakur74 [email protected]:

Hello,
Clearly i am doing something incorrect. I copied the pg_stat_plans folder
structure under contrib of my PostgreSQL 9.2.3 instance, which i have built
from source.

You don't need pg_stat_plans in postgres 9.2, you have the contrib module
pg_stat_statements which the original and full feature for this.

Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157

from pg_stat_plans.

i thought pg_stat_plans also provides query plan information like planning
time for a query. Did not see planning time provided by pg_stat_statements.
Thank you
Sameer

On Fri, May 24, 2013 at 4:10 AM, Jaime2ndQuadrant
[email protected]:

On Thu, May 23, 2013 at 1:08 PM, samthakur74 [email protected]:

Hello,
Clearly i am doing something incorrect. I copied the pg_stat_plans
folder
structure under contrib of my PostgreSQL 9.2.3 instance, which i have
built
from source.

You don't need pg_stat_plans in postgres 9.2, you have the contrib
module
pg_stat_statements which the original and full feature for this.

Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/20#issuecomment-18376400
.

from pg_stat_plans.

Installing postgresql-devel for 8.4 when you're using 9.2 compiled from source will not work, it'll just cause chaos and confusion.

What you should do is:

• uninstall postgresql-devel, you do not need it if you built from source
• Set your PATH so that when you run "pg_config --version" you get 9.2, not 8.4. PATH must include the directory containing pg_config, usually the same one that contains psql etc.
• cd to the pg_stat_plans dir and make clean make and sudo make install.

It doesn't matter where pg_stat_plans is, it always uses PGXS rather than integrating into the build tree. Copying it under contrib has no effect.

It is my understanding that pg_stat_plans does have some additional timing info available in 9.2, though I haven't had cause to look into it myself yet.

from pg_stat_plans.

Thanks for a clear response. Got it working now!

On Fri, May 24, 2013 at 10:14 AM, Craig Ringer [email protected]:

Installing postgresql-devel for 8.4 when you're using 9.2 compiled from
source will not work, it'll just cause chaos and confusion.

What you should do is:

uninstall postgresql-devel, you do not need it if you built from source

Set your PATH so that when you run "pg_config --version" you get 9.2,
not 8.4. PATH must include the directory containing pg_config, usually the
same one that contains psql etc.

cd to the pg_stat_plans dir and make clean make and sudo make install.

It doesn't matter where pg_stat_plans is, it always uses PGXS rather than
integrating into the build tree. Copying it under contrib has no effect.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/20#issuecomment-18386341
.

from pg_stat_plans.