Re: Pgstatspack errors in log files

On 10/13/2010 3:12 AM, Machiel Richards wrote:
> Hi All
>
> I am hoping someone else have had this before.
>
> We have configured pgstatspack to run on one of many database
> servers as we want to test the impact and results before deploying to
> all servers.
>
> On the test server everything was working fine without any errors.
>
> However, we then deployed this to one of the production server
> and even though we are getting relevant results, snapshots,etc... the
> following errors appear in the Postgresql log files.
>
> Does anybody know why we would be getting this and how to
> resolve this. I would really appreciate the help.
>
> /2010-10-13 04:00:01 SAST HINT: No function matches the given name
> and argument types. You might need to add explicit type casts./
> /2010-10-13 04:00:01 SAST STATEMENT: select pgstatspack_snap('cron
> based snapshot');/
> /2010-10-13 04:00:01 SAST ERROR: function pgstatspack_snap(unknown)
> does not exist at character 8/
> /2010-10-13 04:00:01 SAST HINT: No function matches the given name
> and argument types. You might need/
Did you load pg_stat_statements module? Without loading that module,
pgstatspack will not be created and will not run.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com