Thread: pgstatsinfo - pg_statsinfo: Add manual snapshot with
pgstatsinfo - pg_statsinfo: Add manual snapshot with
From
itagaki@pgfoundry.org (User Itagaki)
Date:
Log Message:
-----------
Add manual snapshot with statsinfo.snapshot('comment').
Add statsinfo.restart() to restart pg_statsinfo daemon when it crashed.
Support application_name activity parameter as 'pg_statsinfo'.
Fix endless retry during sampling.
Force override log_destination because it should not be changed by SIGHUP.
Don't export statfs and readlink as SQL functions for security.
Add limits to retry items in the writer queue not to stack one broken item.
Cleanup codes for windows ports.
Modified Files:
--------------
pg_statsinfo/bin:
collector.c (r1.7 -> r1.8)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/collector.c?r1=1.7&r2=1.8)
logger.c (r1.9 -> r1.10)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/logger.c?r1=1.9&r2=1.10)
pg_statsinfo.c (r1.6 -> r1.7)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pg_statsinfo.c?r1=1.6&r2=1.7)
pg_statsinfo.h (r1.6 -> r1.7)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pg_statsinfo.h?r1=1.6&r2=1.7)
snapshot.c (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/snapshot.c?r1=1.8&r2=1.9)
writer.c (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/writer.c?r1=1.8&r2=1.9)
writer_sql.h (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/writer_sql.h?r1=1.4&r2=1.5)
pg_statsinfo/bin/pgut:
pgut.c (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pgut/pgut.c?r1=1.4&r2=1.5)
pgut.h (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/bin/pgut/pgut.h?r1=1.4&r2=1.5)
pg_statsinfo/lib:
Makefile (r1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/Makefile?r1=1.1&r2=1.2)
libstatsinfo.c (r1.7 -> r1.8)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/libstatsinfo.c?r1=1.7&r2=1.8)
libstatsinfo.h (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/libstatsinfo.h?r1=1.3&r2=1.4)
pg_statsinfo.sql.in (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/pg_statsinfo.sql.in?r1=1.3&r2=1.4)
port.c (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/port.c?r1=1.3&r2=1.4)
pg_statsinfo/lib/pgut:
pgut-be.c (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/pgut/pgut-be.c?r1=1.2&r2=1.3)
pgut-be.h (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/pgut/pgut-be.h?r1=1.3&r2=1.4)
pgut-port.h (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/pgut/pgut-port.h?r1=1.2&r2=1.3)
pg_statsinfo/msvc:
bin.vcproj (r1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/msvc/bin.vcproj?r1=1.1&r2=1.2)
lib.vcproj (r1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/msvc/lib.vcproj?r1=1.1&r2=1.2)
readme.txt (r1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/msvc/readme.txt?r1=1.1&r2=1.2)
Added Files:
-----------
pg_statsinfo:
common.h (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/common.h?rev=1.1&content-type=text/x-cvsweb-markup)
pg_statsinfo/lib/pgut:
readlink.c (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/pgut/readlink.c?rev=1.1&content-type=text/x-cvsweb-markup)
Removed Files:
-------------
pg_statsinfo/lib/pgut:
pgut-port.c
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgstatsinfo/pg_statsinfo/lib/pgut/pgut-port.c)