NOTICE: This package has been removed from pkgsrc

./databases/postgresql93-monitoring, PostgreSQL monitoring tools

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ]


Branch: CURRENT, Version: 9.3.12, Package name: postgresql93-monitoring-9.3.12, 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/postgresql93-server] [databases/postgresql93-client]

Master sites:

SHA1: bef0af2df93129be4736632519f5e1a1dc62c9e3
RMD160: 8c2a262274b0178b9ba69d414ee4c801acc6d799
Filesize: 16653.081 KB

Version history: (Expand)


CVS history: (Expand)


   2016-06-19 23:09:58 by Filip Hajny | Files touched by this commit (122) | Package removed
Log message:
Remove PostgreSQL split-up contrib packages, now replaced by
single postgresql9[1-5]-contrib packages. OK by adam@.
   2016-04-09 14:51:50 by Adam Ciarcinski | Files touched by this commit (90) | Package updated
Log message:
The PostgreSQL Global Development Group has released an update to all supported \ 
versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and \ 
9.1.21. This release fixes two security issues and one index corruption issue in \ 
version 9.5. It also contains a variety of bug fixes for earlier versions. Users \ 
of PostgreSQL 9.5.0 or 9.5.1 should update as soon as possible.

This release closes security hole CVE-2016-2193, where a query plan might get \ 
reused for more than one ROLE in the same session. This could cause the wrong \ 
set of Row Level Security (RLS) policies to be used for the query.

The update also fixes CVE-2016-3065, a server crash bug triggered by using \ 
pageinspect with BRIN index pages. Since an attacker might be able to expose a \ 
few bytes of server memory, this crash is being treated as a security issue.
   2016-03-05 12:29:49 by Jonathan Perkin | Files touched by this commit (1813)
Log message:
Bump PKGREVISION for security/openssl ABI bump.
   2014-03-27 21:57:55 by Adam Ciarcinski | Files touched by this commit (16) | Package updated
Log message:
This minor release fixes a data corruption issue with replication and crash \ 
recovery in version 9.3, as well as several other minor issues in all versions. \ 
All users of version 9.3 are urged to update their installations at the next \ 
possible downtime. Users of older versions should update at their convenience.

The data corruption issue in PostgreSQL 9.3 affects binary replication standbys, \ 
servers being recovered from point-in-time-recovery backup, and standalone \ 
servers which recover from a system crash. The bug causes unrecoverable index \ 
corruption during recovery due to incorrect replay of row locking operations. \ 
This can then cause query results to be inconsistent depending on whether or not \ 
an index is used, and eventually lead to primary key violations and similar \ 
issues. For this reason, users are encouraged to replace each of their standby \ 
databases with a new base backup after applying the update.

Other PostgreSQL 9.3-only fixes in this update include:

Make sure that statistics files for dropped databases get deleted
Allow materialized views to be referenced in UPDATE and DELETE queries
Add read-only data_checksum parameter
Prevent erroneous operator push-down in postgres_fdw

This release resolves some other issues in all versions of PostgreSQL, including:
Fix timing consistency issue with NOTIFY
Allow regular expression execution to be cancelled
Improve performance of index checks for newly added rows
Prevent premature walsender disconnection
Prevent memory errors on newer Windows versions
Update timezone files
   2014-03-13 15:57:20 by Jonathan Perkin | Files touched by this commit (2)
Log message:
Build and install pg_test_timing.  Bump PKGREVISION.
   2014-02-23 12:25:54 by Adam Ciarcinski | Files touched by this commit (89) | Package updated
Log message:
Changes:
This update fixes CVE-2014-0060, in which PostgreSQL did not properly enforce \ 
the WITH ADMIN OPTION permission for ROLE management.
This update also fixes some issues which affect binary replication and row \ 
locking, and can cause recoverable data corruption in some cases.
In addition to the above, the following issues are fixed in this release:

Fix WAL logging of visibility map change
Make sure that GIN indexes log all insertions
Get pause_at_recovery_target to pause at correct time
Ensure walreceiver sends hot-standby feedback messages on time
Prevent timeout interrupts from taking control away from mainline code
Eliminate several race conditions
Fix some broken HINTs in error messages
Prevent server lockup on SSL connection loss
Fix two Unicode handling issues
Prevent crash on certain subselect syntax
Prevent crash on select from zero column table
Fix two bugs with LATERAL
Fix issue with UNION ALL, partitioning, and updates
Ensure that ANALYZE understands domains over ranges
Eliminate permissions check when using default tablespace
Fix memory leakage in JSON functions
Allow extensions with event triggers
Distinguish numbers correctly in JSON output
Fix permissions for pg_start_backup() and pg_stop_backup()
Accept SHIFT_JIS as locale name
Fix .* expansion for SQL function variables
Prevent infinite loop on some COPY connection failures
Several fixes for client issues on Windows
Enable building PostgreSQL with Visual Studio 2013
Update time zone files for recent changes
   2014-02-13 00:18:57 by Matthias Scheler | Files touched by this commit (1568)
Log message:
Recursive PKGREVISION bump for OpenSSL API version bump.
   2013-09-10 17:32:33 by Adam Ciarcinski | Files touched by this commit (72) | Package updated
Log message:
Major enhancements in PostgreSQL 9.3 include:
* Add materialized views
* Make simple views auto-updatable
* Add many features for the JSON data type, including operators and functions to \ 
extract elements from JSON values
* Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls
* Allow foreign data wrappers to support writes (inserts/updates/deletes) on \ 
foreign tables
* Add a Postgres foreign data wrapper to allow access to other Postgres servers
* Add support for event triggers
* Add optional ability to checksum data pages and report corruption
* Prevent non-key-field row updates from blocking foreign key checks
* Greatly reduce System V shared memory requirements