summaryrefslogtreecommitdiff
path: root/databases/postgresql90-replicationtools
AgeCommit message (Collapse)AuthorFilesLines
2012-10-02Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.asau1-3/+1
2012-07-01Security update to version 9.0.8.morr1-2/+1
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;
2012-06-14Recursive PKGREVISION bump for libxml2 buildlink addition.sbd1-1/+2
2010-12-19Changes 9.0.2:adam2-7/+5
* Force the default wal_sync_method to be fdatasync on Linux * Fix "too many KnownAssignedXids" error during Hot Standby replay * Fix race condition in lock acquisition during Hot Standby * Avoid unnecessary conflicts during Hot Standby * Fix assorted bugs in WAL replay logic for GIN indexes * Fix recovery from base backup when the starting checkpoint WAL record is not in the same WAL segment as its redo point * Fix corner-case bug when streaming replication is enabled immediately after creating the master database cluster * Fix persistent slowdown of autovacuum workers when multiple workers remain active for a long time * Fix long-term memory leak in autovacuum launcher * Avoid failure when trying to report an impending transaction wraparound condition from outside a transaction * Add support for detecting register-stack overrun on IA64 * Add a check for stack overflow in copyObject() * Fix detection of page splits in temporary GiST indexes * Fix error checking during early connection processing * Improve efficiency of window functions * Avoid memory leakage while "ANALYZE"'ing complex index expressions * Ensure an index that uses a whole-row Var still depends on its table * Add missing support in "DROP OWNED BY" for removing foreign data wrapper/server privileges belonging to a user * Do not "inline" a SQL function with multiple OUT parameters * Fix crash when inline-ing a set-returning function whose argument list contains a reference to an inline-able user function * Behave correctly if ORDER BY, LIMIT, FOR UPDATE, or WITH is attached to the VALUES part of INSERT ... VALUES * Make the OFF keyword unreserved This prevents problems with using off as a variable name in PL/pgSQL. That worked before 9.0, but was now broken because PL/pgSQL now treats all core reserved words as reserved. * Fix constant-folding of COALESCE() expressions
2010-12-10Import PostgreSQL 9.0 replication tools as ↵asau3-0/+31
databases/postgresql90-replicationtools This package provides the following PostgreSQL tools: - pg_archivecleanup - pg_standby pg_standby supports creation of a "warm standby" database server. It is designed to be a waiting restore_command, which is needed to turn a standard archive recovery into a warm standby operation. pg_archivecleanup is designed to cleanup an archive when used as an archive_cleanup_command when running with standby_mode = on. pg_archivecleanup can also be used as a standalone program to clean WAL file archives.