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