Path to this page:
./
databases/postgresql91-monitoring,
PostgreSQL monitoring tools
Branch: pkgsrc-2012Q2,
Version: 9.1.4,
Package name: postgresql91-monitoring-9.1.4,
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.
Master sites: (Expand)
SHA1: c75fd5696af02a275a104260eac8b3a4abe35682
RMD160: ff08ad702c7ffc0172b3f66aa4819d4865f0e77b
Filesize: 15265.521 KB
Version history: (Expand)
- (2012-07-05) Package added to pkgsrc.se, version postgresql91-monitoring-9.1.4 (created)
CVS history: (Expand)
2012-07-04 01:23:09 by Matthias Scheler | Files touched by this commit (19) | |
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;
|