The EDB Blog

5 Use Cases Driving Database Development

3/9/2017
The new EDB Postgres ™ Platform 2017 from EnterpriseDB ® (EDB ™ ) gives enterprises the capability, performance, and reliability they need with the flexibility and ease of provisioning required by modern DevOps. A core component of the Platform is the EDB Postgres ™ Advanced Server database, a...

Powering Big Data Processing in Postgres with Apache Spark

3/2/2017
Postgres plays a central role in today’s integrated data center. A powerful feature called a Foreign Data Wrapper (FDW) in Postgres supports data integration by combining data from multiple database solutions as if it were a single Postgres database. FDWs essentially act as pipelines connecting...

Going Deep on Stats

2/28/2017
Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log_statement_stats: SET client_min_messages = log; SET log_statement_stats = true; SELECT 100; LOG: QUERY STATISTICS DETAIL: ! system usage stats: 1 ! 0...

The Data Platform for Crossing the Enterprise ‘Digital Divide’

2/20/2017
To succeed in today’s fast-paced digital economy, companies must synthesize vast volumes of data from existing and new applications in order to better serve their customer needs through automation, smarter interactions, and real-time information. The challenge is for enterprises to optimize new...

Monitoring Amazon PostgreSQL RDS with PEM version 6.0

02/10/2017
The EDB Postgres ™ Enterprise Manager is an enterprise management tool designed to tune, manage, and monitor a large number of Postgres deployments on servers on-premises or spread out across geographical boundaries. It is the cornerstone of the Management Suite of tools that is integrated into the...

The Power of APIs in EDB Postgres Ark

2/6/2017
EnterpriseDB® (EDB™) created the EDB Postgres Ark™ to simplify the process of provisioning robust Postgres deployments, while also providing the benefits of cloud computing. The EDB Postgres Ark is a Database-as-a-Service (DBaaS) framework for hybrid cloud deployments of Postgres to private and...

Videos: Learn to Install and Start EDB Postgres Failover Manager

2/3/2017
A cornerstone for ensuring ongoing data access during scheduled downtime or unexpected failures is a high availability design. The EDB Postgres ™ Failover Manager is a high availability solution that monitors the health of streaming replication clusters and detects failures, and, if activated,...

Modern IT Challenges Require a Multi-model Data Platform

01/31/2017
The data center has become a center of great complexity. Data has proliferated with more devices, greater volumes, and higher velocities. In trying to extract greater value (i.e. actionable intelligence) from data, many IT managers deployed a host of new solutions to manage, store, and analyze data...

Data Replication from Oracle Logical Standby to EDB Postgres

01/20/2017
At EnterpriseDB ® (EDB ™ ), we are sometimes presented with individual customer use cases or requests that call for the development of innovative solutions to support their deployment of the EDB Postgres Platform. For example, one of our customers wanted to leverage Oracle ® Logical standby for...

Creating SSL Certificates

01/13/2017
Having covered the choice of certificate authorities, I want to explain the internals of creating server certificates in Postgres. The instructions are already in the Postgres documentation. When using these instructions for creating a certificate signing request ( csr ), two files are created: --...

SSL Certificates and Certificate Authorities

01/13/2017
When setting up ssl in Postgres, you can't just enable ssl . You must also install a signed certificate on the server. The first step is to create a certificate signing request (csr) file that contains the host name of the database server. Once created, there are three ways to sign a csr to create...

The pg_rewind Improvements in PostgreSQL 9.6

01/11/2017
The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can be reattached to the new master as a standby without restoring it from the new base backup. The tool examines the timeline histories of the new master...

Controlling Autovacuum

01/09/2017
Unlike other database systems, Postgres makes the cleanup process visible and tunable to users. Autovacuum performs recycling of old rows and updates optimizer statistics. It appears in ps command output, the pg_stat_activity system view, and optionally in the server logs via...

Achieving Polyglot Persistence through Data Integration in the Cloud

Polyglot persistence is based on the assumption that there is no single database technology that suits all data needs equally. Hence different types of data need to be handled and stored differently in order to provide the best possible performance while offering appropriate availability. This...

PostgreSQL: Aggregate Push-down in postgres_fdw

11/23/2016
It's exciting times in PostgreSQL for those who are using postgres_fdw or Foreign Data Wrappers (FDWs) in general. Users often complained that a simple count(*) on a foreign table was slow since PostgreSQL required to pull all the rows from the foreign server just to count them to produce count...

EDB Ark: DBaaS for Hybrid Cloud Deployments

12/13/2016
The accelerated pace of application development means most enterprises can no longer wait for traditional IT to lead those initiatives. Traditional IT practices that required provisioning hardware and software, configuring the network, and essentially recreating resources that developers need...