SQL Maestro Group announces the release of PostgreSQL Maestro 10.4, a powerful Windows GUI solution for PostgreSQL server administration and database development.
The new version is immediately available at
http://www.sqlmaestro.com/products/postgresql/maestro/.
New features:
Starting with this version it is possible to connect to remote PostgreSQL servers via SSH tunnel using a key-based authentication (in addition to the password-based authentication supported in the previous versions). To establish a remote connection in this way, you have to provide a private key (either in ssh.com or OpenSSH formats) and (optionally) a passphrase. This version also introduces support for both SSH-1 and SSH-2 protocols (whereas all the previous versions supported only SSH-1).
This version of the software has been successfully tested with Postgres Plus 8.x (both standard and advanced server).
Support for ascending and descending indexes and NULLS FIRST/LAST has been added (PostgreSQL 8.3+).
SQL Script Editor: notices and warning messages generated by the server are now bound to source SQL statements. Also displaying of such messages now can be disabled.
Support for rules containing several SQL statements has been implemented.
Starting with this version PostgreSQL Maestro can execute SQL scripts containing COPY FROM STDIN statements (like psql does).
The Script Runner window can now be invoked directly from the Tools menu. Also the productivity of this tool has been significantly improved.
Starting with this version it is possible to reorder servers in the Explorer Tree as well as reorder databases from the same server. You can also sort servers and databases in an alphabetical order.
Now all the database profiles related to the same server may be deleted at once.
Multi-column sorting has been implemented. To sort data on multiple columns, use the Advanced Sort command from the grid's header popup menu. Also we have added support for fixed columns (such columns are displayed permanently when working with other grid data).
There are also some other useful things. Full press release is available at the SQL Maestro Group website.
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.