This white paper presents a framework and a 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. Most of the recommendations...

Although the most sensitive layer of the infrastructure stack, the database layer has the potential for the greatest cost savings and strategic advantages. For example, one Oracle license alone lists at $47,500 per processor core (without any add-on features) with annual operating expenses equal...

This paper examines four enterprise adoption strategies (and associated risk factors) for Postgres, and provides guidance to help readers develop an informed adoption playbook. The four strategies are analyzed for PROs and CONs across seven software adoption risk factors: Capabilities, Roadmap,...

This white paper demonstrates the benefit of EnterpriseDB Postgres Plus Advanced Server database on IBM Power Systems running Linux servers when compared to a similar configuration using the Intel Xeon processor-based system. 

This paper reviews and illustrates Postgres’ NoSQL capabilities in the context of Postgres’ robust relational competencies. The paper also describes performance tests that demonstrate that Postgres, the leading open source relational database solution, is a superior platform for handling most...

Advances in technology and increased enterprise momentum have generated more and more queries from Oracle, DB2 and SQL Server users exploring PostgreSQL (also known simply as Postgres) for their database needs. Microsoft SQL Server users in particular have been very active in 2014, possibly due...

Most Postgres users don't need NoSQL. With new features and capabilities alongside several longstanding components and extensions, Postgres can support virtually all of today’s data types as well as unstructured and semi-structured data. This means Postgres can power many applications written...

Evan Quinn, a leading database management system (DBMS) analyst now at Enterprise Management Associates, put out a February 2014 report examining the rise and growing prominence of PostgreSQL. His report includes commentary from Bruce Momjian, co-founder of the PostgreSQL community Global...

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

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