Path to this page:
./
databases/postgresql90-monitoring,
PostgreSQL monitoring tools
Branch: pkgsrc-2012Q2,
Version: 9.0.8,
Package name: postgresql90-monitoring-9.0.8,
Maintainer: adamThis 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)
- (2012-07-05) Package added to pkgsrc.se, version postgresql90-monitoring-9.0.8 (created)
CVS history: (Expand)
2012-07-04 09:46:11 by Matthias Scheler | Files touched by this commit (20) | |
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;
|