The PostgreSQL manager runs on all the popular operating systems including Windows, Mac OS X, and Linux. It allows you to manage, monitor and tune large scale Postgres installations in a smart and efficient manner. Some of its features include server auto-discovery, pre-configured ready-to-run probes, custom probes, personalized alerts, remote monitoring, custom dashboards and web clients. The DBA tools include database objects management, audit manager, log manager, log analysis expert and team support. The developer tools include query tool, data grid, SQL profiler, SQL debugger and import tools. Besides this, you have the tuning tools that include tuning wizard, performance diagnostics, index advisor and at-a-glance performance dashboards.

The PostgreSQL Administration and Management Tools include pgadmin, which is the most popular administration and development platform for PostgreSQL. This platform is full of multitude of features and it can be used on Linux, FreeBSD, Solaris, Mac OS, and Windows platform to manage PostgreSQL 9.2 and above. It can also manage the commercial and derived versions of PostgreSQL such as EDB Postgres Advanced Server.

Pgadmin addresses all the needs of the users ranging from writing simple SQL queries to developing complex databases. The GI can run on desktop as well as web server. And support all the common PostgreSQL features. It also consists of a syntax highlighting SQL editor. This software is built using Python and JavaScript/jQuery and is free of cost.

Although PostgreSQL is the most advanced database in the world, it suffers from some limitations. Its biggest limitation is that it lacks dedicated open-source monitoring tools. If you compare it to its competitors, you will see that the PostgreSQL community has not been able to produce tools that are similar to Oracle Grid Control, MySQL Workbench or SQL Server Management Studio.

Feel free to write us at hello@micropyramid.com to know more about it.