Postgres Plus® White Papers and Data Sheets

White papers are below. Use the left hand navigation pane to click Data Sheets.

Postgres Overviews

Discover the differences between PostgreSQL, Postgres Plus Standard Server and Postgres Plus Advanced Server and optimize your choice of open source database. You'll learn enough about the different capabilities, modules, and uses for each product to make the best Postgres choice for your organization.

While EnterpriseDB's Postgres Plus Advanced Server is built upon the rock-solid PostgreSQL foundation, it delivers many significant value-added features and add-on products not available in the community edition.

Research shows the typical DBA is responsible for an average of 35 databases with the trend only moving upward. Recognizing this issue, EnterpriseDB has introduced the first enterprise-architected management tool for DBAs who are looking to widely adopt Postgres in their enterprise and desire the same type of management capabilities they get from tools that are included from other database vendors that they work with. This whitepaper describes this solution – Postgres Enterprise Manager – in detail and focuses on how data management professionals will benefit from the enterprise-class capabilities supplied by the tool.

A recent study done by the IT industry analyst group IDC found that, while cloud computing accounts for less than 2% of IT spending today, it’s estimated that by 2015 nearly 20% of all information will be "touched" and enabled by cloud computing environments. IDC believes that as much as 10% of all data will be maintained in a cloud by 2015.

This equates to large volumes of data being stored in the cloud, with much of it being offered in a database-as-a-service (DBaaS) fashion. The data volumes stored in the cloud will likely be enormous, considering that IDC predicts a 50X data growth multiple in the next decade.

Modern businesses are looking to both public and private clouds as enablers for their database management systems. However, many admit that they struggle with selecting the database provider(s) to utilize in their move to cloud computing and what features they need in order to benefit from such a move. This paper examines the question of what constitutes an enterprise-class database that takes advantage of the various benefits of cloud computing environments.

This white paper discusses many of the database-related pressures faced by IT managers today with regard to usage and costs. It reviews how every IT organization can find a class of applications for open source database adoption, and then use that experience to determine how wide and deep their open source database deployments can go to to fully benefit from consequent cost savings.

Postgres and Oracle Compatibility

Take a high-level tour through the five main areas of Oracle Compatibility built into Postgres Plus Advanced Server. For a more detailed document, download the Oracle Compatibility Developer's Guide.

This guide describes the Oracle compatibility features of Postgres Plus Advanced Server 9.3. It is the definitive reference for all the Oracle supported features.

While many enterprises have been able to wring out significant cost savings by migrating to open source software for operating systems and middleware, there has been a reluctance to extend to the database layer due to concerns about complexity, risk and operational pain of migration. This paper will provide best practices for migrating Oracle applications to lower cost PostgreSQL alternatives; quantifying and mitigating associated risks; and reducing the operational pain associated with migration.

Government agencies are facing unprecedented budget pressures. With the sequester removing $85 billion from federal funding; every technology program is being examined for potential cost-savings. As budgets are cut at federal agencies, funds for new and meaningful projects are limited – with about 70 percent of dollars being diverted to existing systems. Just as at the federal level, state and local government agencies are also looking for ways to centralize and optimize their existing infrastructure.

Today, technology is providing cost-effective alternatives to the status quo with one of the biggest untapped opportunities in agencies’ IT infrastructures—the database management system (DBMS). This white paper shows that, by transitioning existing databases to open source -based alternatives, agencies can dramatically reduce costs and reallocate funds to more mission-critical initiatives

Postgres Technical Topics

The use cases of replication can be many, however the core reasons that replication is used are the following: simple backup, sharded or read scale-out architecture, business intelligence / reporting, and simple high availability. This paper provides an overview of EnterpriseDB’s xDB Replication Server, describes how the solution functions, and then looks at the question of why the xDB Replication Server should be considered over the built-in replication functionality offered in PostgreSQL 9.0 and above.

 

This document provides an introduction to Postgres Plus Advanced Server on HP-UX and is designed to acquaint you with the basics of how to be successful in your deployment of the database. It serves as a help aid to get you up to speed with the basics of the database server and provides links to documentation resources that will give you much more detail in each area that is covered. Topics covered include: Installation, Configuration, database interfaces/utilities/tools, Managing Security, Storage Management, Tables and Indexes, Loading data, Development Basics, Replication, Backup and Recovery, Performance Tuning, Migrating from other databases and more.

A key requirement of any enterprise-caliber database in the scalable world of the Internet serving large user populations is high performance when creating and updating data as well as reading existing data. Prior to selecting a database for the first time or switching an existing database to a new one, it is always prudent to seek out and investigate a database's performance characteristics to obtain a level of assurance it will meet your needs both now and in the future.

This paper is intended to assist organizations in this regard by evaluating some basic performance metrics of Postgres Plus Advanced Server from EnterpriseDB Corporation.

This whitepaper presents a framework and series of recommendations to secure and protect a Postgres database. We discuss a layered security model that addresses physical security, network security, host access control, database access management and data security. While all of these aspects are equally important, the paper focuses on Postgres-specific aspects of securing the database and the data.

For our discussion of the specific security aspects relating to the database and the data managed in the database, we use a AAA (Authentication, Authorization and Accounting) approach common to computer and network security.

Most of the recommendations in this paper are applicable to PostgreSQL (the community edition) and to Postgres Plus Advanced Server (PPAS), EnterpriseDB's high-powered, feature-rich commercial distribution of PostgreSQL. PPAS, however, provides several relevant security enhancements, such as edb_audit, SQL/Protect and Virtual Private Database (VPD).

A cornerstone for ensuring ongoing data access during scheduled downtime or unexpected failures is a High Availability design. This white paper outlines a variety of high availability configurations for Postgres Plus Advanced Server and then describes how EDB Failover Manager can be integrated into a 9s high availability system for each one.

Postgres and MySQL

Postgres’ long-term support for and focus on server side programs (triggers and stored procedures), ACID compliance, data and referential integrity, and fine-grained access controls are much more mature and stable than MySQL, which only recently has started implementing some of these features. While not an exhaustive side-by-side comparison, this white paper outlines a few key differences between Postgres and MySQL and some of the benefits data professionals will find in working with Postgres.