Skip site navigation (1) Skip section navigation (2)

Re: pgstatspack version?

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pgstatspack version?
Date: 2010-12-16 02:29:18
Message-ID: AANLkTin2EGduFVzkTnHtK=uaU4LKA_9dnKdV4WrnRp5P@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Mon, Dec 13, 2010 at 3:54 AM, Machiel Richards <machielr(at)rdc(dot)co(dot)za> wrote:
> Hi All
>
>         Does anybody perhaps know what version of PGSTATSPACK works
> specifically for postgresql-8.1 ?

I took a quick look at pgstatspack 2.2 with an install of Postgres
8.1.23. I got a whole bunch of errors when trying to install
pgstatspack; it looks to me like it won't work on 8.1, at least not
without some (minor?) tweaking of pgstatspack. For instance, I get:

psql:sql/pgstats_exist.sql:5: ERROR:  function values("unknown") does not exist

Since the VALUES (...) construct was only introduced in Postgres 8.2.
I came across a whole bunch of other errors while trying to run
install_pgstats.sh, so I can't say how easy it would be to make it
work in 8.1 without further digging. There doesn't appear to be a
mailing list for that project, but the pgstatspack_README.txt does
give a few of the developers' email addresses you could try for
further help.

Josh

In response to

Responses

pgsql-novice by date

Next:From: Josh KupershmidtDate: 2010-12-16 02:51:39
Subject: Re: create function and trigger to update column on table update
Previous:From: Dara OlsonDate: 2010-12-15 22:02:37
Subject: create function and trigger to update column on table update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group