Re: pgstatspack reports output to file.

-f filename specifies where the report will be written

--- On Fri, 10/15/10, Machiel Richards <machielr(at)rdc(dot)co(dot)za> wrote:

From: Machiel Richards <machielr(at)rdc(dot)co(dot)za>
Subject: [NOVICE] pgstatspack reports output to file.
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Date: Friday, October 15, 2010, 4:53 AM

HI All

        I am hoping that someone can assist me here as I can't seem to find any info on the net or in documentation on this.

        Pgstatspack is running on one of many servers at the moment in order to ensure it does not have any system impact as system resources are limited as is.

        The snapshots have been running for a week now and all looks good.

        I am now trying to run a report for the last week which is easy enough, however everything is displayed on the monitor.

        I have tried to find a parameter to the script to specify output file but can't seem to find anything like this in the documentation I have.

        I then tried to redirect output to a file, however this does not work either as it also redirects the displays to select the database and snapshots.

        Can anyone perhaps help me out with a way on how to output the results to a file as this will be used to create graphs for the clients.

Regards
Machiel