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.
By Marc Linster
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 GDPR-compliant implementation requires the use of...
MORE
By Richard Yen
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, and wanted to write it down somewhere. The...
MORE
By Bruce Momjian
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 configuration files in the file system, e.g. pg_hba...
MORE
By Marc Linster
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 financial services institutions now face — untangling...
MORE
By ahsan hadi
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 are already well underway in developing exciting...
MORE
By Marc Linster
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 companies in the EU, but to any company offering...
MORE
By ajay patel
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 crashes or downtime, all of which lead to Business loss...
MORE
By Keith Alsheimer
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 rapidly in recent years, but that might be considered...
MORE
By Robert Haas
What if PostgreSQL didn’t need VACUUM at all? This seems hard to imagine. After all, PostgreSQL uses multi-version concurrency control (MVCC), and if you create multiple versions of rows, you have to eventually get rid of the row versions somehow. In PostgreSQL, VACUUM is in charge of making sure that happens, and the autovacuum process is in...
MORE
By Ken Rugg
Technology managers are rapidly modernizing their data infrastructures to achieve greater flexibility in today’s hypercompetitive marketplace. They need flexibility over their licensing portfolio, ability to configure modern applications, and choice of deployment environments to keep pace with digital transformation. The State of the Operational...
MORE