The EDB Blog

GDPR Will Turn DBAs Into Superheroes

5/18/2018

The world is awash with statistics about the General Data Protection Regulation (GDPR) and depending on who you believe, companies are either completely ready ( this study says 72% of global businesses are confident of compliance) or there is still a large portion of companies who will not achieve...

Row Movement Across PostgreSQL Partitions Made Easy

5/15/2018

Before declarative partitioning was introduced in PostgreSQL 10, one had to use table inheritance. One of the main drawbacks of using table inheritance is that ROW triggers are needed for the parent table to automatically route the inserted row to the right child table, which is cumbersome and slow...

GDPR Could Become a Costly Millstone that Slows Down Business Agility

5/10/2018

The General Data Protection Regulation (GDPR) has been one of the large ticket items for IT departments in the last year. According to PWC , 68% of large US multinationals will have spent between $1 million and $10 million on GDPR readiness and compliance in the lead up to the May 25, 2018 deadline...

SERIALIZABLE in PostgreSQL 11... and beyond

5/8/2018

Thanks to the tireless work of Google Summer of Code student Shubham Barai with the support of reviewers, a mentor, and a committer, PostgreSQL 11 will ship with predicate lock support for hash indexes , gin indexes and gist indexes . These will make SERIALIZABLE transaction isolation much more...

Do You Have the Essential Skills to Be a Successful PostgreSQL DBA?

5/4/2018

Open source databases are becoming an increasingly preferred option for organizations seeking high performance, lower cost alternatives to legacy databases. According to a report by Gartner Research, more than 70% of new in-house applications will be developed on an open-source DBMS. 1 As...

Running EDB Postgres Failover Manager Without Sudo

4/24/2018

In the default mode of operation, EDB Postgres Failover Manager (EFM) agents run as the ‘efm’ operating system user. The agent uses sudo to perform various operating system and database tasks. More information about how sudo is used is in the Extending Failover Manager Permissions section of the...

EnterpriseDB Updates Tools, and Enhances Security and Alerting

4/19/2018

Database administrators need tools for database maintenance, performance optimization, and configuration as well as creating a highly available supportive infrastructure. EnterpriseDB (EDB) leads the industry in creating best-in-class Postgres tools to support DBAs with their mission critical...

Intermediate Certificates

4/10/2018

I previously mentioned the importance of high quality documentation, so we are always looking for improvements. This email thread from 2013 attempted to codify the rules for how to properly use intermediate ssl/tls certificates with Postgres. At this time, our documentation was updated to recommend...

Encryption Module in EDB Postgres Earns FIPS 140-2 Validation

4/6/2018

U.S. government agencies and other organizations that require higher levels of security now have another green light on the road to open source. The Cryptographic Module Validation Program (CMVP), operated by the National Institute of Standards and Technology (NIST), has awarded a coveted FIPS 140-...

Wal and Xlog

4/3/2018

Postgres isn't the best at naming things. Of course, there is the old computer saying, "There are only two hard things in Computer Science: cache invalidation and naming things." With Postgres being 31 years old and developed by several different project teams, naming can be even more inconsistent...

Containing Bloat with Partitions

3/27/2018

PGConf India 2018 attracted a large number of PostgreSQL users and developers. I talked about "query optimization techniques for partitioned tables" ( slides ). Last year, I had held an introductory talk about PostgreSQL's declarative partitioning support ( slides ). Many conference participants...

Simple Ways to Protect Your Postgres Servers from an Unlikely Attack Vector: A Rogue Picture of Scarlett Johansson

3/21/2018

Imperva, a provider of data and application security solutions, is actively running a research effort with the express goal of identifying attack methods on databases. They call their project StickyDB , a database decoy designed to deceive a would-be hacker into targeting their databases. Once...

Zheap: A Storage Engine to Provide Better Control Over Bloat

3/20/2018

In the past few years, PostgreSQL has advanced a lot in terms of features, performance, and scalability for many core systems. However, one of the problems that many enterprises still complain is that its size increases over time which is commonly referred to as bloat. My colleague Robert Haas has...

Introduction to Parallel Sequential Scan

3/13/2018

In this video, we will have a look at how parallel sequential scan can be used in EDB Postgres Advanced Server to enhance the performance of the queries. Additionally, we will also have a look at the important parameters related to it, and discuss the scenarios where it does or does not boost the...

Creating a Data Redaction Capability to Meet GDPR Requirements Using EDB Postgres

3/6/2018

The GDPR (General Data Protection Regulation) goes into effect on May 25, 2018 throughout the European Union. The regulation focuses on the secure management of personal information. For more detailed information, consult the official GDPR website or listen to our recent GDPR Webinar . A successful...

Making Postgres Talk to LDAP (with StartTLS)

2/27/2018

I recently got a few support cases from customers seeking to connect Postgres with LDAP (usually with some form of SSL/TLS encryption, to ensure security). I spent a bit of time trying to create a consistently reproducible environment where LDAP could be used to authenticate PostgreSQL connections...