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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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)

Browse pgsql-committers by date

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