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

pgstatsinfo - pg_statsinfo: Fixed various errors in edge-cases and

From: itagaki(at)pgfoundry(dot)org (User Itagaki)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgstatsinfo - pg_statsinfo: Fixed various errors in edge-cases and
Date: 2010-03-08 05:36:33
Message-ID: 20100308053633.78B8A10715C6@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fixed various errors in edge-cases and merged server and statsinfo logs.

- Merge output of elog() and erepot() into textlog and syslog.
- Don't adjust non-critical server parameters.
- Adjust the default snapshot interval to 300s.
- Change error level order of "log" and "alert" to:
    ... < error < log < fatal < panic < alert < disable
- Support manual snapshot by statsinfo.snapshot('comment').
- Add statsinfo.restart().
- The default repository_server setting should have port setting.
- Adjust timestamps of autovacuum and autoanalyze to be start times.
- Don't write shutdown checkpoint log because repository server might
  not be available.
- Add some delay before logger shutdown because postgres logger might
  be still alive in some seconds after postmaster's shutdown.

Modified Files:
--------------
    pg_statsinfo:
        common.h (r1.1 -> r1.2)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/common.h?r1=1.1&r2=1.2)
    pg_statsinfo/bin:
        Makefile (r1.2 -> r1.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/Makefile?r1=1.2&r2=1.3)
        autovacuum.c (r1.4 -> r1.5)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/autovacuum.c?r1=1.4&r2=1.5)
        checkpoint.c (r1.5 -> r1.6)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/checkpoint.c?r1=1.5&r2=1.6)
        collector.c (r1.8 -> r1.9)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/collector.c?r1=1.8&r2=1.9)
        logger.c (r1.10 -> r1.11)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/logger.c?r1=1.10&r2=1.11)
        logger_out.c (r1.1 -> r1.2)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/logger_out.c?r1=1.1&r2=1.2)
        pg_statsinfo.c (r1.7 -> r1.8)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pg_statsinfo.c?r1=1.7&r2=1.8)
        pg_statsinfo.h (r1.7 -> r1.8)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pg_statsinfo.h?r1=1.7&r2=1.8)
        snapshot.c (r1.9 -> r1.10)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/snapshot.c?r1=1.9&r2=1.10)
        writer.c (r1.9 -> r1.10)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/writer.c?r1=1.9&r2=1.10)
    pg_statsinfo/bin/pgut:
        pgut-pthread.c (r1.2 -> r1.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pgut/pgut-pthread.c?r1=1.2&r2=1.3)
        pgut-pthread.h (r1.1 -> r1.2)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pgut/pgut-pthread.h?r1=1.1&r2=1.2)
        pgut.c (r1.5 -> r1.6)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pgut/pgut.c?r1=1.5&r2=1.6)
        pgut.h (r1.5 -> r1.6)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pgut/pgut.h?r1=1.5&r2=1.6)
    pg_statsinfo/lib:
        libstatsinfo.c (r1.8 -> r1.9)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/libstatsinfo.c?r1=1.8&r2=1.9)
    pg_statsinfo/msvc:
        bin.vcproj (r1.2 -> r1.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/msvc/bin.vcproj?r1=1.2&r2=1.3)

pgsql-committers by date

Next:From: User ItagakiDate: 2010-03-08 05:38:49
Subject: pgstatsinfo - pg_reporter: Move some hacks for win32 ports into msvc
Previous:From: Tom LaneDate: 2010-03-08 01:18:53
Subject: pgsql: Update time zone data files to tzdata release 2010c: DST law

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