Postgresql.org

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

The PostgreSQL Global Development Group today released updates for all active branches of the PostgreSQL object-relational database system, including versions 9.1.2, 9.0.6, 8.4.10, 8.3.17 and 8.2.23. Users of any of the several affected features in this release, including binary replication, should update their PostgreSQL installations as soon as possible.

This is also the last update for PostgreSQL 8.2, which is now End-Of-Life (EOL). Users of version 8.2 should plan to upgrade their PostgreSQL installations to 8.3 or later within the next couple of months. For more information, see our Release Support Policy.

The features affected by this update include: binary replication and hot standby, GIN indexes, the citext extension, pg_upgrade, window function aggregate sorting, self-referential foreign keys, PL/perl, and general Extension handling. Users of these features should apply the updates right away.

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

• Fix bugs in information_schema.referential_constraints view**
• Correct collations for citext columns and indexes**
• Prevent possible crash when joining to a scalar function
• Prevent transitory data corruption of GIN indexes after a crash
• Prevent data corruption on TOAST columns when copying data
• Fix failures during hot standby startup
• Correct another "variable not found in subplan target list" bug
• Fix bug with sorting on aggregate expressions in windowing functions
• Multiple bug fixes for pg_upgrade
• Change Foreign Key creation order to better support self-referential keys**
• Multiple bug fixes to CREATE EXTENSION
• Ensure that function return type and data returned from PL/perl agree
• Ensure that PL/perl strings are always UTF-8
• Assorted bug fixes for various Extensions
• Updates to the time zone database, particularly to CST6

Changes marked with ** above require additional, post-update steps in order to fix all described issues. See the release notes for each version for a full list of changes with details of the fixes and steps.

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.

Download new versions now:

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

The code behind www.postgresql.org has been migrated to a new technology framework. The site itself should work exactly as before, but the user experience will be slightly different.

All the data from the previous website has been migrated over, but some of it requires manual adjustments to look correct. We ask for your patience as we finish this process over the upcoming days.

For those who regularly submit news and events to the site, you will notice that the process has changed. In this process there are also some manual steps involved to migrate your permissions in the system - so again, we ask for your patience.

Gazzang, Inc., the company securing data in the cloud, today announced availability of packaged support for PostgreSQL 8.x and 9.x open source databases in its ezNcrypt flagship data security platform. The release adds Gazzang’s Transparent Data Encryption for PostgreSQL to existing support for MySQL databases, and is now available for download.

Gazzang ezNcrypt for Databases enables customers to protect, encrypt and provide key management for open source databases using transparent data encryption features traditionally reserved for more expensive, complex commercial databases. The solution installs within minutes, providing out-of-the-box data protection that eliminates the need for costly, complex changes to databases and applications, and leveraging an advanced key management system where the keys are never stored on the same server with the data to be encrypted.

Read more on the Gazzang Blog

ezNcrypt for Databases Now Provides Transparent Data Encryption for PostgreSQL

PGDay.IT 2011, "Where it all started".

Yes, PGDay returns to Prato, where in 2007 the first edition of a PostgreSQL conference ever took place in Europe and where in 2008 the first official European PostgreSQL Day happened.

The conference will take place on Friday November 25 at the Monash University Prato Centre. Social events are expected for Thursday evening and Friday evening.

One keynote speech, 16 talks in two parallel tracks (general/DBA and developers) and one "lightning talk" session so that everyone can share their own experiences.

Special guest of the event is Magnus Hagander, core team member and president of PostgreSQL Europe. His keynote speech will describe PostgreSQL 9.1 strengths.

Simon Riggs, major developer and committer, will be talking about PostgreSQL and NoSQL databases, as well as sharing his vision on PostgreSQL futures with the attendees.

Community members Andreas Scherbaum will be talking about data warehouse tuning, Gianni Ciolli about debugging with writable CTEs, Gabriele Bartolini about backup and recovery, Marco Nenciarini about SSI, Postgres in the cloud and extensions.

The detailed version of the program, which is subject to change, is available on the conference website.

All the Italian users and developers of PostgreSQL are encouraged to participate to the event, the main annual conference about the world's most advanced open-source database. It is an unrepeatable opportunity for everyone to get the latest news on PostgreSQL and to get in touch with some of the developers.

We look forward to hearing from you, and seeing you in Prato very very soon!

The schedule for the fifth edition of the Italian PostgreSQL Day (PGDay.IT 2011), which will be held on November 25 in Prato, is on-line. Two parallel tracks, 17 talks in English and Italian, renowned international speakers and a lot of fun at our social/community events!

Dear all,

Benetl, a free ETL tool for postgreSQL, is out in version 3.8.

It is supporting the postgreSQL driver 9.0 and has been tested on postgreSQL 9.1.

Benetl is freely dowloadable at: http://www.benetl.net

You should update.

Regards,

Dear all, Benetl, a free ETL tool for postgreSQL, is out in version 3.8. It is supporting the postgreSQL driver 9.0 and has been tested on postgreSQL 9.1. Benetl is freely dowloadable at: http://www.benetl.net You should update. Regards,

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

The new version is immediately available for downloading.

Key product features:

1. Comparing and deploying changes to database contents.

2. Automatic creation of error-free synchronization scripts.

3. Easy-to-read difference display.

4. Saving all options to a project file for instant re-execution.

5. Custom comparison keys and flexible auto-mapping tools.

6. Full control over the comparison and synchronization.

7. Powerful command-line interface for continuous integration.

Full press release is available at the SQL Maestro Group website.

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