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

PostgreSQL Development covering SQL, Functions, Concurrency, Client interfaces and advanced topics for application developers using PostgreSQL.

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

PGDay DC 2012 will be held on March 30th, 2012 at the Executive Conference & Training Center, in Reston, Virginia near Washington DC.

In-depth course on Replication and Recovery

In-depth course on PostgreSQL administration.

PGDAY-2012

Los días 28 y 29 de noviembre del año 2012 se desarrollará el PGDAY-2012, como parte de los sub eventos que se celebrarán durante la Duodécima Semana Tecnológica, organizada por el Centro Coordinador para la Formación y el Desarrollo del Capital Humano (FORDES).

Se convierte este espacio en momento propicio para fomentar el intercambio entre los miembros del Grupo de Usuarios de PostgreSQL de Cuba e incentivar la investigación, el desarrollo y la innovación en este campo.

leer más

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/.

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

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.

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/.

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.

• 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 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

• 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.

• 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.