Solutions Linux is the most important FOSS event in France. The PostgreSQL french-speaking community will have a booth there during the 3 days.

PG Day France is a major French-speaking PostgreSQL community event. This year the conference will be held on Thursday, June 7th in Lyon. A hundred visitors are expected for this day dedicated to PostgreSQL and its associated projects.

You can find more information at: pgday.fr

PGDay NYC 2012 will be held on April 2, 2012 at the Lighthouse International in New York City. PGDay NYC is an intensive one-day PostgreSQL symposium with technical sessions focusing on the core topics you need to succeed with PostgreSQL. It will cover topics for users, developers and contributors to PostgreSQL.

For more information, please see http://pgday.nycpug.org

In-depth course on Replication and Recovery

In-depth course on PostgreSQL administration.

Fifth year of "Prague PostgreSQL Developers Day" conference, organized by CSPUG (Czech and Slovak PostgreSQL Users Group), will be held on February 9, 2012 in Prague.

The PostgreSQL project will have a Devroom at FOSDEM 2012, which takes place on February 4-5 in Brussels, Belgium.

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

Second annual PGDay held in conjunction with the Southern California Linux Expo (SCALE10X)

We're a bunch of postgres people who'll meet up for some talks, food and drinks. Please come join us!

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.

Hola, acudo a este foro ya que no he podido encontrar cursos que se impartan en la Cd de México.

Le agradecería mucho si alguien sabe donde se puedan tomar cursos de Postgres en México que me pueda proporcionar la información.

Ya sea de nivel basico, medio o avanzado

Gracias, Saludos y Feliz 2012

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

Explore cloud computing and true cloud databases during this webcast with the 451 group.

We are going to be doing a booth at Usenix LISA conference in Boston from December 7-8 as well as a BOF. If you are attending LISA please drop by.

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.

The fifth edition of the Italian PostgreSQL Day (PGDay.IT 2011) will be held on November 25 in Prato.

The PostgreSQL project will have a Devroom at FOSDEM 2012, which takes place on February 4-5 in Brussels, Belgium.

Fifth year of "Prague PostgreSQL Developers Day" conference, organized by CSPUG (Czech and Slovak PostgreSQL Users Group), will be held on February 9, 2012 in Prague.