Thread: pgstatspack version?

Hi All

        Does anybody perhaps know what version of PGSTATSPACK works specifically for postgresql-8.1 ?

        We have been trying to find out which version to download, however the website does not seem to have any info on which version is compatible with which database versions unless we are missing it somewhere).

        Thank you very much for any replies in advance.


Regards
Machiel

On Mon, Dec 13, 2010 at 3:54 AM, Machiel Richards <machielr@rdc.co.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

[Oops, forgot to CC the list]

On Fri, Dec 17, 2010 at 1:33 AM, Eric Comeau <Eric.Comeau@signiant.com> wrote:
> I am also interested in running pgstatspack on 81, so any progress
> please let me know. Thanks Josh for kicking the tires on it to give it a
> try.

I had a minute to give this package another look today. Seems like it
works fine if you just fix up sql/pgstats_exists.sql to not use the
VALUES (...) statement (new version attached).

You'll also get some errors from sql/pgstatspack_create_tables.sql,
since that file uses DROP TABLE IF EXISTS which isn't available in
8.1. But those errors shouldn't break anything; those SQL files are
(probably unwisely) not run inside a transaction, so you'll just see
some error messages about those tables not existing.

Anyways, it looks like pgstatspack_snap() works fine for me on 8.1.23
after these minor changes. There are a whole bunch of other rough
edges in the install procedure and documentation which I'd like to
have fixed as well. Unfortunately, two of the three developers' email
addresses in the README are broken, and the third (Uwe Bartels) has an
auto-responder message saying he's away till February. I don't know if
it's worth forking the project for a while to clean up the code until
the developers return, but perhaps that's the only way to go.

Josh