./databases/postgresql91-monitoring, PostgreSQL monitoring tools

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: pkgsrc-2012Q2, Version: 9.1.4, Package name: postgresql91-monitoring-9.1.4, Maintainer: adam

This package provides the following PostgreSQL modules:
- auto_explain
- pg_buffercache
- pg_stat_statements
- pgstattuple

The "auto_explain" module provides a means for logging execution
plans of slow statements automatically, without having to run
EXPLAIN(7) by hand. This is especially helpful for tracking down
un-optimized queries in large applications.

The "pg_buffercache" module provides a means for examining what's
happening in the shared buffer cache in real time.

The "pg_stat_statements" module provides a means for tracking
execution statistics of all SQL statements executed by a server.

The "pgstattuple" module provides various functions to obtain
tuple-level statistics.


Master sites: (Expand)

SHA1: c75fd5696af02a275a104260eac8b3a4abe35682
RMD160: ff08ad702c7ffc0172b3f66aa4819d4865f0e77b
Filesize: 15265.521 KB

Version history: (Expand)


CVS history: (Expand)


   2012-07-04 01:23:09 by Matthias Scheler | Files touched by this commit (19) | Package updated
Log message:
Pullup ticket #3844 - requested by morr
databases/postgresql91: security update
databases/postgresql91-adminpack: security update
databases/postgresql91-client: security update
databases/postgresql91-datatypes: security update
databases/postgresql91-dblink: security update
databases/postgresql91-docs: security update
databases/postgresql91-fuzzystrmatch: security update
databases/postgresql91-monitoring: security update
databases/postgresql91-pgcrypto: security update
databases/postgresql91-plperl: security update
databases/postgresql91-plpython: security update
databases/postgresql91-pltcl: security update
databases/postgresql91-replicationtools: security update
databases/postgresql91-server: security update
databases/postgresql91-upgrade: security update

Revisions pulled up:
- databases/postgresql91-adminpack/Makefile                     1.3
- databases/postgresql91-client/Makefile                        1.7
- databases/postgresql91-datatypes/Makefile                     1.3
- databases/postgresql91-dblink/Makefile                        1.3
- databases/postgresql91-docs/Makefile                          1.3
- databases/postgresql91-docs/PLIST                             1.6
- databases/postgresql91-fuzzystrmatch/Makefile                 1.3
- databases/postgresql91-monitoring/Makefile                    1.3
- databases/postgresql91-pgcrypto/Makefile                      1.3
- databases/postgresql91-plperl/Makefile                        1.3
- databases/postgresql91-plpython/Makefile                      1.4
- databases/postgresql91-pltcl/Makefile                         1.3
- databases/postgresql91-replicationtools/Makefile              1.3
- databases/postgresql91-server/Makefile                        1.3
- databases/postgresql91-server/PLIST                           1.5
- databases/postgresql91-upgrade/Makefile                       1.3
- databases/postgresql91/Makefile                               1.3
- databases/postgresql91/Makefile.common                        1.7
- databases/postgresql91/distinfo                               1.6

---
   Module Name:	pkgsrc
   Committed By:	morr
   Date:		Sun Jul  1 19:49:26 UTC 2012

   Modified Files:
   	pkgsrc/databases/postgresql91: Makefile Makefile.common distinfo
   	pkgsrc/databases/postgresql91-adminpack: Makefile
   	pkgsrc/databases/postgresql91-client: Makefile
   	pkgsrc/databases/postgresql91-datatypes: Makefile
   	pkgsrc/databases/postgresql91-dblink: Makefile
   	pkgsrc/databases/postgresql91-docs: Makefile PLIST
   	pkgsrc/databases/postgresql91-fuzzystrmatch: Makefile
   	pkgsrc/databases/postgresql91-monitoring: Makefile
   	pkgsrc/databases/postgresql91-pgcrypto: Makefile
   	pkgsrc/databases/postgresql91-plperl: Makefile
   	pkgsrc/databases/postgresql91-plpython: Makefile
   	pkgsrc/databases/postgresql91-pltcl: Makefile
   	pkgsrc/databases/postgresql91-replicationtools: Makefile
   	pkgsrc/databases/postgresql91-server: Makefile PLIST
   	pkgsrc/databases/postgresql91-upgrade: Makefile

   Log message:
   Security update to version 9.1.4.

   Changes:

   * Fix incorrect password transformation in contrib/pgcrypto's DES crypt()
   function (Solar Designer)
   * Ignore SECURITY DEFINER and SET attributes for a procedural language's call
   handler (Tom Lane)
   * Make contrib/citext's upgrade script fix collations of citext arrays and
   domains over citext (Tom Lane)
   * Allow numeric timezone offsets in timestamp input to be up to 16 hours away
   from UTC (Tom Lane)
   * Fix timestamp conversion to cope when the given time is exactly the last DST
   transition time for the current timezone (Tom Lane)
   * Fix text to name and char to name casts to perform string truncation
   correctly in multibyte encodings (Karl Schnaitter)
   * Fix memory copying bug in to_tsquery() (Heikki Linnakangas)
   * Ensure txid_current() reports the correct epoch when executed in hot standby
   (Simon Riggs)
   * Fix planner's handling of outer PlaceHolderVars within subqueries (Tom Lane)
   * Fix planning of UNION ALL subqueries with output columns that are not simple
   variables (Tom Lane)
   * Fix slow session startup when pg_attribute is very large (Tom Lane)
   * Ensure sequential scans check for query cancel reasonably often (Merlin
   Moncure)
   * Ensure the Windows implementation of PGSemaphoreLock() clears
   ImmediateInterruptOK before returning (Tom Lane)
   * Show whole-row variables safely when printing views or rules (Abbas Butt, Tom
   Lane)
   * Fix COPY FROM to properly handle null marker strings that correspond to
   invalid encoding (Tom Lane)
   * Fix EXPLAIN VERBOSE for writable CTEs containing RETURNING clauses (Tom Lane)
   * Fix PREPARE TRANSACTION to work correctly in the presence of advisory locks
   (Tom Lane)
   * Fix truncation of unlogged tables (Robert Haas)
   * Ignore missing schemas during non-interactive assignments of search_path (Tom
   Lane)
   * Fix bugs with temporary or transient tables used in extension scripts (Tom
   Lane)
   * Ensure autovacuum worker processes perform stack depth checking properly
   (Heikki Linnakangas)
   * Fix logging collector to not lose log coherency under high load (Andrew
   Dunstan)
   * Fix logging collector to ensure it will restart file rotation after receiving
   SIGHUP (Tom Lane)
   * Fix "too many LWLocks taken" failure in GiST indexes (Heikki \ 
Linnakangas)
   * Fix WAL replay logic for GIN indexes to not fail if the index was
   subsequently dropped (Tom Lane)
   * Correctly detect SSI conflicts of prepared transactions after a crash (Dan
   Ports)
   * Avoid synchronous replication delay when committing a transaction that only
   modified temporary tables (Heikki Linnakangas)
   * Fix error handling in pg_basebackup (Thomas Ogrisegg, Fujii Masao)
   * Fix walsender to not go into a busy loop if connection is terminated (Fujii
   Masao)
   * Fix memory leak in PL/pgSQL's RETURN NEXT command (Joe Conway)
   * Fix PL/pgSQL's GET DIAGNOSTICS command when the target is the function's
   first variable (Tom Lane)
   * Ensure that PL/Perl package-qualifies the _TD variable (Alex Hunsaker)
   * Fix PL/Python functions returning composite types to accept a string for
   their result value (Jan Urbanski)
   * Fix potential access off the end of memory in psql's expanded display (\x)
   mode (Peter Eisentraut)
   * Fix several performance problems in pg_dump when the database contains many
   objects (Jeff Janes, Tom Lane)
   * Fix memory and file descriptor leaks in pg_restore when reading a
   directory-format archive (Peter Eisentraut)
   * Fix pg_upgrade for the case that a database stored in a non-default
   tablespace contains a table in the cluster's default tablespace (Bruce Momjian)
   * In ecpg, fix rare memory leaks and possible overwrite of one byte after the
   sqlca_t structure (Peter Eisentraut)
   * Fix contrib/dblink's dblink_exec() to not leak temporary database connections
   upon error (Tom Lane)
   * Fix contrib/dblink to report the correct connection name in error messages
   (Kyotaro Horiguchi)
   * Fix contrib/vacuumlo to use multiple transactions when dropping many large
   objects (Tim Lewis, Robert Haas, Tom Lane)
   * Update time zone data files to tzdata release 2012c for DST law changes in
   Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron,
   Morocco, Syria, and Tokelau Islands;