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 Dave Page
A couple of common questions I hear from customers (usually long-time users of a particular database from Redwood) via our guys in the field is “why do we install our software as root?” And “why do we run services as postgres?”. The simple, TLDR; answer is “for security”.
A basic principle when securing a software installation is “install with...
MORE
MORE
Choosing a database solution is one of the most important decisions for a company that is rolling out a website or developing a new in-house application. The open-source version of PostgreSQL can be a good option for small companies. But enterprise-level database applications often require more tools and capabilities in order to scale. The EDB...
MORE
MORE
PostgreSQL has advanced in terms of features, performance, and scalability for many core systems. However, one of the problems that many enterprises still complain about is bloat. But, there is a new project that we're working on that is going to be transformative for PostgreSQL, enabling us to get better control of bloat.
We call it zHeap....
MORE
MORE
The rate of adoption of cloud services among central and local government, and other public sector bodies, is clearly on the increase, which is not surprising given the UK Govt Cloud First strategy. There are obvious benefits for organisations looking to reduce their expenditure and increase the flexibility of their IT infrastructures, so we are...
MORE
MORE
By Bobby Bissett
EDB Postgres Failover Manager (EFM) supports multiple ways to connect applications with the new master database after a failover or promotion. In many cases, a virtual IP address (VIP) can be used, and Failover Manager will move the VIP as needed. On cloud providers where the VIP is not an option, script hooks can be used to move a resource (e.g...
MORE
MORE
By Bruce Momjian
I’ve come to the end of my time in Europe now and I thought I’d share some of the feedback I’ve received from EDB customers along the way. I’ve been to Stockholm, Paris and Amsterdam, before heading on to Prague, Milan and Brussels.
During the Paris session we met with a mix of general Postgres users, those investigating the technology and EDB...
MORE
MORE
By Ken Rugg
Is ACID a Priority or Not? Can MongoDB Decide?
If I’m honest, I think of MongoDB as more of a “data store” than an actual database. This may be a controversial opinion these days, but I don’t think it’s a hard position to support. Granted, MongoDB does a great job storing data for a particular use case and can be highly optimized for that purpose...
MORE
MORE
By Ken Rugg
Not that long ago, the role of the DBA was comprised of a lot of mechanical tasks, including upgrades, basic system maintenance, backups and recovery, monitoring, performance tuning, and troubleshooting. With the advent of the cloud, automation and DevOps, the DBA’s role and responsibilities are rapidly evolving.
There are even some who would...
MORE
MORE
By Jeevan Chalke
As the name suggests, a nested subprocedure allows us to write a function or procedure nested within another function or procedure. It means a function can have another function within it, just like its own variable. And, as this inner function is part of the outer function, it has no visibility outside the function that encloses it. Also, there...
MORE
MORE
By Marc Linster
Taking our experiences over the past 10 years migrating hundreds of Oracle databases, we’ve introduced the beta version of our EDB Postgres Migration Portal – the first web-based tool for moving Oracle database schemas to the EDB Postgres Platform.
The Migration Portal rapidly assesses an existing database for compatibility with EDB Postgres ...
MORE
MORE