Datanamic is pleased to announce the release of DeZign for Databases V7.0, its data modeling tool. New features include a pan and zoom window, easier navigation between entities, custom comparison rules when comparing a data model and a database, improved code editor, and new advanced search and replace functionality. And, much more...

With the new features, DeZign for Databases V7 delivers dramatic increases in productivity for database designers with a complete toolset to model, maintain, generate and capture the database design and requirements of databases.

New features in DeZign for Databases V7 include:

• Birds-eye view of diagrams (Pan and zoom window)
• Fine-tune the schema/model comparison engine with custom comparison rules
• Global search and replace in selected properties
• Display indexes in your diagram
• Easier navigation between entities
• Hide attributes
• Jump to related objects
• Find and manage object occurrences in diagrams
• Automatically create subdiagrams for each schema
• Improved code editor
• Extended docking support
• Select objects to compare
• Preview SQL
• Select objects to add to your project

More details about the new features can be found on DeZign for Databases' What's New page:

[HTML_REMOVED]http://www.datanamic.com/dezign/whatsnew.html[HTML_REMOVED]

The PostgreSQL Global Development Group today released security updates for all active branches of the PostgreSQL object-relational database system, including versions 9.1.3, 9.0.7, 8.4.11 and 8.3.18.

Users of pg_dump, users of SSL certificates for validation or users of triggers using SECURITY DEFINER should upgrade their installations immediately. All other database administrators are urged to upgrade your version of PostgreSQL at the next scheduled downtime. More details on the security fixes are included below.

Features affected by bug fixes in this update include: binary replication and hot standby, GIN, WITH, foreign data wrappers, PL/pgsql, PL/python, inet datatype, intarray, pgcrypto, pg_upgrade, pg_restore and pg_dump. Users of these features should apply the updates as soon as possible.

This release contains 45 fixes to version 9.1, and a smaller number of fixes to older versions, including:

• Fix btree index corruption from insertions concurrent with vacuuming
• Recover from errors occurring during WAL replay of DROP TABLESPACE
• Fix transient zeroing of shared buffers during WAL replay
• Fix postmaster to attempt restart after a hot-standby crash
• Fix corner case in SSI transaction cleanup
• Update per-column permissions, not only per-table permissions, when changing table owner
• Fix handling of data-modifying WITH subplans in READ COMMITTED rechecking
• Fix for "could not find plan for CTE" failures
• Fix unsupported node type error caused by COLLATE in an INSERT expression
• Avoid crashing when we have problems deleting table files post-commit
• Fix recently-introduced memory leak in processing of inet/cidr
• Fix GIN cost estimation to handle column IN (...) index conditions
• Fix I/O-conversion-related memory leaks in plpgsql
• Teach pg_upgrade to handle renaming of plpython's shared library (affecting upgrades to 9.1)

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Perform post-update steps after the database is restarted.

This update includes three security fixes for the following issues:

• CVE-2012-0866: Permissions on a function called by a trigger are not checked.

This fix prevents users from defining triggers which execute functions on which the user does not have EXECUTE permission.

CREATE TRIGGER failed to make any permissions check on the trigger function to be called. An unprivileged database user could attach a trigger function to a table they owned and cause it to be called on data of their choosing. Normally, this would execute with the permissions of a table owner, and thus not give additional capability. However, if a trigger function is marked SECURITY DEFINER, privilege escalation is possible.

• CVE-2012-0867: SSL certificate name checks are truncated to 32 characters, allowing connection spoofing under some circumstances.

This fixes SSL common name truncation, which could allow hijacking of an SSL connection under exceptional circumstances.

When using SSL certificates, both clients and servers can be configured to verify the other's host name against the common name in the certificate it presents. However, the name extracted from the certificate was incorrectly truncated to 32 characters. Normally that just results in a verification failure, but if the actual host name of a machine is exactly 32 characters long, it could, in principle, be spoofed. The risk of this actually happening appears unlikely, and an attacker would still need to take additional steps outside of PostgreSQL to succeed with an exploit.

• CVE-2012-0868: Line breaks in object names can be exploited to execute code when loading a pg_dump file.

This fix removes 'n' and 'r' from dumpfile comments.

pg_dump copied object names into comments in a SQL script without sanitizing them. An object name that includes a newline followed by an SQL command would result in a dump script in which the SQL command is exposed for execution. When and if the dump script is reloaded, the command would be executed with the privileges of whoever is running the script - often a superuser.

All supported versions of PostgreSQL are affected. See the release notes for each version for a full list of changes with details of the fixes and steps.

Download new versions now:

• Main download page
• Source code
• Binary packages
• One-click installer, including Windows packages

SQL Maestro Group announces the release of PostgreSQL Data Sync 12.2, a powerful and easy-to-use tool for PostgreSQL database contents comparison and synchronization.

The new version is immediately available at
http://www.sqlmaestro.com/products/postgresql/datasync/.

Top 5 new features:

1. Comparison and synchronization of the data represented by database views.
2. Automatic checking of table and column mappings.
3. Filters to compare and synchronize only subsets of data.
4. Exporting comparison results to Excel, HTML, XML, and more.
5. Auto sorting of the target tables to avoid potential integrity violations.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Latest version improves write scalability and performance, provides flexibility and reliability with transaction-level control of synchronous replication and adds Virtual Private Database for extra security

BEDFORD, Mass. – February 9, 2012 – EnterpriseDB, the leading worldwide provider of PostgreSQL and Oracle compatibility products and services, today announced general availability of Postgres Plus Advanced Server 9.1. The release features significant performance enhancements, including the option to free even more processing power for some applications with the industry’s only synchronous replication control on a per-transaction basis. This latest version also speeds read performance and write scalability, enables unlogged tables for greater performance and flexibility and expands the Oracle-compatible feature set. “Our newest version of Postgres Plus Advanced Server adds new, high-end capabilities for performance, reliability, security and scalability. With this release we are enabling our end users to accelerate the expansion of their Postgres Plus deployments at a price point exponentially less than the traditional proprietary databases,” said Ed Boyajian, president and CEO of EnterpriseDB. “These enhancements also give new users even more reason to start looking at Postgres Plus as an alternative for their data centers.” Postgres Plus Advanced Server 9.1 includes the following enterprise-class enhancements:

• Synchronous Replication – Provides maximum control over transaction environments by enabling end users to activate synchronous replication on a per-transaction basis (or per connection or per user) – a level of flexibility and control not available in any other database. This ensures no data is lost should a master fail, and provides performance gains by allowing the application or end user to select what transactions are replicated. This process confirms a transaction has been successfully applied to the slave server’s journal before it is committed to the master.
• Unlogged Tables – Gives end users the option to maximize performance by choosing ‘unlogged’ when creating tables, thus no write-ahead logging (WAL) records are kept. This becomes useful when applications must perform quickly and data loss, should the system fail, is not a concern, such as an online store where the emphasis is on preserving purchase data, but other information like the product reviews a customer viewed, which can generate significantly more data, is less critical. • Improved Read Management – Fundamental improvements to efficiently handle more queries than ever before, and significantly improves performance – particularly on read-only workloads and on machines with more CPUs. • Improved Write Scalability – Now more scalable than ever. New lock manager code, lock avoidance techniques and shortened critical sections allow Postgres Plus Advanced Server to more fully utilize the resources of systems with 32 cores or more, rather than being limited by lock contention. • Expanded Oracle Compatibility – Includes Virtual Private Database, a type of fine-grained access control using row level security policies. This feature allows a number of useful, centralized security implementations that limit the data that end users may access.

Postgres Plus Advanced Server 9.1 is available today on Linux 32 and 64 bit platforms, Windows 32 and 64 bit platforms, HP-UX and Solaris. To learn more about Postgres Plus Advanced Server 9.1, please visit http://www.enterprisedb.com/products-services-training/products/postgres-plus-advanced-server for details.

Connect with EnterpriseDB Learn more about EnterpriseDB Read the blog: http://blogs.enterprisedb.com/ Become a Fan on Facebook: http://www.facebook.com/EnterpriseDB?ref=ts Join us on Google +: https://plus.google.com/108046988421677398468Follow us on Twitter: http://twitter.com/#!/EnterpriseDB About EnterpriseDB Corporation EnterpriseDB, the Enterprise PostgreSQL Company, provides enterprise-class PostgreSQL products and PostgreSQL services to help IT organizations be successful with the world's most advanced open source database. The company's Postgres Plus products are ideally suited for transaction-intensive applications requiring superior performance, massive scalability and compatibility with proprietary database products to reduce overall database costs. EnterpriseDB has offices in North America, Europe and Asia. The company was founded in 2004 and is headquartered in Bedford, MA. For more information, please call +1-781-357-3390, or visit www.enterprisedb.com.

EnterpriseDB and Postgres Plus are trademarks of EnterpriseDB Corporation. Other names may be trademarks of their respective owners.

Media Contact Susan Torrey LEWIS Pulse Phone: 650-492-1921 Email: susan.torrey@lewispulse.com

Hello PostgreSQL community,

Open-source project Scalr is very pleased to announce its support for PostgreSQL. From now on, Scalr and PostgreSQL users can enjoy low maintenance on the cloud- including automatic backups, recoveries, and ease of administering, along with added auto-scaling.

-- Features --

Pre-configured image with sensible parameters and Scalr generated unique password. The users may use CloudWatch metrics at no additional charge to monitor deployment. Backups and snapshots can be easily automated, run via API calls or manually. Auto-scaling is launched when read traffic reaches client-defined threshold. In case of an host failure, the instance will be automatically replaced. Scalr provides read replicas for read-heavy applications.

All these features are detailed on our website: http://scalr.net/features/databases/postgres/.

BEDFORD, Mass. – January 25, 2012 – EnterpriseDB, the leading worldwide provider of PostgreSQL and Oracle database compatibility products and services, today announced the general availability of Postgres Plus® Cloud Database on Amazon Web Services. Postgres Plus Cloud Database is a full-featured, enterprise-class PostgreSQL database-as-a-service (DBaaS). EnterpriseDB also announced today that CloudBees and Engine Yard have selected Postgres Plus Cloud Database as one of their leading database solutions.

Postgres Plus Cloud Database dramatically simplifies the setup and configuration of PostgreSQL in the cloud. In addition to support for Amazon EC2, EnterpriseDB has worked with HP to ensure Postgres Plus Cloud Database will run well with HP Cloud Compute. HP Cloud Compute currently leverages the OpenStack Nova compute platform and API.

“Postgres Plus Cloud Database is the only solution on the market today that makes deploying new instances of PostgreSQL or Postgres Plus Advanced Server easy in any environment,” said Ed Boyajian, President and CEO of EnterpriseDB. “And, through our partnerships with industry leaders CloudBees, Engine Yard, HP and OpenStack, customers will have numerous ways to take advantage of PostgreSQL ‘elastically’ on multiple cloud platforms.”

Postgres Plus Cloud Database combines the advantages of cloud computing with the features expected in an enterprise-class database, including:

Fully ACID compliant relational database service Point-and-click simple setup & management with web-based interface Automatic scaling, load balancing and failover Automated online backup and point-in-time recovery Database Cloning Oracle database compatibility Postgres Plus Cloud Database is available now with two versions of its cloud database: PostgreSQL 9.1, and Postgres Plus Advanced Server 9.0. Pricing for Postgres Plus Cloud Database on Amazon Web Services is the same as Amazon RDS (MySQL), whether you choose the PostgreSQL or Postgres Plus Advanced Server database engine. On January 26th at 9:00 AM PT Ed Boyajian, President and CEO at EnterpriseDB, will host a live Postgres Plus Cloud Database Launch Event and demo. To register, visit http://cloud.enterprisedb.com/launch-event.

Please join us for our live Twitter chat on January 30th at 10:00 AM PT where Karen Tegan Padir, EVP of Products and Engineering at EnterpriseDB will answer your questions about Postgres Plus Cloud Database with the hashtag #cloudDB.

Supporting quotes:

CloudBees

“With Postgres Plus Cloud Database on the CloudBees Java Platform, our developers can easily build applications that invoke a truly elastic database knowing that Postgres is always backed up and available, but without the hassles of database administration,” said Sacha Labourey, CEO and Founder of CloudBees. “Plus, EnterpriseDB and CloudBees both provide innovative, cloud-based scale-out architectures, which are expected in premier database and application platforms.”

Engine Yard

“We’re very pleased to have EnterpriseDB offer Postgres Plus Cloud Database to developers running apps on Engine Yard Cloud,” said Mike Piech, VP, Product Management and Marketing at Engine Yard. “Postgres Plus Cloud Database will enable our mutual customers to provision both multi-host PostgreSQL and Postgres Plus Advanced Server clusters easily and efficiently.”

Red Hat

“Elasticity and horizontal scaling are critical characteristics for cloud applications, which make Postgres Plus even more attractive for applications in the cloud,” said Brian Stevens, CTO and VP, Worldwide Engineering at Red Hat. “As a leading provider of cloud platforms and infrastructure, we are excited to see enhanced innovation and choice for cloud developers and users.”

451 Research

“We have recently seen a surge of interest in PostgreSQL driven by its potential for deployment in the cloud,” said Matt Aslett, Research Manager, Data Management and Analytics, 451 Research. “With the addition of auto-data size elasticity and horizontal scaling in Postgres Plus Cloud Database, EnterpriseDB has re-introduced PostgreSQL as a database platform for the creation and delivery of private, public and hybrid cloud services, as opposed to simply a database running in the cloud.”

Voices Heard Media

“We needed a low touch solution that was easy to use and could elastically scale PostgreSQL in the cloud,” said Mark Baird, Director of IT at Voices Heard Media. “Tasks such as load balancing, auto-scaling of the cluster, auto backup and auto-failover can be extremely difficult to get configured correctly, but with Postgres Cloud Database you get all of this right out of the box.”

Aquent

“With Postgres Plus Cloud Database, EnterpriseDB brings a welcome addition to cloud-based services,” said Larry Bolick, CIO, Aquent. “As satisfied customers of EnterpriseDB for the past two years, we have been running Postgres Plus Advanced Server on virtual servers worldwide and have been eagerly awaiting a version available natively in the cloud.”

Burris Logistics

“With Postgres Plus Cloud Database, EnterpriseDB changes how we should think about database services in the cloud. Their solution has reduced much of the admin effort, and all of the infrastructure work out of database installation and configuration. It almost seems too easy,” said Ed Krupka, CIO, Burris Logistics. “Postgres Plus Cloud Database is so innovative, especially with its auto-data size elasticity and horizontal scaling. It’s poised to make PostgreSQL the de facto database for the cloud.”

Connect with EnterpriseDB

Learn more about EnterpriseDB Read the blog: http://blogs.enterprisedb.com/ Follow us on Twitter: http://www.twitter.com/enterprisedb Become a fan on Facebook: Join us on Google+: https://plus.google.com/108046988421677398468

About EnterpriseDB Corporation

EnterpriseDB, the Enterprise PostgreSQL Company, provides enterprise-class PostgreSQL products and PostgreSQL services to help IT organizations be successful with the world's most advanced open source database. The company’s Postgres Plus products are ideally suited for transaction-intensive applications requiring superior performance, massive scalability and compatibility with proprietary database products to reduce overall database costs. EnterpriseDB has offices in North America, Europe and Asia. The company was founded in 2004 and is headquartered in Bedford, MA. For more information, please call +1-781-357-3390 or visit www.enterprisedb.com.

EnterpriseDB and Postgres Plus are trademarks of EnterpriseDB Corporation. Other names may be trademarks of their respective owners.

Media Contact

Susan Torrey LEWIS Pulse Phone: 650-492-1921 Email: susan.torrey@lewispulse.com

PGCon 2012 will be held 17-18 May 2012, in Ottawa at the University of Ottawa. It will be preceded by two days of tutorials on 15-16 May 2012.

We are now accepting proposals for talks. Proposals can be quite simple. We do not require academic-style papers.

If you are doing something interesting with PostgreSQL, please submit a proposal. You might be one of the backend hackers or work on a PostgreSQL related project and want to share your know-how with others. You might be developing an interesting system using PostgreSQL as the foundation. Perhaps you migrated from another database to PostgreSQL and would like to share details. These, and other stories are welcome. Both users and developers are encouraged to share their experiences.

For more information, please see the original announcement.

DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" Winter 2012, v 5.0.5.

Version Highlights

• PostgreSQL v 9 support (named parameters, anonymous blocks, enums);
• major TADTable and Live Data Window mode optimization;
• Firebird v 3 support (packaged procedures, PSQL functions, identity columns, BOOLEAN data type);
• Firebird COMPUTED BY support;
• Interbase v 6, 7 support;
• Advantage v 8, 9 support;
• SQL Anywhere v 12 support;
• SQLite v 3.7.9 support;
• ElevateDB ODBC support;
• ReportBuilder DADE; And more. For detailed change log, please, check: http://www.da-soft.com/anydac/anydac-for-delphi-v-5.0.5.2073-released.html

AnyDAC for Delphi

AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to PostgreSQL, Firebird, SQLite, MySQL, MS SQL Server, Oracle, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage Database and more. For complete list of features and availability, please check:

• AnyDAC home - http://www.da-soft.com/anydac/
• AnyDAC shop - http://www.da-soft.com/anydac/order.html
• AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features

• Native access to PostgreSQL, Firebird, MySQL, SQL Server, Oracle, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
• Generic access to any database supported through dbExpress or ODBC data sources.
• Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
• Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
• Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
• First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
• Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
• Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
• Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases

• Workgroup - PostgreSQL, Firebird, MySQL, SQL Anywhere, Interbase, Advantage DB.
• Enterprise - Oracle, SQL Server, IBM DB2, Informix.
• Database in clouds - SQL Azure.
• Desktop - SQLite, Access, Advantage DB, BlackFish SQL, SQL CE.
• Embedded - SQLite, Firebird Embedded, MySQL Embedded, Berkeley DB.
• Bridges - dbExpress, ODBC.

-- With best regards, DA-SOFT Technologies Team