The EDB Blog

Getting the Most of out Application_Name

By Bruce Momjian
3/15/2017
Application_name might be one of those Postgres settings that you have seen in various places but never understood its purpose. It is true that setting application_name doesn't change the behavior of Postgres (with one small exception ), but it is very useful for monitoring. Its value appears in...

Combining Partitioning and FDWs for Real Time Analytics

By Ashutosh Bapat
3/14/2017
Since v9.1 PostgreSQL has been steadily improving its Foreign Data Wrapper (FDW) capabilities. FDWs are a way to access and manipulate data external to PostgreSQL from a PostgreSQL server. The technology is based on the SQL/MED standard, which represents foreign data in the form of relational...

Wait Event Reporting

By Bruce Momjian
3/13/2017
Postgres often lacks the sophisticated reporting of more established enterprise relational database systems. Sometimes that is because Postgres doesn't require as much monitoring and tuning, but there are legitimate monitoring needs which Postgres doesn't support. Thanks to the wait_event_type and...

Benchmarks Reveal Major Increase in EDB Replication Performance

By Dick Dowdell
3/10/2017
A fundamental question database administrators ask before deploying replication services is what they can expect in terms of performance. As described below, if a sufficient rate of data replication cannot be maintained, replication latency will grow to a level that makes replication suboptimal for...

5 Use Cases Driving Database Development

By Jason Davis
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

By Abbas Butt
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

By Bruce Momjian
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’

By Keith Alsheimer
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

By Vibhor Kumar
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

By Divya Mary Varughese
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

By Bobby Bissett
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

By Jason Davis
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

By Vibhor Kumar
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

By Bruce Momjian
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

By Bruce Momjian
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

By Vibhor Kumar
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...