Home A Better Way to Manage a Bunch of PostgreSQL Servers

A Better Way to Manage a Bunch of PostgreSQL Servers

The open source PostgreSQL project just got more manageable, with an announcement today from EnterpriseDB and its Postgres Enterprise Manager. This allows developers and DBA’s to monitor and manage both PostgreSQL (from v8.3 or later) and Postgres Plus Advanced Server installations regardless of the platform they run on from a single graphical console application. The management software runs on either Windows or Linux clients, and a Web-based version is also in the works.

As befitting an open source platform, there are plenty of other management tools out there to work with Postgres. What makes the EnterpriseDB tool different is that it is easy to install and use, especially for handling a large number of installed database servers and with a nice graphical look and feel, as you can see here. (Click to enlarge.)

Postgres Enterprise Manager includes the following enterprise-class enhancements:

  • Performance Monitoring Dashboards. Show at-a-glance information on I/O, storage, memory, user and session activity, wait statistics and more, as you can see above.
  • Alert Management. Pre-defined and custom alerts warn the user when issues or potential issues are detected.
  • SQL Profiler – Allows users to pinpoint, diagnose and fix poorly performing SQL code and trace SQL statements that are executed against one or more servers, as you can see below (click to enlarge).
  • Postgres Expert.A “DBA-in-a-Box” helps enforce PostgreSQL best practices with expert suggestions for schema design, security, configuration parameters, and more.
  • Capacity Planning and Forecasting. Capacity Manager allows reporting and provides trend analysis over time to understand peak load periods, storage consumption trends and gives the ability to customize reports including both graphs and tabular data.

All new Postgres Plus subscriptions will include the Enteprise Manager software, and existing users can download the software today at no additional charge. Or a separate subscription for the management software can be purchased for $1995 per socket. There is also a $495 fee for an annual one-server instance license if you want to start out small.

Some of the biggest users of Postgres are Skype, Yahoo and MySpace. More information can be found on Enterprise DB’s site.

About ReadWrite’s Editorial Process

The ReadWrite Editorial policy involves closely monitoring the tech industry for major developments, new product launches, AI breakthroughs, video game releases and other newsworthy events. Editors assign relevant stories to staff writers or freelance contributors with expertise in each particular topic area. Before publication, articles go through a rigorous round of editing for accuracy, clarity, and to ensure adherence to ReadWrite's style guidelines.

Get the biggest tech headlines of the day delivered to your inbox

    By signing up, you agree to our Terms and Privacy Policy. Unsubscribe anytime.

    Tech News

    Explore the latest in tech with our Tech News. We cut through the noise for concise, relevant updates, keeping you informed about the rapidly evolving tech landscape with curated content that separates signal from noise.

    In-Depth Tech Stories

    Explore tech impact in In-Depth Stories. Narrative data journalism offers comprehensive analyses, revealing stories behind data. Understand industry trends for a deeper perspective on tech's intricate relationships with society.

    Expert Reviews

    Empower decisions with Expert Reviews, merging industry expertise and insightful analysis. Delve into tech intricacies, get the best deals, and stay ahead with our trustworthy guide to navigating the ever-changing tech market.