NOTICE: This package has been removed from pkgsrc

./databases/postgresql84-client, PostgreSQL database client programs

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


Branch: CURRENT, Version: 8.4.22nb1, Package name: postgresql84-client-8.4.22nb1, Maintainer: adam

PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
derived from the Berkeley Postgres database management system. While
PostgreSQL retains the powerful object-relational data model, rich data types
and easy extensibility of Postgres, it replaces the PostQuel query language
with an extended subset of SQL.

PostgreSQL is free and the complete source is available.

This package contains the database client programs.


Required to run:
[devel/readline]

Master sites:

SHA1: 66a1286c4983121af35b76c97b97288013edc151
RMD160: c46d1fd3405150f0ed25012dad1ef8110d2c2d64
Filesize: 14308.332 KB

Version history: (Expand)


CVS history: (Expand)


   2015-06-12 12:52:19 by Thomas Klausner | Files touched by this commit (3152)
Log message:
Recursive PKGREVISION bump for all packages mentioning 'perl',
having a PKGNAME of p5-*, or depending such a package,
for perl-5.22.0.
   2014-07-26 00:14:57 by Adam Ciarcinski | Files touched by this commit (44) | Package updated
Log message:
The PostgreSQL Global Development Group has released an update to all supported \ 
version of the database system, including versions 9.3.5, 9.2.9, 9.1.14, 9.0.18, \ 
and 8.4.22. This minor release fixes a number of issues discovered and reported \ 
by users over the last four months, including some data corruption issues, and \ 
is the last update of version 8.4. Users of version 9.3 will want to update at \ 
the earliest opportunity; users of version 8.4 will want to schedule an upgrade \ 
to a supported PostgreSQL version.
   2014-05-30 01:38:20 by Thomas Klausner | Files touched by this commit (3049)
Log message:
Bump for perl-5.20.0.
Do it for all packages that
* mention perl, or
* have a directory name starting with p5-*, or
* depend on a package starting with p5-
like last time, for 5.18, where this didn't lead to complaints.
Let me know if you have any this time.
   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-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-12-10 23:32:57 by Adam Ciarcinski | Files touched by this commit (33) | Package updated
Log message:
The PostgreSQL Global Development Group has released a critical update to all \ 
supported versions of the PostgreSQL database system, which includes minor \ 
versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This update fixes three \ 
serious data-loss bugs affecting replication and database maintenance. All users \ 
are urged to update their installations at the earliest opportunity.

The replication issue affects some users of PostgreSQL binary replication, and \ 
can cause minor data loss between the master and the standby. While not all \ 
users are affected, it is difficult to predict when the bug will occur, so we \ 
urge all users of replication and continuous backup (PITR) to update \ 
immediately. Additionally, users who had replication running under PostgreSQL \ 
minor versions 9.3.0, 9.3.1, 9.2.5, 9.1.10, or 9.0.14 should plan to take a \ 
fresh base backup of each standby after update, in order to ensure no prior data \ 
corruption already exists.

This release also fixes two timing issues with VACUUM, which can cause old, \ 
overwritten or deleted rows to re-appear at a later date under some \ 
circumstances. Users with very high transaction rates, particularly those who \ 
experience "transaction ID wraparound" every few weeks or less, are \ 
the most at risk for this issue. Those users should set vacuum_freeze_table_age \ 
to 0, and run a database-wide VACUUM after the update. The second of the two \ 
VACUUM issues affects only 9.3, making it expecially important for 9.3 users to \ 
update.
   2013-12-03 00:08:55 by Benny Siegert | Files touched by this commit (8)
Log message:
Now all of the postgresql packages should compile on MirBSD.