Softpedia >Windows >Internet >Servers >Database Utils >PostgreSQL Maestro >  Changelog

PostgreSQL Maestro Changelog

What's new in PostgreSQL Maestro 22.10.0.1

Oct 18, 2022
  • All products of PostgreSQL family are now fully compatible with PostgreSQL 15 (the latest PostgreSQL version available at the moment).

New in PostgreSQL Maestro 21.12.0.1 (Dec 15, 2021)

  • New feature highlights:
  • This version of the software has been successfully tested with all database server versions up to PostgreSQL 14.
  • Support for the new multirange data types has been added (PostgreSQL 14). These data types store lists of the appropriate ranges.
  • Support for SSL connections has been added. SSL connections allow to encrypt client/server communications for increased security. Click the "SSL options" link in Create Database Profiles or Edit Database Profile windows and configure SSL in the modal window.
  • A new more efficient Table Partition Management mechanism has been implemented. In previous versions partitions were fetched and displayed in the explorer tree in the Tables list along with regular tables. For databases with a large number of partitions and subpartitions such list is very difficult to manage.
  • From now on it is possible to optimize this process. The new 'Optimize table partition management' option allows to manage partitions/subpartitions in the Partitions list of their parent tables. This hierarchical representation makes the partition management more visible and easy to use. Moreover, partitions are fetched on demand which significantly speeds up the Tables list refresh.
  • An ability to specify partitioning for a newly created partition has been added.
  • All software of our PostgreSQL family have been upgraded and come now with PostgreSQL 14 compatibility.
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

New in PostgreSQL Maestro 19.10.0.8 (Nov 10, 2021)

  • All products of PostgreSQL family are now fully compatible with PostgreSQL 13 (the latest PostgreSQL version available at the moment).

New in PostgreSQL Maestro 19.10.0.1 (Oct 28, 2019)

  • New feature highlights:
  • his version of the software comes with PostgreSQL 12 compatibility.
  • Support for generated columns has been added (PostgreSQL 12). Values of such columns are automatically computed based on a predefined expression. PostgreSQL currently implements only stored generated columns.
  • To create a stored generated column, just provide the generation expression in the Formula edit box.
  • Added support for planner support functions (PostgreSQL 12). It is possible to attach a planner support function to a SQL-callable function to improve optimizer support for it.

New in PostgreSQL Maestro 18.12.0.1 (Dec 20, 2018)

  • New feature highlights:
  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 11.
  • Support for a number of PostgreSQL 11 new features has been implemented as follows:
  • Support for the partitions based on hashing a key column has been added.
  • To create a hash partitioned table, turn ON the appropriate checkbox, then select "Hash" partitioning strategy and specify the partition key expression at the Properties tab of Create Table Wizard.
  • Creating a hash partitioned tablePicture 1Creating a hash partitioned table
  • To add a new partition of a hash partitioned table, open the Table Editor, switch to the Partitions tab, then use the "Create New Partition" command at the Navigation bar or the corresponding item of the popup menu and specify modulus and remainder properties for the new partition.
  • Adding a partition of a hash partitioned tablePicture 2Adding a partition of a hash partitioned table
  • Default partition can now be specified for partitioned tablesThe default partition will store rows that don't match any of the other defined partitions, and is searched accordingly.
  • Default partitionPicture 3Default partition
  • Support for SQL-level procedures has been implemented.
  • ProceduresPicture 4Procedures
  • Support for domains over composite types has been added.
  • Domain over composite typePicture 5Domain over composite type
  • Support for arrays of domains types has been implemented.
  • Creating an array of domainPicture 6Creating an array of domain
  • SSH client has been upgradedNow it supports more secure key exchange algorithms.
  • SSH Client has been upgradedPicture 7SSH Client has been upgraded
  • Restore database wizard has been implementedIt allows you to restore your database from an archive backup file or a directoryIt is possible to restore an existing database or a new one.
  • Restore database wizardPicture 8Restore database wizard
  • The wizard is equipped with a command line builderIt provides with a comfortable user interface for creating batch files for the pg_restore utility
  • Restore database wizard: Command line builderPicture 9Restore database wizard: Command line builder
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

New in PostgreSQL Maestro 17.8.0.1 (Aug 21, 2017)

  • New feature highlights:
  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 10 Beta 3 (the latest PostgreSQL version available at the moment).
  • Support for a number of PostgreSQL 10 new features has been implemented as follows:
  • Support for the native table partitioning has been added (PostgreSQL 10). Partitioning refers to splitting what is logically one large table into smaller physical pieces.
  • To create a partitioned table, turn ON the appropriate checkbox, then specify the partitioning strategy (Range or List) and the partition key at the Properties tab of Create Table Wizard.
  • You can optionally create partitions together with the partitioned table. To do so, switch to the Partitions tab at the third wizard step, then add partitions using the appropriate command from the popup menu.
  • To add a new partition to an existing table, open Table Editor, switch to the Partitions tab, then use the "Create New Partition" command at the editor navigation bar or the corresponding item in the partition list's popup menu.
  • Starting from this version it is possible to rename values of enumeration types.
  • Support for identity columns has been added. To add an identity column to a table, open Field Editor and check the appropriate option.
  • To customize an identity column, click the "Identity options" link and specify the necessary properties in the modal window.
  • In data grids and data input forms values of identity fields are filled automatically. The corresponding column headers are marked with the plus sign.
  • Support for restrictive row level security policies has been implemented (the previous versions of PostgreSQL support only permissive policies). By creating restrictive policies, administrators can reduce the set of records which can be accessed as all restrictive policies must be passed for each record.
  • Starting from this version it is possible to specify a custom label and/or a font color for server nodes in the Database Explorer tree.
  • The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.
  • Data Grid: now it is possible to copy the value of the selected cell to Clipboard using grid's popup menu or Ctrl+Shift+C shortcut.
  • "Show special chars" and "Convert tabs to spaces" options have been added to the Editor settings.
  • Links to our social networks accounts have been added to the Quick Launch panel. As minor versions are announced only in our Facebook and Twitter, we would recommend you to follow us somewhere to stay informed.

New in PostgreSQL Maestro 16.6.0.8 (Dec 19, 2016)

  • HIGHLIGHTS:
  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 9.6 Beta 2 (the latest PostgreSQL version available at the moment).
  • Support for Row Security Policies has been implemented (PostgreSQL 9.5+). Such policies restrict, on a per-user basis, which rows can be returned by normal queries or inserted, updated, or deleted by data modification commands.
  • Create Row Security Policy wizardPicture 1. Create Row Security Policy wizard
  • Support for BRIN Indexes has been added (PostgreSQL 9.5+). Also starting from this version it is possible to create indexes for materialized views.
  • The Generate Updatable View tool becomes available for PostgreSQL 9.2 and lower (for PostgreSQL 9.3 and higher it is available since version 14.5).
  • Updatable View GeneratorPicture 2. Updatable View Generator
  • "Allow Connections" and "Is Template" options have been added to Create Database Wizard and Database Editor (PostgreSQL 9.5+).
  • Create Database WizardPicture 3. Create Database Wizard
  • The "Show SQL Help" command now displays the manual that corresponds the version of PostgreSQL database server you are connected to. This means it will display this page if you are working with PostgreSQL 9.5, this one if you are working with PostgreSQL 9.4, and so on.
  • Show SQL Help commandPicture 4. Show SQL Help command
  • Support for Adobe Reader DC has been added to BLOB Editor. Also the editor window now saves its size and position between times it is opened (for each table).
  • BLOB EditorPicture 5. BLOB Editor
  • Default Data Import settings can now be set up in the Program Options dialog.
  • Data Import defaultsPicture 6. Data Import defaults
  • In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made

New in PostgreSQL Maestro 14.5.0.1 (May 23, 2014)

  • Server management extensions:
  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 9.4 Beta 1 (the latest version available at the moment).
  • We have also implemented support for some 9.x new features
  • Support for materialized views (PostgreSQL 9.3+) has been added. A materialized view is a database object that contains the results of a query. It uses a query to fetch its data like a view, but this data is stored like a common table. This feature is most useful in data warehousing scenarios, where frequent queries of the actual base tables can be extremely expensive.
  • The data refresh can also be used to truncate the data of the relation by running it with the enabled Leave in unscannable state option.
  • Current version allows you to use built-in range data types as well as to create your own ones (PostgreSQL 9.2+). A range data type stores a lower and upper bound belonging to its base data type. It supports operations like contains, overlaps, and intersection.
  • Support for the new jsonb "binary json" type (PostgreSQL 9.4). The new format accepts exactly the same data as the json type. However, it is stored in a format that does not require reparsing the original text in order to process it, making it much more suitable for indexing and other operations.
  • Support for smallserial data type (PostgreSQL 9.2+) has been added. This type is used for creating unique identifier smallint columns.
  • Function Editor: management of existing functions has been substantially improved. Starting from this version among other things, it is possible to
  • add, drop, rename, and reorder parameters;
  • change parameter data types and scopes;
  • set, modify and remove parameter default values;
  • change function return kind (single value, set of values, table) and return data type;
  • add, drop, rename and reorder output columns (for functions returning tables).
  • Now it's allowed to generate updatable views for your tables automatically. Moreover, the Insert, Update, and Delete operations can be enabled or disabled at your choice. It is possible to create a view for a single table or for several tables at once (even for all the tables in the database). To accomplish these tasks, use the popup menu of the corresponding node at the Explorer tree and the Main Menu | Object | Generate updatable views accordingly.
  • Starting from this version SQL Editor displays result sets for DML statements with the RETURNING clause.
  • Now it's possible to use view column's default values to be substituted into any INSERT or UPDATE command whose target is the view, before applying any rules or triggers for the view.
  • Interface improvements:
  • Starting with this version the warning appears on creating a table without a primary key.
  • Data Import features
  • Starting with this version it's possible to import data from several files at a time. To import data from multiple files with the same structure, set the mask of the file names to the corresponding field. To see the list of matching files, use with the button on the right.
  • The Column Builder for text files with fixed column width has been redesigned. Now to set the correspondence between table columns and areas of a text file, you can either input offset and width for each column directly into the controls, or define these values by clicking the left mouse button in the right area of the tool.
  • Now it's possible to add current timestamp to the log file name using the %ts:TIMESTAMP_FORMAT% string template. Examples of valid datetime formats are: 'YYYY-MM-DD', 'YYYY-MM-DD-HH24-MI', 'YYYY-MM-DD-HH24-MI-SS', and so on.
  • Now each time you start the wizard to import data to a table it stores all the options as them were set on the previous session of working with this table.
  • Data Export: Support for Json file format has been implemented.
  • Data Grid: to reset all grid settings to defaults, open the Data tab when holding the Ctrl key.

New in PostgreSQL Maestro 13.7.0.1 (Jul 13, 2013)

  • Server management extensions:
  • This version of the software has been successfully tested with all the modern database server versions up to PostgreSQL 9.3 beta 2 (the latest version available at the moment). We have also implemented support for some 9.x new features:
  • Current version allows you to manage foreign data access objects (PostgreSQL 9.3+). You can create, edit and drop such database objects as foreign servers, user mappings, and foreign tables as well as browse and edit data accessible through foreign tables. To learn more about the foreign data technology implemented in PostgreSQL server, please refer to the appropriate section in the PostgreSQL manual.
  • Support for composite types has been significantly improved: now you can add a new attribute to an existing composite type as well as edit, rename, and drop its attributes (PostgreSQL 9.1+).
  • Support for json data type (PostgreSQL 9.2+) has been added. Json (JavaScript Object Notation) data can also be stored as text, but this data type has the advantage of checking that each stored value is a valid json value.
  • Support for keyboard interactive SSH authentication has been implemented. This method provides for a multiple challenge-response dialog with the user in which the server sends a text query to the user, the user types in a response, and this process can repeat any number of times to ensure that the client is a human.
  • Get SQL Dump wizard has been significantly updated:
  • Now it is possible to rename output columns in the result SQL script. To set a new target column name, enter a value to the Target column in the grid at the first step of the wizard.
  • You can also change the order of output columns using the appropriate commands of the popup menu or Ctrl+Up and Ctrl+Down shortcuts.
  • Starting with this version it is possible to specify the SQL syntax the result script to be written on. This feature allows you to restore the dump contents to a table in a different database server such as MySQL, SQL Server, Oracle, Firebird, or SQLite.
  • Nullable Column Checker has been implemented. This feature allows you to refactor your database schema by enforcing omitted NOT NULL constraints. It is useful, for example, if you have got a legacy schema with a lot of columns allowing NULL values and plenty of data. To invoke the wizard, use the appropriate link in the Generate SQL section of the table popup menu at the Explorer tree.
  • Database Explorer: now it's possible to hide rarely used objects from the Explorer tree to reduce it size and speed up the database schema refreshing. For example, if you never work with remote data, you can disable the displaying of such objects as foreign servers, user mappings, foreign tables and so on.
  • Support for time with time zone and timestamp with time zone data types has been improved. Now it becomes easy to add such columns to a table and to enter their values in data grids with time zone abbreviations or with time zone names.
  • Interface improvements:
  • The Start Page has been redesigned in order to provide quick access to recently connected database profiles and display the latest company news.
  • SQL Editor features:
  • Now on executing several statements from a single editor tab (did you know about such a possibility?), the corresponding result tab is marked with an appropriate image.
  • Starting from this version you can copy the selected text from any editor to Clipboard as a ready-to-use string written in one of the following programming languages: C#, C++, Delphi (Object Pascal), and Java. This feature is accessible in the Export section of the editor area popup menu.
  • Database Explorer: now it is possible to assign a custom color to a certain database profile. For example, you can mark development and production databases in different colors in order to prevent casual metadata or data changes in the production. The desired color can be selected at the Options tab in the Edit Database Profile dialog.
  • Hints for foreign key columns now include the name of the parent table. Hints for domains contain the information about the underlying data type of the domain.
  • Script Runner allows now to execute archived scripts directly from .zip files. The tool unpacks zip archives to temporary files by itself for further executing.
  • Data Grid features:
  • Multi-column lookup editors become available. Such editors modify values of several columns in the record simultaneously in order to guarantee referential integrity.
  • Now the headers of primary and foreign key columns are marked with the 'gold key' and 'silver key' images accordingly as well as the headers of required columns are marked with a red asterisk. The existence of any column marked with a gold key in the dataset means that you can modify/delete the records of this dataset without risk of updating/deleting several records at a time.
  • Data Export: now it is possible to specify decimal and thousand separators for the generated files (when applicable).

New in PostgreSQL Maestro 11.8.0.2 (Dec 1, 2011)

  • Server management extensions:
  • This version of the software has been successfully tested with PostgreSQL 9.1 RC1. We also implemented support for INSTEAD OF triggers on views implemented in that version.
  • The Split Table Wizard has been implemented. This feature allows you to refactor your database schema vertically splitting an existing table into two tables that is useful, for example, if you need to enforce referential integrity on a set of columns. Generated SQL scripts will modify the primary table, create a secondary table with a primary key from shared columns (i.e. columns that exist in both primary and secondary tables), and then transfer data from the primary table to the secondary one without duplicating of data. To invoke the wizard, use the popup menu of the corresponding node at the Explorer tree or the Main Menu | Object | Split Table menu item.
  • Support for variadic parameters has been implemented (PostgreSQL 8.4+). Such parameters allow you to write a function with an indefinite number of argumets, as long as they are all the same data type.
  • Now it's allowed to generate updatable views for your tables automatically. Moreover, the Insert, Update, and Delete operations can be enabled or disabled at your choice. It is possible to create a view for a single table or for several tables at once (even for all the tables in the database). To accomplish these tasks, use the popup menu of the corresponding node at the Explorer tree and the Main Menu | Object | Generate updatable views accordingly.
  • Interface improvements:
  • Now the application allows you to use Code snippets, segments of reusable code that you can copy into the editor. The feature is available from SQL Editor, SQL Script Editor, and editors of objects containing SQL bodies (such as views, triggers, etc.) with the corresponding item of the popup menu or with Ctrl+J shortcut.
  • Table Editor: Another way of index creating has been implemented. Now you can create a new index directly from the Fields tab of the table editor. To add an index, select column(s) the new index to consist of and use the Create index on columns... command.
  • Data Import: starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. Let's look through some details of the new feature:
  • To import data in this way, you have to specify a connection string and select appropriate identifier quote characters to escape improper symbols and blanks in object names according to the source database (for example, double quotes for Oracle and PostgreSQL, backticks for MySQL, or square brackets for SQL Server and MS Access).
  • Another thing to note is that this kind of import completely supports BLOBs (if they are supported by the ODBC driver / OLE DB provider used).
  • Now each time you start the wizard to import data to a table it stores all the options as them were set on the previous session of working with this table.
  • The Execute at cursor command has been added to SQL Editor (available in the Navigation bar or with Ctrl+F9 shortcut). Use this command to execute statements the cursor is over without selecting them.
  • Database Designer features:
  • Now you can view all columns included in a foreign key by selecting the relation based on the foreign key.
  • All print options are now preserved between sessions.
  • BLOB Viewer: starting with this version it's possible to view or edit BLOB data as PDF document.
  • Prepared database reports now run fine on UNIX systems.
  • Table Editor Options: starting with this version it's possible to allow the application to open details at the Data tab automatically.

New in PostgreSQL Maestro 10.4.0.1 (Apr 23, 2010)

  • Postgres Plus support, improved Script Runner tool, updated data grids, support for ascending and descending indexes, and some other useful things.

New in PostgreSQL Maestro 9.5.0.0 (May 28, 2009)

  • Support for some PostgreSQL 8.4 new features, completely rewritten Data Import wizard and other useful things.

New in PostgreSQL Maestro 9.2.0.4 (Mar 17, 2009)

  • Version 9.2 features improved table inheritance support, new Data Export wizard, advanced transaction management, updated Visual Query Designer and other useful things.

New in PostgreSQL Maestro 8.10.0.1 (Oct 8, 2008)

  • Features remote database management via HTTP tunneling, significantly improved Data Import wizard, updated Trigger Editor, and a lot of other useful things

New in PostgreSQL Maestro 8.3.0.2 (Apr 11, 2008)

  • PL/pgSQL Debugger added. It is a tool to debug PL/pgSQL functions using traditional debugging features.
  • The Quick Connect mode has been implemented. Use it to skip metadata refreshing when connecting to a database (for example, to execute a query or SQL script).
  • A French localization is now included into the installation package.
  • This version of our software is fully compatible with large fonts (120 DPI).
  • Extract database wizard: common database properties and program info are now included into the result scripts.
  • SQL Editor: a popup menu has been added to each query tab. Using this menu you can create a new query, close existing one, save the query to profile, etc even if editor's navigation bar is closed.
  • Create Database Wizard, Create Profiles Wizard, and object creation wizards become resizable.
  • Data import wizard: the interface for adding and editing of replacements has been slightly improved.
  • The F11 key is now used to show/hide the Explorer tree.
  • Data grid options: it is now possible to restrict maximum column width.
  • SQL Script Editor settings: the "Use script runner for large scripts" option has been added.

New in PostgreSQL Maestro 6.12.0.3 (Mar 5, 2007)

  • Now it is possible to specify fill factor when creating/editing tables and indexes;
  • Support of CONNECT privilege for databases and USAGE privilege for sequences is added. For setting sequence-specific permissions the GRANT ON SEQUENCE syntax is used instead of GRANT ON TABLE one;
  • Now it is possible to empty a table together with all foreign-key referencing tables;
  • Now it is possible to create a domain based on another one;
  • Added support for comments on server-scope objects such as roles and tablespaces.
  • The Make primary key and Clear primary key commands are now accessible anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc);
  • Since this version PostgreSQL Maestro can display native type names such as int4 instead of SQL-standard ones (e.g. integer).
  • SQL Formatter is done: you can beatify all the DML statements (SELECT, INSERT and UPDATE) in the SQL Editor. Also it is possible to format view definitions;
  • The tabbed interface is implemented in addition to classic MDI (see screenshot). You can choose your favorite UI in the Options dialog;
  • SQL Script Editor: if a user opens a file larger than 100K, PostgreSQL Maestro will suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute script from file" link on the Script Editor navigation bar and specify the filename;
  • We have implemented the Data Analysis, a tool to represent your data as OLAP cubes
  • Database profiles are now grouped by host port login combination rather than host port in the previous versions;
  • The Table Editor interface is improved: now all the subitems i.e. fields, indexes, and triggers are displayed at the main editor tab. We found this layout more comfortable;
  • BLOB Viewer / Editor: the text pane provides now several types of text highlighting (Plain text, HTML, JScript, CSS, PHP, XML, SQL, and PostgreSQL DDL). Also it is possible to find and replace a text fragment of a BLOB column data;
  • It is now possible to refresh schema object list whenever an object depends on other objects e.g. refresh table list on view creation;
  • Since this version PostgreSQL Maestro can hide empty schemas. The corresponding setting can be found at the Explorer page of the Options dialog;
  • The Insert key is now a shortcut for creating a new database object from the Explorer tree;
  • Create profiles wizard: we've added an option for converting new object names to lower/upper case;
  • Data grid: the speed of data loading was significantly increased.