PostgreSQL Icon

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQLOverview

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP.

NEW

# Changes
* Prevent access to external files/URLs via XML entity references
* Prevent access to external files/URLs via contrib/xml2's xslt_process()
* Prevent too-early recycling of btree index pages
* Fix crash-safety bug with newly-created-or-reset sequences
* Fix race condition in enum-type value comparisons
* Fix txid_current() to report the correct epoch when not in hot standby
* Prevent selection of unsuitable replication connections as the synchronous standby
* Fix bug in startup of Hot Standby when a master transaction has many subtransactions
* Ensure the backup_label file is fsync'd after pg_start_backup()
* Fix timeout handling in walsender processes
* Wake walsenders after each background flush by walwriter
* Fix LISTEN/NOTIFY to cope better with I/O problems, such as out of disk space
* Only allow autovacuum to be auto-canceled by a directly blocked process
* Improve logging of autovacuum cancels
* Fix log collector so that log_truncate_on_rotation works during the very first log rotation after server start
* Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT)
* Ensure that a whole-row reference to a subquery doesn't include any extra GROUP BY or ORDER BY columns
* Fix dependencies generated during ALTER TABLE ... ADD CONSTRAINT USING INDEX
* Fix REASSIGN OWNED to work on extensions
* Disallow copying whole-row references in CHECK constraints and index definitions during CREATE TABLE
* Fix memory leak in ARRAY(SELECT ...) subqueries
* Fix planner to pass correct collation to operator selectivity estimators
* Fix extraction of common prefixes from regular expressions
* Fix bugs with parsing signed hh:mm and hh:mm:ss fields in interval constants
* Fix pg_dump to better handle views containing partial GROUP BY lists
* In PL/Perl, avoid setting UTF8 flag when in SQL_ASCII encoding
* Use Postgres' encoding conversion functions, not Python's, when converting a Python Unicode string to the server encoding in PL/Python
* Fix mapping of PostgreSQL encodings to Python encodings in PL/Python
* Report errors properly in contrib/xml2's xslt_process()
* Update time zone data files to tzdata release 2012e for DST law changes in Morocco and Tokelau

PostgreSQLInformation

Version
9.1.5
Date
08.20.12
License
Free
Language
English
File Size
46.26MB
Category
SubCategory
Operating Systems
Windows (All Versions)
System Requirements
No additional system requirements.
MySQL Query Browser Icon
The easiest visual tool for creating, executing, and optimizing SQL queries
Free
SQL Dumper Icon
Allows dumping a SQL Server Database to a text file
Free
Statement Tracer for Oracle Icon
A free solution for debugging programs interfacing with the Oracle RDBMS.
Free
One-Click SQL Restore Icon
This simple free tool restores full MS SQL server database backups.
Free
InterBase 2007 Server for Windows Icon
a relational database management system
Trial
FastReport.Net Icon
Powerful and flexible net reports generator with visual report designer
Trial
JumpStart Icon
Database initialization system for SQL Server.
Demo
Navicat for MySQL Icon
Create and browse MySQL databases, run SQL queries, or build reports.
Demo
More