New features for PostgreSQL database admins
New features for PostgreSQL database admins
Written by Kay Ewbank   
Thursday, 01 September 2011

An easier way to manage PostgreSQL databases has been released by EnterpriseDB.

Managing PostgreSQL has until now required scripts and the use of command line tools, but the new tool is graphical and much easier, according to from David Page, Senior Software Architect at EnterpriseDB.

According to the blog post, Postgres Enterprise Manager is based on the Open Source pgAdmin project, with the addition of a number of features for sysadmins, DBAs and developers with a focus on management of multiple servers.

Pgadmin is the command line tool that has till now been the main way of managing PostgreSQL. In addition to the graphical interface, the Enterprise Manager adds a dashboard showing details of how storage and memory are being used, along with what users and sessions are active. The software also has over 130 different alert templates that can be used to build customised alerts to warn when aspects of your database go outside of the norm.

There’s a SQL profiler that can be used to trace SQL statements and to identify SQL that is performing badly and why the performance is poor. Poorly running queries can also be run through the Index Advisor when work working with Postgres Plus Advanced Server advising on and optionally creating new indexes to improve query performance.

A utility called Postgres Expert is also included that analyses your Postgres servers and database schemas, advising on possible misconfigurations or sub-optimal designs.

EnterpriseDB is also launching a new Postgres Plus Cloud Server service. This will let companies use the database as a service with features including replication and failovers.

You can try out the first version of the Postgres Enterprise Manager (which can be used with both the free PostgreSQL and EnterpriseDB's commercial Postgres Plus Advanced Server) by downloading it from: http://www.enterprisedb.com/download-postgres-enterprise-manager.

 

To be informed about new articles on I Programmer follow us on Twitter or Facebook or subscribe to our weekly newsletter.

Banner


Amazon Opens Up Alexa To Developers and Third Parties
25/06/2015

Amazon's Alexa provides a cloud-driven way to add voice technology to services and devices and there's a role, and the potential for seed funding, for both developers and hardware manufacturers.  [ ... ]



Joy In the App Store - You Can Test Your iOS App For Free
09/06/2015

Developers no longer need to shell out $99 to test their iOS apps on their own devices; all you need is XCode 7 and an Apple ID. Devs who have signed up to either of the separate OSX or iOS Apple [ ... ]


More News

Last Updated ( Thursday, 01 September 2011 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2015 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.