pgstatsinfo - pg_statsinfo: Support PostgreSQL 8.3 and various fixes.

From: itagaki(at)pgfoundry(dot)org (User Itagaki)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgstatsinfo - pg_statsinfo: Support PostgreSQL 8.3 and various fixes.
Date: 2010-03-10 08:10:02
Message-ID: 20100310081002.9CAC410715D1@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Support PostgreSQL 8.3 and various fixes.
- Fix a bug to determine csvlog filename next to parse.
- Improve statsinfo.restart() to shutdown existing daemon process.
- Collector checks server status before connection to avoid repeated
connection failure during crash or archive recovery.
- Remove 1sec sleep at start and fix many bugs hidden by the sleep.
- Fix logger can write logs for self shutdown log.
- Use server log instead of SQL polling to know when configuration file was
reloaded because 8.3 does not support pg_conf_load_time().
- Add CRC checks for control file.

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

Added Files:
-----------
pg_statsinfo/bin:
pg_control.c (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pg_control.c?rev=1.1&content-type=text/x-cvsweb-markup)
pg_statsinfo/lib:
pg_control.c (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/pg_control.c?rev=1.1&content-type=text/x-cvsweb-markup)

Browse pgsql-committers by date

  From Date Subject
Next Message User Itagaki 2010-03-10 08:27:45 pgbulkload - pgbulkload: Rename ON_DUPLICATE = ERROR | REMOVE_OLD |
Previous Message Takahiro Itagaki 2010-03-10 02:04:49 pgsql: pg_start_backup() can use a share lock to lock ControlFileLock