The EDB Blog

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

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

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

Data in the Database vs. the File System

2/20/2018
An age-old question is whether it is better to put data in a database or a file system. Of course, the answer is "it depends," but let's look at what it depends on. First, Postgres stores its data in the file system, so the file system must be good for something. Postgres also stores some of its...

Untangling Years of Layered Legacy Systems

2/16/2018
Financial Services Institutions Look to Open Source Today’s financial services institutions must innovate and evolve their technology to remain competitive during a time of great disruption. The need for rapid innovation and increasing digitalization is shining a light on the IT complexity many...

BART 2.2 Sneak Peek

2/13/2018
The EDB Postgres Backup and Recovery Tool development team is super busy developing features for the next major release and I wanted to give everyone a sneak peek into the exciting new capabilities to be delivered as part of BART 2.2. The last major release of BART was published in June 2017 and we...

What is 256 Pages Long with 99 Articles, and Has Teeth?

2/12/2018
Explore How GDPR Impacts a DBA On May 25, 2018, the General Data Protection Regulation (GDPR) will take effect, and it will impact the way your organization collects and manages customer data in Europe. GDPR effectively replaces the data protection directive 9546EC, and is not just applicable to...

What Happens if You Don’t Monitor Your PostgreSQL Database Effectively?

2/6/2018
A good DBA is someone who knows how to monitor the databases EFFECTIVELY and when it comes to a production or business critical database, the job becomes even more crucial. ​Not monitoring your databases and system effectively may lead to a severe catastrophe - application slowness, database...