Postgres Open, now in its second year aims to bring enterprise users, application developers and core PostgreSQL developers together.
OmniTI's Lead Database Architect, Denish Patel's session is "Deploying maximum HA architecture with Postgres." Enterprises use PostgreSQL database servers to reduce licensing cost without affecting their high-availability need from their IT infrastructure. Since PostgreSQL 9.0, achieving an enterprise-level of maximum HA architecture solutions using PostgreSQL is very easy. Denish will discuss the common causes of application and/or server downtime, and how technologies available in the PostgreSQL Database can help avoid costly downtime and enable rapid recovery from unplanned failures, also minimizing the impact from planned outages. He will highlight new technologies introduced in the PostgreSQL Release 9 that enable businesses to make their IT infrastructure even more robust and fault tolerant, maximize their return on investment on high availability infrastructure and provide better quality of service to users.
Keith Fiske, a database administrator at OmniTI, will give a talk entitled, "PG Extractor - A smarter pg_dump." Pg_dump is a great tool for getting your data out of the database for backups or many other uses. It is, however, lacking in fine-grained filtering to get exactly the schema and/or data you want. PG Extractor (pg_extractor) was born out of the frustration to show what pg_dump could be some day. Keith will discuss some of the development process of the tool and issues (with some solutions) that were encountered along the way. He'll also be giving examples of how it is used to automatically track changes to database schema in version control, and how database architects at OmniTI currently use this tool in production.
Postgres Open is a non–profit, community–run conference series in the United States, focused on business users, database professionals and developers of PostgreSQL, the open source database. Postgres Open promotes the business of PostgreSQL as well as its use and development.