./databases/postgresql90-monitoring, PostgreSQL monitoring tools

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


Branch: pkgsrc-2012Q2, Version: 9.0.8, Package name: postgresql90-monitoring-9.0.8, 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.


Required to run:
[databases/postgresql90-client]

Master sites: (Expand)

SHA1: 240d2d45bc87d8cdad8e2b74cf378f5668b604fe
RMD160: fab8564774c99300ca8a69298417eec960e70601
Filesize: 14646.548 KB

Version history: (Expand)


CVS history: (Expand)


   2012-07-04 09:46:11 by Matthias Scheler | Files touched by this commit (20) | Package updated
Log message:
Pullup ticket #3847 - requested by morr
databases/postgresql90: security update
databases/postgresql90-adminpack: security update
databases/postgresql90-client: security update
databases/postgresql90-datatypes: security update
databases/postgresql90-dblink: security update
databases/postgresql90-docs: security update
databases/postgresql90-fuzzystrmatch: security update
databases/postgresql90-monitoring: security update
databases/postgresql90-pgcrypto: security update
databases/postgresql90-plperl: security update
databases/postgresql90-plpython: security update
databases/postgresql90-pltcl: security update
databases/postgresql90-replicationtools: security update
databases/postgresql90-server: security update
databases/postgresql90-upgrade: security update
databases/postgresql90-uuid: security update

Revisions pulled up:
- databases/postgresql90-adminpack/Makefile                     1.6
- databases/postgresql90-client/Makefile                        1.13
- databases/postgresql90-datatypes/Makefile                     1.6
- databases/postgresql90-dblink/Makefile                        1.6
- databases/postgresql90-docs/Makefile                          1.7
- databases/postgresql90-docs/PLIST                             1.10
- databases/postgresql90-fuzzystrmatch/Makefile                 1.5
- databases/postgresql90-monitoring/Makefile                    1.7
- databases/postgresql90-pgcrypto/Makefile                      1.6
- databases/postgresql90-plperl/Makefile                        1.8
- databases/postgresql90-plpython/Makefile                      1.7
- databases/postgresql90-pltcl/Makefile                         1.6
- databases/postgresql90-replicationtools/Makefile              1.4
- databases/postgresql90-server/Makefile                        1.11
- databases/postgresql90-server/PLIST                           1.10
- databases/postgresql90-upgrade/Makefile                       1.6
- databases/postgresql90-uuid/Makefile                          1.3
- databases/postgresql90/Makefile                               1.4
- databases/postgresql90/Makefile.common                        1.18
- databases/postgresql90/distinfo                               1.11

---
   Module Name:	pkgsrc
   Committed By:	morr
   Date:		Sun Jul  1 19:42:08 UTC 2012

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

   Log message:
   Security update to version 9.0.8.

   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)
   * 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 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)
   * 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 WAL replay logic for GIN indexes to not fail if the index was
   subsequently dropped (Tom Lane)
   * 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)
   * 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
   *bjects (Jeff Janes, Tom Lane)
   * 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
   *bjects (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;