PostgreSQL full changelog
PostgreSQL 9.1.2-1
released Dec 6, 2011 (New Release)
· Fix bugs in information_schema.referential_constraints view (Tom Lane). This view was being insufficiently careful about matching the foreign-key constraint to the depended-on primary or unique key constraint. That could result in failure to show a foreign key constraint at all, or showing it multiple times, or claiming that it depends on a different constraint than the one it really does. Since the view definition is installed by initdb, merely upgrading will not fix the problem. If you need to fix this in an existing installation, you can (as a superuser) drop the information_schema schema then re-create it by sourcing SHAREDIR/information_schema.sql. (Run pg_config --sharedir if you're uncertain where SHAREDIR is.) This must be repeated in each database to be fixed.
· Make contrib/citext's upgrade script fix collations of citext columns and indexes (Tom Lane). Existing citext columns.
· Make contrib/citext's upgrade script fix collations of citext columns and indexes (Tom Lane). Existing citext columns.
PostgreSQL 9.1.1-1
released Sep 26, 2011 (New Release)
· Make pg_options_to_table return NULL for an option with no value
· Previously such cases would result in a server crash.
· Fix memory leak at end of a GiST index scan
· Commands that perform many separate GiST index scans, such as verification of a new GiST-based exclusion constraint on a table already containing many rows, could transiently require large amounts of memory due to this leak.
· Fix explicit reference to pg_temp schema in CREATE TEMPORARY TABLE
· Previously such cases would result in a server crash.
· Fix memory leak at end of a GiST index scan
· Commands that perform many separate GiST index scans, such as verification of a new GiST-based exclusion constraint on a table already containing many rows, could transiently require large amounts of memory due to this leak.
· Fix explicit reference to pg_temp schema in CREATE TEMPORARY TABLE
PostgreSQL 9.1.0-1
released Sep 13, 2011 (New Release)
· Allow synchronous replication
· Add support for foreign tables
· Add per-column collation support
· Add extensions which simplify packaging of additions to PostgreSQL
· Add a true serializable isolation level
· Support unlogged tables using the UNLOGGED option in CREATE TABLE
· Allow data-modification commands (INSERT/UPDATE/DELETE) in WITH clauses
· Add nearest-neighbor (order-by-operator) searching to GiST indexes
· Add a SECURITY LABEL command and support for SELinux permissions control
· Update the PL/Python server-side language
· Add support for foreign tables
· Add per-column collation support
· Add extensions which simplify packaging of additions to PostgreSQL
· Add a true serializable isolation level
· Support unlogged tables using the UNLOGGED option in CREATE TABLE
· Allow data-modification commands (INSERT/UPDATE/DELETE) in WITH clauses
· Add nearest-neighbor (order-by-operator) searching to GiST indexes
· Add a SECURITY LABEL command and support for SELinux permissions control
· Update the PL/Python server-side language
PostgreSQL 9.0.4-1
released Apr 18, 2011 (New Release)
Changes:
· Force the default wal_sync_method to be fdatasync on Linux (Tom Lane, Marti Raudsepp)
· The default on Linux has actually been fdatasync for many years, but recent kernel changes caused PostgreSQL to choose open_datasync instead. This choice did not result in any performance improvement, and caused outright failures on certain filesystems, notably ext4 with the data=journal mount option.
· Fix quot;too many KnownAssignedXidsquot; error during Hot Standby replay (Heikki Linnakangas)
· Fix race condition in lock acquisition during Hot Standby (Simon Riggs)
· Avoid unnecessary conflicts during Hot Standby (Simon Riggs)
· This fixes some cases where replay was considered to conflict with standby queries (causing delay of replay or possibly cancellation of the queries), but there was no real conflict.
· Fix assorted bugs in WAL replay logic for GIN indexes (Tom Lane)
· This could result in quot;bad buffer id: 0quot; failures or corruption of index contents during replication.
· Force the default wal_sync_method to be fdatasync on Linux (Tom Lane, Marti Raudsepp)
· The default on Linux has actually been fdatasync for many years, but recent kernel changes caused PostgreSQL to choose open_datasync instead. This choice did not result in any performance improvement, and caused outright failures on certain filesystems, notably ext4 with the data=journal mount option.
· Fix quot;too many KnownAssignedXidsquot; error during Hot Standby replay (Heikki Linnakangas)
· Fix race condition in lock acquisition during Hot Standby (Simon Riggs)
· Avoid unnecessary conflicts during Hot Standby (Simon Riggs)
· This fixes some cases where replay was considered to conflict with standby queries (causing delay of replay or possibly cancellation of the queries), but there was no real conflict.
· Fix assorted bugs in WAL replay logic for GIN indexes (Tom Lane)
· This could result in quot;bad buffer id: 0quot; failures or corruption of index contents during replication.
PostgreSQL 9.0.3-1
released Jan 31, 2011 (New Release)
Changes:
· Force the default wal_sync_method to be fdatasync on Linux (Tom Lane, Marti Raudsepp)
· The default on Linux has actually been fdatasync for many years, but recent kernel changes caused PostgreSQL to choose open_datasync instead. This choice did not result in any performance improvement, and caused outright failures on certain filesystems, notably ext4 with the data=journal mount option.
· Fix quot;too many KnownAssignedXidsquot; error during Hot Standby replay (Heikki Linnakangas)
· Fix race condition in lock acquisition during Hot Standby (Simon Riggs)
· Avoid unnecessary conflicts during Hot Standby (Simon Riggs)
· This fixes some cases where replay was considered to conflict with standby queries (causing delay of replay or possibly cancellation of the queries), but there was no real conflict.
· Fix assorted bugs in WAL replay logic for GIN indexes (Tom Lane)
· This could result in quot;bad buffer id: 0quot; failures or corruption of index contents during replication.
· Force the default wal_sync_method to be fdatasync on Linux (Tom Lane, Marti Raudsepp)
· The default on Linux has actually been fdatasync for many years, but recent kernel changes caused PostgreSQL to choose open_datasync instead. This choice did not result in any performance improvement, and caused outright failures on certain filesystems, notably ext4 with the data=journal mount option.
· Fix quot;too many KnownAssignedXidsquot; error during Hot Standby replay (Heikki Linnakangas)
· Fix race condition in lock acquisition during Hot Standby (Simon Riggs)
· Avoid unnecessary conflicts during Hot Standby (Simon Riggs)
· This fixes some cases where replay was considered to conflict with standby queries (causing delay of replay or possibly cancellation of the queries), but there was no real conflict.
· Fix assorted bugs in WAL replay logic for GIN indexes (Tom Lane)
· This could result in quot;bad buffer id: 0quot; failures or corruption of index contents during replication.
PostgreSQL 9.0.2-1
released Dec 18, 2010 (New Release)
Changes:
· Force the default wal_sync_method to be fdatasync on Linux (Tom Lane, Marti Raudsepp)
· The default on Linux has actually been fdatasync for many years, but recent kernel changes caused PostgreSQL to choose open_datasync instead. This choice did not result in any performance improvement, and caused outright failures on certain filesystems, notably ext4 with the data=journal mount option.
· Fix quot;too many KnownAssignedXidsquot; error during Hot Standby replay (Heikki Linnakangas)
· Fix race condition in lock acquisition during Hot Standby (Simon Riggs)
· Avoid unnecessary conflicts during Hot Standby (Simon Riggs)
· This fixes some cases where replay was considered to conflict with standby queries (causing delay of replay or possibly cancellation of the queries), but there was no real conflict.
· Fix assorted bugs in WAL replay logic for GIN indexes (Tom Lane)
· This could result in quot;bad buffer id: 0quot; failures or corruption of index contents during replication.
· Force the default wal_sync_method to be fdatasync on Linux (Tom Lane, Marti Raudsepp)
· The default on Linux has actually been fdatasync for many years, but recent kernel changes caused PostgreSQL to choose open_datasync instead. This choice did not result in any performance improvement, and caused outright failures on certain filesystems, notably ext4 with the data=journal mount option.
· Fix quot;too many KnownAssignedXidsquot; error during Hot Standby replay (Heikki Linnakangas)
· Fix race condition in lock acquisition during Hot Standby (Simon Riggs)
· Avoid unnecessary conflicts during Hot Standby (Simon Riggs)
· This fixes some cases where replay was considered to conflict with standby queries (causing delay of replay or possibly cancellation of the queries), but there was no real conflict.
· Fix assorted bugs in WAL replay logic for GIN indexes (Tom Lane)
· This could result in quot;bad buffer id: 0quot; failures or corruption of index contents during replication.
PostgreSQL 9.0.1-1
released Oct 4, 2010 (New Release)
Use a separate interpreter for each calling SQL userid in PL/Perl and PL/Tcl:
· This change prevents security problems that can be caused by subverting Perl or Tcl code that will be executed later in the same session under another SQL user identity (for example, within a SECURITY DEFINER function). Most scripting languages offer numerous ways that that might be done, such as redefining standard functions or operators called by the target function. Without this change, any SQL user with Perl or Tcl language usage rights can do essentially anything with the SQL privileges of the target function's owner.
· The cost of this change is that intentional communication among Perl and Tcl functions becomes more difficult. To provide an escape hatch, PL/PerlU and PL/TclU functions continue to use only one interpreter per session. This is not considered a security issue since all such functions execute at the trust level of a database superuser already.
· This change prevents security problems that can be caused by subverting Perl or Tcl code that will be executed later in the same session under another SQL user identity (for example, within a SECURITY DEFINER function). Most scripting languages offer numerous ways that that might be done, such as redefining standard functions or operators called by the target function. Without this change, any SQL user with Perl or Tcl language usage rights can do essentially anything with the SQL privileges of the target function's owner.
· The cost of this change is that intentional communication among Perl and Tcl functions becomes more difficult. To provide an escape hatch, PL/PerlU and PL/TclU functions continue to use only one interpreter per session. This is not considered a security issue since all such functions execute at the trust level of a database superuser already.
PostgreSQL 8.4.4-1
released May 17, 2010 (New Release)
· Add new configuration parameter ssl_renegotiation_limit to control how often we do session key renegotiation for an SSL connection (Magnus)
· This can be set to zero to disable renegotiation completely, which may be required if a broken SSL library is used. In particular, some vendors are shipping stopgap patches for CVE-2009-3555 that cause renegotiation attempts to fail.
· Fix possible deadlock during backend startup (Tom)
· Fix possible crashes due to not handling errors during relcache reload cleanly (Tom)
· Fix possible crash due to use of dangling pointer to a cached plan (Tatsuo)
· Fix possible crash due to overenthusiastic invalidation of cached plan for ROLLBACK (Tom)
· Fix possible crashes when trying to recover from a failure in subtransaction start (Tom)
· Fix server memory leak associated with use of savepoints and a client encoding different from server's encoding (Tom)
· This can be set to zero to disable renegotiation completely, which may be required if a broken SSL library is used. In particular, some vendors are shipping stopgap patches for CVE-2009-3555 that cause renegotiation attempts to fail.
· Fix possible deadlock during backend startup (Tom)
· Fix possible crashes due to not handling errors during relcache reload cleanly (Tom)
· Fix possible crash due to use of dangling pointer to a cached plan (Tatsuo)
· Fix possible crash due to overenthusiastic invalidation of cached plan for ROLLBACK (Tom)
· Fix possible crashes when trying to recover from a failure in subtransaction start (Tom)
· Fix server memory leak associated with use of savepoints and a client encoding different from server's encoding (Tom)
PostgreSQL 8.4.3-1
released Apr 27, 2010 (New Release)
#Add new configuration parameter ssl_renegotiation_limit to control how often we do session key renegotiation for an SSL connection (Magnus)
This can be set to zero to disable renegotiation completely, which may be required if a broken SSL library is used. In particular, some vendors are shipping stopgap patches for CVE-2009-3555 that cause renegotiation attempts to fail.
#Fix possible deadlock during backend startup (Tom)
#Fix possible crashes due to not handling errors during relcache reload cleanly (Tom)
#Fix possible crash due to use of dangling pointer to a cached plan (Tatsuo)
#Fix possible crash due to overenthusiastic invalidation of cached plan for ROLLBACK (Tom)
#Fix possible crashes when trying to recover from a failure in subtransaction start (Tom)
#Fix server memory leak associated with use of savepoints and a client encoding different from server's encoding (Tom)
This can be set to zero to disable renegotiation completely, which may be required if a broken SSL library is used. In particular, some vendors are shipping stopgap patches for CVE-2009-3555 that cause renegotiation attempts to fail.
#Fix possible deadlock during backend startup (Tom)
#Fix possible crashes due to not handling errors during relcache reload cleanly (Tom)
#Fix possible crash due to use of dangling pointer to a cached plan (Tatsuo)
#Fix possible crash due to overenthusiastic invalidation of cached plan for ROLLBACK (Tom)
#Fix possible crashes when trying to recover from a failure in subtransaction start (Tom)
#Fix server memory leak associated with use of savepoints and a client encoding different from server's encoding (Tom)
PostgreSQL 8.4.2-1
released Dec 14, 2009 (New Release)
Protect against indirect security threats caused by index functions changing session-local state (Gurjeet Singh, Tom)
This change prevents allegedly-immutable index functions from possibly subverting a superuser's session (CVE-2009-4136).
Reject SSL certificates containing an embedded null byte in the common name (CN) field (Magnus)
This prevents unintended matching of a certificate to a server or client name during SSL validation (CVE-2009-4034).
Fix hash index corruption (Tom)
The 8.4 change that made hash indexes keep entries sorted by hash value failed to update the bucket splitting and compaction routines to preserve the ordering. So application of either of those operations could lead to permanent corruption of an index, in the sense that searches might fail to find entries that are present. To deal with this, it is recommended to REINDEX any hash indexes you may have after installing this update.
This change prevents allegedly-immutable index functions from possibly subverting a superuser's session (CVE-2009-4136).
Reject SSL certificates containing an embedded null byte in the common name (CN) field (Magnus)
This prevents unintended matching of a certificate to a server or client name during SSL validation (CVE-2009-4034).
Fix hash index corruption (Tom)
The 8.4 change that made hash indexes keep entries sorted by hash value failed to update the bucket splitting and compaction routines to preserve the ordering. So application of either of those operations could lead to permanent corruption of an index, in the sense that searches might fail to find entries that are present. To deal with this, it is recommended to REINDEX any hash indexes you may have after installing this update.
PostgreSQL for Windows 7 - free download notice
Windows 7 Download periodically updates software information of PostgreSQL from the publisher.
« BACK
My Account
My Saved Stuff
Windows 7
Download Remove
My SUDOKU 1.62
Download Remove
Easy Mail 3.1.62
Download Remove
RealGrade 5.3.0
Download Remove
NetSetMan 3.1.0
Download Remove
PilotEdit 5.1.0
Download Remove
Easy Time 5.1
Download Remove
RivaTuner 2.24c
Download Remove
VideoMach 5.5.3
Download Remove
LockCrypt 3.10
Download Remove
DiskSizes 1.6
Download Remove
jetAudio 8.0.16
Download Remove
Royal TS 1.7.3.1000
Download Remove
Notepad++ 5.9.8
Download Remove
Diff Doc 3.843
Download Remove
uuDeJava 1.02
Download Remove
PWMinder 2.6.4
Download Remove
dwgPlotX 2.2.1
Download Remove
MPS Lens 1.5.5.8
Download Remove
ConcaDec 3.0
Download Remove
3DP Chip 12.01
Download Remove
Turbo C++ 3.0
Download Remove
Obsidium 1.4.5 Build 27
Download Remove
Freegate 7.25
Download Remove
NKRemote 2.3.2
Download Remove
VocaTalk 1.0.17 Beta
Download Remove
DSPlayer 0.889 lite
Download Remove
Fresh UI 8.80
Download Remove
cPicture 2.6.0
Download Remove
FlashFXP 4.1.8.1701
Download Remove
goScreen 8.0.2.424
Download Remove
Sanvient 1.0.20
Download Remove
BestSync 7.0.23
Download Remove
PhoneMGR 2.1
Download Remove
PNotes 8.5.106
Download Remove
SyMenu 1.14
Download Remove
WinZip 16.0.9661
Download Remove
IZArc 4.1.6
Download Remove
Quobi 2.0.1.4
Download Remove
Yascu 1.0.525
Download Remove
Wally 2.4.4
Download Remove
ARJ32 3.15
Download Remove
OkMap 10.4.1
Download Remove
uuSpy 1.11
Download Remove
iCopy 1.48
Download Remove
APlus 12.013
Download Remove
DSSF3 5.1.x.x
Download Remove
vLog 3.59
Download Remove
jFtp 1.54
Download Remove
Ares 2.1.8.3042
Download Remove
SIW 2011 1029
Download Remove
Download Remove
My SUDOKU 1.62
Download Remove
Easy Mail 3.1.62
Download Remove
RealGrade 5.3.0
Download Remove
NetSetMan 3.1.0
Download Remove
PilotEdit 5.1.0
Download Remove
Easy Time 5.1
Download Remove
RivaTuner 2.24c
Download Remove
VideoMach 5.5.3
Download Remove
LockCrypt 3.10
Download Remove
DiskSizes 1.6
Download Remove
jetAudio 8.0.16
Download Remove
Royal TS 1.7.3.1000
Download Remove
Notepad++ 5.9.8
Download Remove
Diff Doc 3.843
Download Remove
uuDeJava 1.02
Download Remove
PWMinder 2.6.4
Download Remove
dwgPlotX 2.2.1
Download Remove
MPS Lens 1.5.5.8
Download Remove
ConcaDec 3.0
Download Remove
3DP Chip 12.01
Download Remove
Turbo C++ 3.0
Download Remove
Obsidium 1.4.5 Build 27
Download Remove
Freegate 7.25
Download Remove
NKRemote 2.3.2
Download Remove
VocaTalk 1.0.17 Beta
Download Remove
DSPlayer 0.889 lite
Download Remove
Fresh UI 8.80
Download Remove
cPicture 2.6.0
Download Remove
FlashFXP 4.1.8.1701
Download Remove
goScreen 8.0.2.424
Download Remove
Sanvient 1.0.20
Download Remove
BestSync 7.0.23
Download Remove
PhoneMGR 2.1
Download Remove
PNotes 8.5.106
Download Remove
SyMenu 1.14
Download Remove
WinZip 16.0.9661
Download Remove
IZArc 4.1.6
Download Remove
Quobi 2.0.1.4
Download Remove
Yascu 1.0.525
Download Remove
Wally 2.4.4
Download Remove
ARJ32 3.15
Download Remove
OkMap 10.4.1
Download Remove
uuSpy 1.11
Download Remove
iCopy 1.48
Download Remove
APlus 12.013
Download Remove
DSSF3 5.1.x.x
Download Remove
vLog 3.59
Download Remove
jFtp 1.54
Download Remove
Ares 2.1.8.3042
Download Remove
SIW 2011 1029
Download Remove
Would you like to receive announcements of new versions of your software by email or by RSS reader? Register for FREE!
Windows 7 Downloads Picks
- MDB Viewer Plus 2.08
- PostgreSQL 9.1.2-1
- Ant Access Viewer 1.1.3
- TextPipe Pro 9.0
- FileMaker Pro 11v3
- FlameRobin 0.9.3.1924
- Data Architect 4.2.0
- Data Management Center 2.1.0.0
- Data Guardian 2.1.0
- Service Master 8.8.25
- Medix Doctor 1.0
- SQL Server Comparison Expert 2.6.1
- LightProfiler 0.7.00
- Essential SQL 1.6
Popular Tags
oracle
query
converter
excel
ems
software
export
primary
dictionary
migrate
access
conversion
dbf
sql server
sql
odbc
development
server
tool
sqlmanager
mysql
mssql
convert
table
gui
import
translation memories
data
database
utility
Popular Windows 7 Software
- Microsoft Office 2003
- TeamViewer 7.0.12541
- Microsoft Office 2007
- TickNTick 1.0.1.114
- Microsoft Office 2010 x32 14.0 BETA
- Microsoft PowerPoint 2010 14.0.4760.1000
- CrossGL Surface Calculator 1.10
- Sticky Notes 2012.36
- Microsoft Office 2010 x64 14.0.6023.1000
- Sticky Notes Free 6.3
- QR Code Software 3.0.3.3
- Window Gadgets Calculator 1.1
- Microsoft Office 2010 14.0.6023.1000
- LaTex Equation Editor 1.01
- OpenOffice.org 3.3.0
© 2012 Windows7Download.com - All logos, trademarks, art and other creative works are and remain copyright and property of their respective owners. Microsoft Windows is a registered trademarks of Microsoft Corporation. Microsoft Corporation in no way endorses or is affiliated with windows7download.com.