The EDB Blog

Follow the EnterpriseDB Blog for the latest on all things EDB Postgres. From news to how-tos, our community of PostgreSQL experts is always sharing leading-edge insights.

The Data Platform for Crossing the Enterprise ‘Digital Divide’

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

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

By Sandra Wiecki
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

By Ashutosh Bapat
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

By Pierre Fricke
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...

Partition Pruning in EDB Postgres 9.5

By Vibhor Kumar
One of my colleagues who was recently working with a customer has presented a customer case. According to him, the customer has a partitioned table and EDB Postgres™ was not applying the partition pruning in his query. So, I thought to blog about partition pruning, so that EDB Postgres developers...

Collaboration Makes Postgres Better for Everyone

By Sandra Wiecki
I recently went to PGConf.EU, the European PostgreSQL conference that was held in Tallinn, Estonia on November 1-4. This annual event for Postgres developers and users is a great opportunity to learn what everyone has been and will be working on. It always amazes me how this open source community...

5 Step Assessment: Selecting a DBMS for New Application Development

By Matt Cicciari
IT is struggling to keep up with the speed of business. The business landscape shifts priorities and requirements faster than you can say “request a change order.” As technology choices increase, so does the complexity of the decision-making process for new solutions. IT is left asking: “how can we...