Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_statsinfo problem

pg_statsinfo problem

From
AI Rumman
Date:
Does any one use pg_statsinfo for Postgresql 9.0.1? Is there any similar tools to collect DB Snapshots?

I am facing problem during pg_statsinfo configuration.
I set as follows:
shared_preload_libraries = 'pg_statsinfo,pg_stat_statements'
custom_variable_classes = 'pg_statsinfo'

But my Db is not starting.


Re: pg_statsinfo problem

From
Tatsuhito Kasahara
Date:
Hi !

> I am facing problem during pg_statsinfo configuration.
> I set as follows:
> shared_preload_libraries = 'pg_statsinfo,pg_stat_statements'
> custom_variable_classes = 'pg_statsinfo'

> But my Db is not starting.
Which version did you use ?
And what log-message were generated ?

If you used rpm of pg_statsinfo-2.0.0 on RHEL5_x86_64, please try to
use pg_statsinfo-2.0.1.
( I mistook to edit the RPM SPEC file for pg90.rhel5.x86_64... So some
user reported that
  "No such files" error was occured when they used the rpm of
pg_statsinfo-2.0.0 with
  PG90 on RHEL5.x86_64)

If you have more questions about pg_statsinfo, please post to ML for
pg_statsinfo,
or send me directly.
( http://pgfoundry.org/mail/?group_id=1000422 )

Best regards,
--
Tatsuhito Kasahara
kasahara.tatsuhito _at_ gmail.com

Re: pg_statsinfo problem

From
Devrim GÜNDÜZ
Date:
On Mon, 2010-12-20 at 19:29 +0900, Tatsuhito Kasahara wrote:
> ( I mistook to edit the RPM SPEC file for pg90.rhel5.x86_64... So some
> user reported that
>   "No such files" error was occured when they used the rpm of
> pg_statsinfo-2.0.0 with
>   PG90 on RHEL5.x86_64)

Sorry for breaking the thread a bit -- but where is that specfile? I
cannot find it in the tarball.

Also SRPMs are missing on the website.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Attachment

Re: pg_statsinfo problem

From
Tatsuhito Kasahara
Date:
2010/12/20 Devrim GÜNDÜZ <devrim@gunduz.org>:
> Sorry for breaking the thread a bit -- but where is that specfile? I
> cannot find it in the tarball.
>
> Also SRPMs are missing on the website.
Now, specfiles and SRPMs are not provided on the pg_statsindo project page..

I'll upload these files ASAP.

Best regards,

--
Tatsuhito Kasahara
kasahara.tatsuhito _at_ gmail.com