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.
Database administrators need tools for database maintenance, performance optimization, configuration, and highly availability. EnterpriseDB (EDB) leads the industry in creating best-in-class Postgres tools to support DBAs with their mission critical enterprise deployments.
One example is Postgres Enterprise Manager® (PEM). PEM is a comprehensive...
MORE
MORE
By Bruce Momjian
When storing data in the database, there is an assumption that you have to trust the database administrator to not modify data in the database. While this is generally true, it is possible to detect changes (but not removal) of database rows.
To illustrate this, let's first create a table:
Continue reading on PostgresRocks to learn more. >...
MORE
MORE
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