The EDB Blog

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

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

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

Plenty to Celebrate with Postgres the ‘DBMS of the Year’

2/1/2018

PostgreSQL has long been a popular database, loved by developers and database administrators for its ease of use, comprehensive and intuitive documentation , and reliability. Anyone at EnterpriseDB ® (EDB ™ ) could tell you that interest in PostgreSQL (also known as Postgres) has been growing...