PostgreSQL 9.3.5.1 / 9.4.0 Beta 3

A powerful, open source relational database system worth having when you need to manage multiple databases, run SQL scripts, as well as create procedures and triggers
PostgreSQL is a comprehensive and practical database design and management system geared toward administrators who need to organize and control multiple databases, run SQL queries, as well as create new triggers and attributes.

Designed as an enterprise class database, PostgreSQL boasts powerful features such as point in time recovery, asynchronous replication, nested transactions and tablespaces, to name a few. What’s more, the program comes with support for multibyte character encodings and it is locale-aware for sorting all the scripts available in one file.

The installation process does not require you to perform any advanced configurations, however, when you add a password (which is mandatory when you need to connect to the default server), you need to memorize it, otherwise you will not be able to use PostgreSQL.

The application comes with an intuitive and user-friendly interface and with well-organized menus. In the main window you are able to view the structure of the available databases. You can easily create objects, delete and edit existing ones, manage multiple tables and perform actions such as delete, insert, drop or alter.

The left panel of the application displays a hierarchical tree with all the available servers and the objects they contain, such as tablespaces, schemas, catalogs and triggers.

The upper right side displays detailed information about the currently selected object available in the tree view. Tabs such as ‘Properties’, ‘Statistics’, ‘Dependencies’ and ‘Dependents’ enable you to get a better overview of the selected object.

The lower right side contains a reverse engineered SQL script that allows you to copy it to any editor using cut and paste, or simply save it to a new file.

By using the Query tool, you are able to execute arbitrary SQL commands with ease. You can also indent text to the same depth as the previous line when you press return, shift the selected text to upper or lower case, as well as comment out SQL scripts.

Furthermore, PostgreSQL comes with a practical debugger that helps you to quickly debug pl/pgsql functions, stored procedures and packages. Once the debugger session has started, you can step through the code effortlessly using the keyboard shortcuts or the available toolbar buttons.

Also, the application comes with intuitive functions namely Vacuum, Analyze and Reindex that help you to maintain database objects within seconds. The first function scans the database or table for rows that are not in use anymore. In case a row is updated or deleted, the previous content is not replaced, but rather marked invalid. The second function, entitled Analyze, investigates all the available values that each selected database or table contain. The Reindex function helps you to quickly rebuild the indexes in case these were modified by unusual inserted data patterns.

Overall, PostgreSQL proves to be a steady solution that helps DBAs to quickly manage multiple databases and since it comes with support for various programming languages including Perl, Java, Ruby, C/C++ and Python, it is able to run different stored procedures and SQL scripts.

Reviewed by on December 16th, 2013


last updated on:
October 9th, 2014, 12:47 GMT
file size:
52.1 MB
price:
FREE!
developed by:
PostgreSQL Global Development
license type:
Freeware
operating system(s):
Windows XP / Vista / Vista 64 bit / 7 / 7 64 bit / 2003 / 2008
category:
C: \ Internet \ Servers \ Database Utils
download hub:
Server Managers ( + 1 other )

FREE!

In a hurry? Add it to your Download Basket!

softpedia rating

5.0/5

user rating 32

4.4/5
 

0/5

8 Screenshots
PostgreSQL - The main window of the application can be used to view all the servers and access all the options.PostgreSQL - The right click context menu can be used to add new object and delete servers.PostgreSQL - From the Edit menu you can create new objects and reset all the table statistics.PostgreSQLPostgreSQLPostgreSQLPostgreSQLPostgreSQL
What's New in version 9.4.0 Beta 3
  • Rename pg_recvlogical's --create/--drop to --create-slot/--drop-slot
  • Prevent unbounded delay when starting background worker
  • Remove num_xloginsert_locks GUC, replace with a #define
  • Fix pg_dump's --if-exists for large objects
read full changelog
 

Application description

PostgreSQL has more than 15 years of active development and a proven architecture that has earned it a strong reputati...

Add your review! 1 USER REVIEW SO FAR

SUBMIT