RSS

PostgreSQL (PostgresPro)

Product
The name of the base system (platform): PostgreSQL DBMS
Developers: Postgres Professional
Last Release Date: 2022/05/11
Technology: SaaS - Software as service,  DBMS

Content

Main articles:

2022

Compatible with all Axelot solutions

All software solutions developed by AXELOT have been certified and officially confirmed the ability to work with Postgres Pro. Axelot announced this on May 11, 2022.

The compatibility of AXELOT products with Postgres Pro confirms the independence of the company's software solutions from foreign developments in terms of management. databases This is especially true when more organizations are forced to think about import substitution ON the full transition to. domestic software

As a result of testing, all AXELOT products received certificates officially confirming full compatibility and the ability to work with Postgres Pro.

Tegu Enterprise Mail Server Compatibility

On April 8, 2022, the MBC laboratory announced that, together with Postgres Professional, they had completed a set of tests of their software products.

As part of the end-to-end solution on the Baikal-M processor

A group of Russian developers consisting of RED SOFT, BellSoft, Postgres Professional and EMDEV confirmed the correct collaboration of their software products. The Postgres Pro DBMS installed will make it easier for users to work with it. This was announced on January 12, 2021 by BellSoft. This Java stack will be used to refine and deploy the Incomand enterprise portal. More details here.

2021

Postgres Pro Standard 14.1.1 with increased reliability and ease of use

Postgres Professional on December 17, 2021 introduced the version of Postgres Pro Standard 14.1.1.

This release is based on PostgreSQL 14.1, its distinctive feature is that the release contains all the features and improvements of the main, original version - PostgreSQL 14, as well as corrections made to PostgreSQL 14.1. In addition, the version includes improvements to protect data, improve reliability and ease of use.

Postgres Pro Standard 14.1.1 adds advanced information security tools to Postgres Pro Standard. Built-in mechanisms for checking the integrity of executable files, configuration files, and system tables, as well as data protection mechanisms that allow you to reset objects before deleting.

The pg_proaudit module allows you to monitor various security events, and advanced authentication policies provide effective password management and access control.

Another qualitative change - pgpro_pwr has been updated in Postgres Pro Standard 14.1.1. Now the Load distribution section is added to the report, which shows how the load is distributed across heavily loaded objects, such as databases, applications, nodes, or users, in terms of resources (total time or number of shared blocks written, etc.). In addition, report tables "Session statistics by database" and "WAL statistics" were added - based on new views and fields that appeared in Postgres Pro 14.

Postgres Pro Standard 14.1.1 also discontinues support for the legacy sr_plan extension and does not have a WAITLSN statement that is incompatible with the SQL standard. Mamonsu has been upgraded to version 3.1.0, which supports Postgres Pro 14 and adds a new feature to the bootstrap command.

Aprentis platform compatibility

Russian software developers GC DZ Systems and Postgres Professional announced the compatibility of their products. This became known on September 21, 2021. Now the Aprentis platform, which allows you to create applications for any emerging tasks almost without programming, will work with the Postgres Pro DBMS. More details here.

Representation of the version of the Galaxy AMM system on the Postgres Pro DBMS

On August 26, 2021, the production control system "Galaxy AMM" was presented on the Postgres Pro DBMS. More details here.

Nutanix AOS Compatibility

On June 22, 2021, Nutanix announced that Postgres Pro solutions received Nutanix Ready status. Companies have conducted advanced testing to ensure the compatibility, performance, and reliability of Postgres Pro databases in Nutanix computing environments.

This collaboration offers additional opportunities to select infrastructure solutions for the PostgreSQL user community around the world. At the same time, Nutanix customers have access to the most advanced database data with. open source Postgres Pro databases located virtualized in Nutanix environments provide compatibility, correct operation of built-in functions, high performance and scalability capabilities specific to both companies.

Testing was performed for Postgres Pro Standard and Postgres Pro Enterprise versions on a hyperconvergent computing platform running Nutanix AOS. The operation of the databases was tested both in conjunction with the embedded Nutanix AHV hypervisor and the ESXi hypervisor.

Key benefits available to Nutanix and Postgres Pro customers:

  • Enterprise-level DBMS, including for high-load systems, based on open code with improved performance, reliability, and security features,
  • validated hardware and software platforms, including standard technical solutions and sizing tools for rapid deployment,
  • Predictive scalability of infrastructure through web-scale architecture.

{{quote 'Our solutions are designed to build large clusters of PostgreSQL with high availability. We worked to achieve high efficiency and reliability in virtualized Nutanix environments. This goal is achieved, which is subject to joint tests. Now we expect that an increasing number of customers using Nutanix private and public clouds will be able to evaluate our products and find an excellent alternative to closed DBMS in them, "said Oleg Bartunov, CEO of Postgres Pro. }}

{{quote 'We see an increase in the popularity of open development databases, including Postgres Pro. The company provides solutions with more than competitive characteristics, as well as the necessary services. Now Postgres Pro solutions are validated and marked with Nutanix Ready status, which will simplify the selection of IT infrastructure for open source databases and ensure that all components work together and with the predicted result, "says Igor Kornetov, technical director of Nutanix in Russia and the CIS. }}

Compatibility with CFT Corporation

The Financial Technology Center and Postgres Professional have signed a formal cooperation agreement. As a result of this stage of partnership the number of solutions of a CFT and the clients using rossiyskuyusubd Postgres Pro will be expanded. This was announced on May 12, 2021 by the CFT. More details here.

Postgres Pro version 13 compatibility with RuBackup backup module

On April 20, 2021, Rubekap announced that, together with Postgres Professional, they had completed a set of compatibility tests for their software solutions.

As of April 2021, the RuBackup system supports full and differential backups of any Postgres Pro 13 database clusters. More details here.

2020

Docsvision 5.5.2 Availability

On October 30, 2020, it became known that it was released, updated Docsvision platform version finalized in the field of speed, stable operation and scalability and supporting work DBMS PostgreSQL with and Postgres Pro. Now domestic support DBMS is included in the official release of the 5.5.2 platform. More. here

Postgres Pro Standard 11 and Standard 12 compatibility with the Polycode platform

Start Postgres Pro Cloud

On July 16, 2020, it became known that the cloud platform Mail.ru Cloud Solutions, together with Postgres Professional, developed a cloud managed database service provided according to the Database-as-a-Service - Postgres Pro Cloud model. Provides reliable and secure information storage, system responsiveness, and easy scaling.

The partnership Russian between DBMS Postgres Professional cloudy Mail.ru and Cloud Solutions allows you to improve the performance of the relational management system, databases as well as eliminate the need for customers to invest in the purchase of hardware and software resources. In addition, the solution provides ease of database scaling: in the cloud, you can increase the volume and capacity.

The managed database service developed by partners - Postgres Pro Cloud - is available to users in the Database-as-a-Service format. Thanks to this approach, the client in several clicks gets the database ready for operation in the desired configuration. The DBMS is installed, configured and maintained externally. provider Deploying the database in the cloud allows you to organize safe storage: data high availability and reliable Information Protection together Backup with fault-tolerant storage mitigate the risks of loss and. To leaks work with data, users of the cloud platform can connect analysts and build processing services on this basis. Data Lake

Companies interested in using a scalable and secure database with a second-by-second fee for expendable resources can transfer data to Postgres Pro Cloud from any source: private or public cloud or physical infrastructure. Mail.ru Cloud Solutions and Postgres Pro experts help with migration and advise on the construction of a scalable and fault-tolerant storage structure, as well as on-premise interoperability, ETL and Streaming processes, Data Warehouse and Data Lake.

File:Aquote1.png
With Postgres Pro in the MCS cloud, our customers can work with data. We are pleased to offer platform users a convenient database as a service with secure storage, additional services and support from our specialists, "said Ilya Letunov, head of Mail.ru Cloud Solutions.
File:Aquote2.png

File:Aquote1.png
Cloud services are another stage of development for databases and DBMS, so collaboration with Mail.ru Cloud Solutions was an important step for us. The portfolio of cloud solutions of the MCS platform allows you to raise Postgres Pro to a different level and make the DBMS an even more accessible service for users - Ivan Panchenko, co-founder, deputy general director of Postgres Professional.
File:Aquote2.png

As part of PAK BaseALT, EOS, Postgres Professional and Norsi-Trans for MFC automation

2019

Inclusion in products DeviceLock

October 22, 2019 it became known that DeviceLock included support for Postgres Pro and PostgreSQL in its products. More details here.

Security Vision Compatibility

On June 28, 2019, Security Vision announced that they, together with Postgres Professional, confirmed the compatibility of a number of their software products. They became technology partners and issued appropriate compatibility certificates. The details are here.

Compatibility with DirectumRX

On May 30, 2019, DIRECTUM announced that they, together with Postgres Professional, checked the compatibility of their products - ECM systems DirectumRX and Postgres Pro DBMS. The results of technical testing proved the correctness of their joint work. More details here.

Live Universal Interface Compatibility

On April 15, 2019, FORS Telecom announced the appearance in the ecosystem of software and tools compatible with the open Postgres platform Pro/PostgreSQL the designer of user web interfaces to databases - Live Universal Interface (LUI). More details here.

Compatibility with SafePhone

On March 27, 2019, Postgres Professional announced that together with the Research Institute of SOCB, they tested the compatibility of their solutions. The test results confirmed the full compatibility of the EMM platform SafePhone 4.0 with the Postgres Pro Certified 10 DBMS.

PostgresPro
File:Aquote1.png
Earlier in the EMM solution of SafePhone DBMS of mainly foreign production were used that owing to active policy of import substitution was the blocking factor for some organizations, - the Head of Department of marketing and sales Maria Yukhova reports, - Now we are glad to offer our customers the mobile SafePhone platform with use of the certified DBMS of domestic production - Postgres Pro Certified 10. In this configuration, the SafePhone 4.0 mobile platform is great for organizations that are highly responsible for regulatory compliance.
File:Aquote2.png

File:Aquote1.png
The compatibility of the Russian Postgres Pro DBMS and the secure mobile platform SafePhone opens up good prospects for state and large corporate customers, being an example of vertical integration of domestic software. - commented the commercial director of Postgres Professional Andrey Fleyta
File:Aquote2.png

Compatibility with Alt Family OS

On March 26, 2019, BaseALT announced that, together with Postgres Professional, they had successfully completed compatibility testing of the latest versions of the Postgres Pro Standard v. 11 DBMS by Postgres Professional and the Alt operating systems (OS) family developed by BaseALT. Validated product collaboration to recommend products for enterprise IT infrastructure of all sizes and complexity.

File:Aquote1.png
Alt operating systems and Postgres Pro Standard DBMS form a system platform that can serve as the basis for building a corporate IT infrastructure of any scale and complexity, "said Alexey Smirnov, General Director of Bazalt ACT. - The platform is capable of operating on domestic computer equipment of different architectures, is compatible with a wide range of domestic application software, which makes it possible for organizations to completely switch to technologically independent domestic solutions.
File:Aquote2.png

The complex of Alt operating systems, the built-in infrastructure software (Samba DC, SOGo, virtualization tools) and Postgres Pro DBMS are supported as a whole. The vendor technical support service is provided by ALP Group, which has a developed technological service platform. The customer receives technical support for the products of the complex on the basis of a single service contract and service level agreement (SLA ), valid throughout Russia. If necessary, the serviced complex can be extended with other software, as well as hardware.

File:Aquote1.png
With the release of each next version, we pay great attention to maintaining the compatibility of Postgres Pro with the products of our partners, "commented Ivan Panchenko, Deputy General Director of Postgres Professional. - Alt operating systems are in demand among many Russian customers, these are one of the leaders in the Russian operating systems market, so partnership with BaseALT and integration of our products are of strategic importance to us.
File:Aquote2.png

OS Alt Workstation 8, OS Alt Workstation K 8, OS Alt Education 8, OS Alt Server 8 are distributions based on the Linux kernel, including an operating system and a set of applications for full operation, supporting various additional equipment.

Compatibility with Lotus OS

On March 18, 209, Postgres Professional announced that according to the results of technical testing, the compatibility of the Postgres Pro database management system and the Lotus operating system was confirmed. More details here.

Compatible with Documino SED

On March 4, 2019, AID- Management Technologies, the developer of the Documino ECM platform, and Postgres Professional, the developer of the Postgres Pro database management system, announced the compatibility of their software products. More details here.

Compatibility with CompanyMedia

On February 21, 2019, Postgres Professional announced that, together with InterTrust, they had tested the compatibility of their solutions. The results of the testing confirmed the full compatibility of the document-oriented business process management system "CompanyMedia 5" with the Postgres Pro 10 DBMS. More details here.

Compatibility with "1C:Enterprise 8 "

On February 14, 2019, the company 1C Joint Stock Company announced that according to the results of technical testing, the compatibility of the 8 platform 1C: Enterprise with the tenth versions of the Russian database management systems Postgres Pro was confirmed: Postgres Pro Standard 10.6, Postgres Pro Enterprise 10.6 and Postgres Pro Enterprise 10.3.3 (certified). FSTEC Customers can build under,,,,,, operating systems Windows CentOS Rosa. Debian Ubuntu Alt Linux More. here

Compatibility with Forsyth. Analytical Platform

On January 23, 2019, Forsyth announced that, together with Postgres Professional, they continue to develop a technology partnership. Companies ensured compatibility of their solutions, combining the capabilities of the Forsyth software complex . Analytical Platform "and Postgres Pro DBMS. More details here.

2018

Compatibility with Red OS

On December 27, 2018, RED SOFT announced the continuation of cooperation with Postgres Professional and testing for compatibility of its products. The test results confirmed the correct operation of the latest version of the Postgres Pro 11 database management system on the domestic operating system RED OS 7.1 MOORE. As a result, a two-way compatibility certificate was signed.

File:Aquote1.png
author '= Rustam Rustamov, Deputy General Director of RED SOFT '
RED SOFT and Postgres Professional are friends in several planes. In addition to bilateral technological cooperation, we work shoulder-to-shoulder in the Committee on integration Russian ON Cooperation, ARPP "Domestic software" jointly participate in events under the auspices of this structure. Testing for compatibility of our products is a natural process.
File:Aquote2.png

File:Aquote1.png
author '= Ivan Panchenko, Deputy CEO of Postgres Professional '
In March 2018, we entered into a technology cooperation agreement with RED SOFT. And we have already seen significant results both in ensuring the compatibility of our products and in joint activities to promote the interests of Russian software.
File:Aquote2.png

Compatibility with "Logic: SZ EDO" and "Logic: SED"

The company Business Logic"" on November 21, 2018 announced that the company Postgres Professional confirmed the technological compatibility of products "Logic: SZ EDO" "Logic: SED" with () database management systems DBMS Postgres Pro 10 and Postgres Pro Certified 10 (version certified). FSTEC More. here

Postgres Pro Standard 10.5.1 and 9.6.10.1

On August 21, 2018, it became known that Postgres Professional released Postgres Pro Standard minor database updates based on PostgreSQL 10.5/Postgres Pro Standard 10.4.1 and PostgreSQL 9.6.10/Postgres Pro Standard 9.6.9.1.

Postgres Pro for Major Releases 10 and 9.6 - Postgres Pro Standard 10.5.1 and Postgres Pro Standard 9.6.10.1 have been updated

Postgres Pro Standard 10.5.1 и 9.6.10.1

Postgres Pro Standard 10.5.1

The release is based on PostgreSQL 10.5 and Postgres Pro Standard 10.4.1. Important changes and improvements:

  • The pg_variables module now supports transactional variables.
  • The auto_explain module can now output scheduling time.
  • Fixed an error that made it impossible to use some Hunspell dictionaries with FLAG num affixes, for example, ru_aot.
  • The pg_probackup module has been upgraded to version 2.0.19, which has the following features:
    • You can now restore the cluster to a specified log position (LSN).
    • If one of the parent copies is corrupted, this incremental copy gets ORPHAN (Lost).
    • The show-config command now shows both the changed pg_probackup parameters and the values that remain unchanged. Its conclusion can now be obtained in JSON format to simplify perception.
    • The restore command may skip copy validation to speed up cluster recovery.
    • Enhanced parallel incremental copy execution.
    • You can now combine incremental copies with the parent full copy to save disk space. Be careful, this is an experimental possibility - interrupting the merge process can damage backups.

  • Enhanced Postgres Pro Standard for Windows:

    • The implicit limit on the number of concurrent files opened in each server subprocess has been eliminated.
    • Added the ability to disable checksums in the cluster. By default, checksums are enabled when you install Postgres Pro.
    • Added pg_probackup module support.

When upgrading from a Postgres Pro Standard version based on the same major PostgreSQL release, it is sufficient to install the presented version in the current installation directory. When upgrading from 10.3.2 and later, you must run the REINDEX command on indexes that use mchar or mvarchar types.

If you previously used pg_repack on Debian-based systems, you will need to reinstall the package manually when you upgrade to 10.5.1 because it was renamed pg-repack-std-10.

To upgrade from a PostgreSQL or Postgres Pro Standard release based on a previous major release of PostgreSQL, refer to the instructions in Postgres Pro Standard 10.1.1 Release Notes. If you select the upload/restore option, data you must use the --add-collprovider option so that database the correct sort rule provider appears in the restored option.

Postgres Pro Standard 9.6.10.1

This release is based on PostgreSQL 9.6.10 and Postgres Pro Standard 9.6.9.1. Improvements over Postgres Pro Standard 9.6.9.1:

  • The pg_variables module now supports transactional variables.
  • The auto_explain module can now output scheduling time.
  • Auto-Clean now immediately removes unnecessary temporary tables to avoid freezing the pg_class.
  • Fixed an error that made it impossible to use some Hunspell dictionaries with FLAG num affixes, for example, ru_aot.
  • The pg_probackup module has been upgraded to version 2.0.19, which has the following features:
    • If one of the parent copies is corrupted, this incremental copy gets ORPHAN (Lost).
    • The show-config command now shows both the changed pg_probackup parameters and the values that remain unchanged. Its conclusion can now be obtained in JSON format to simplify perception.
    • The restore command may skip copy validation to speed up cluster recovery.
    • Enhanced parallel incremental copy execution.
    • You can now combine incremental copies with the parent full copy to save disk space. This is an experimental possibility - be careful, interrupting the consolidation process can lead to damage to backups.

  • Updated Postgres Pro Standard for Windows:

    • The implicit limit on the number of concurrent files opened in each server subprocess has been eliminated.
    • Added the ability to disable checksums in the cluster. By default, checksums are enabled when you install Postgres Pro.

The installation procedure depends on the version of your current installation.

You can use the pg_upgrade utility to upgrade the DBMS from Postgres Pro Standard, based on the previous major release of PostgreSQL. The first option is safer and the second is faster and can speed up the upgrade process for large databases.

When upgrading from 9.6.8.2 and later, you must run the REINDEX command on indexes that use mchar or mvarchar types.

To upgrade from a Postgres Pro Standard version based on the same major PostgreSQL release, you do not need to upload/restore data. If you are upgrading from Postgres Pro Standard 9.6.7.1 or later, you will also need to use the pgpro_upgrade script. This script updates the metadata to change the format of the catalog number that changed after Postgres Pro Standard 9.6.4.1, and also renames the pgpro_build function to pgpro_source_id. When you upgrade a Postgres Pro installation using a binary package, the pgpro_upgrade script starts automatically or you are prompted to start it manually.

When you start pgpro_upgrade manually, you must stop the postgres service. This script must be run by the database owner (usually postgres). An error will occur when trying to run pgpro_upgrade as root. See pgpro_upgrade for details.

If Postgres Pro is compiled from source code or the database is created in a non-standard location, you must run the pgpro_upgrade script manually.

In Linux distributions with RPM packages, if you upgrade from 9.6.2.1 or earlier, you must rename the pgsql data directory to pgpro before running the pgpro_upgrade script.

To upgrade from vanilla version PostgreSQL 9.6.x, you will need to upload/restore the data using pg_dumpall.

Postgres Pro 10.4.1

On May 29, 2018, it became known that Postgres Professional released the next Postgres Pro 10.4.1 release, based on PostgreSQL 10.4 and Postgres Pro Standard 10.3.2. It included all improvements of the version of PostgreSQL 10.4 and also a number of important completions:

  • the jsquery module responsible for queries to the jsonb data type has been updated;

  • The pg_probackup utility for managing backup and recovery of database clusters has been upgraded to version 2.0.17 and is enhanced with new features; for example, DELTA mode was added, in which all data files in the directory are read and an incremental copy is created for pages that have changed since the previous copy;

  • the pg_pathman module, which is responsible for partitioning large and distributed databases, has been updated to version 1.4.11, in which a number of errors have been fixed;

  • sorting of letters "Yo" and "Y" in the mchar module providing additional types of data for compatibility with Ms SQL Server is corrected;

  • The version of Postgres Pro Standard for Windows has been refined.

It is interesting to note the addition of full-text search support for Nepali.

Compatibility of Postgres Pro DBMS with operating systems RED OS and GosLinux

RED SOFT, the developer of RED OS, and Postgres Professional, the developer of the Postgres Pro DBMS, entered into a scientific and technical partnership agreement in May 2018 aimed at cooperation in the field of product compatibility.

As a result of the tests, the compatibility of the Russian Postgres Pro DBMS with the operating systems RED OS and GosLinux confirmed. Performance and fault tolerance were evaluated using load testing methods for Postgres Pro Standard 9.5, 9.6, 10.0, Postgres Pro Enterprise and Enterprise Certified DBMS. The tests were carried out in cooperation with experts of the Office of Information Technology of the FSSP of Russia. Based on the results, certificates were signed confirming the interoperability and correctness of software products.

2017

Postgres Pro Standard 10.1

On December 15, 2017, Postgres Professional announced the release of the 10th version of the Postgres Pro Standard DBMS. It is based on the release of the open DBMS PostgreSQL 10.1 and has a number of differences.

In this version of DBMS Postgres Pro Standard 10.1.1 there is functionality of the current version of DBMS PostgreSQL, some errors have been fixed. All modifications and added features of the Postgres Pro Standard 9.6 DBMS have been transferred to version 10.1.1.

List of differences between Postgres Pro Standard 10.1.1 and vanilla version PostgreSQL:

  • added including indexes and waitlsn in the kernel;
  • all patches and extensions required for operation 1C are included;
  • ICUs collations are used by default, not only when explicitly specified for a table/column;
  • dictionaries for full-text search are present in the installation kit and are put with the command create extension hunspell_ru_ru;
  • dump_stat, jsquery, pg_query_state, pg_pathman, pg_tsparser, pg_variables, sr_plan, shared_ispell are also present in the distribution;
  • The kit includes utilite incremental backup pg_probackup;
  • fully translated into Russian documentation, including man-pages on Linux.

Under the Windows operating system, psql works in unicode and displays any characters on the console. Less is supplied as a pager. In psql, history works under Windows, the addition of keywords is performed by the tab key. The structure of binary installation packages for different Linux distributions is unified, and although it differs from the structure of vanilla PostgreSQL, it gives a number of advantages.

The Postgres Pro Standard 10.1.1 DBMS is available for download free and is licensed PostgreSQL with Postgres Professional add-ons.

Integration with Solar Dozor

On September 19, 2017, the company, Solar Security a developer of products and services for targeted monitoring and operational management of information security, announced the implementation of support in the Solar Dozor system, a Postgres Pro domestic branch. DBMS PostgreSQL More. here

Integration with R-Vision software products

The company, R-Vision a resident Skolkovo and developer of software solutions in the field, and information security the company, a Postgres Professional Russian vendor, signed DBMS PostgreSQL an agreement on technological cooperation on August 18. Both companies are members. ARPP "Domestic software"

Partnership means the possibility of using the functionality of the Russian Postgres Pro DBMS in R-Vision software complexes, including platforms for monitoring, registering and responding to information security incidents. Postgres Pro DBMS is based on open source system PostgreSQL and adapted to the requirements of Russian users. A special emphasis in development is placed on cluster technologies, working with poorly structured data and improving performance, said Postgres Professional.

As part of the collaboration, Postgres Professional and R-Vision will ensure software compatibility, as well as develop projects based on close integration of technologies. It is planned that the partnership will expand the client network by more accurately solving problems. Of particular interest to partners are the banking sector and the public sector, in which companies have enough intersections.

File:Aquote1.png
Cooperation with Postgres Professional opens up new opportunities for us to use advanced domestic developments in the field of data management, and the use of Postgres Pro DBMS certified by FSTEC allows us to ensure compliance with safety requirements put forward by domestic regulators, "commented R-Vision CEO Alexander Bondarenko.
File:Aquote2.png

File:Aquote1.png
We consider the compatibility of the Postgres Pro DBMS with the application solutions of Russian developers one of the most important tasks and the criterion of efficiency. Cooperation with R-Vision, whose products are in demand by many Russian customers, will cover a wide segment of the information security software market, "said Oleg Bartunov, CEO of Postgres Professional.
File:Aquote2.png

"1C:Enterprise 8" is Postgres Pro compatible

On July 24, 2017, 1C, based on the results of technical testing, confirmed the compatibility of 1C:Enterprise 8 platform with the Postgres Pro DBMS.

In accordance with the cooperation agreement, Postgres Pro DBMS will be delivered to customers throughout Russia through the 1C partner network.

File:Aquote1.png
The integration of the Postgres Pro DBMS with the 1C platform is a strategically important step for us. Thanks to the extensive partner network, well-deserved recognition of 1C products and special licensing conditions for users, we are confident that cooperation with 1C will lead to serious advances in solving automation problems based on domestic solutions.

Oleg Bartunov, CEO of Postgres Professional
File:Aquote2.png

Tested for x86-64 architecture, confirmed platform compatibility 1C: Enterprises from version 8.3.10.2375 and Postgres Pro Enterprise from version 9.6.3.1

Postgres Pro DBMS is located in the Microsoft Azure cloud

The company Postgres Professional in July announced the placement DBMS of Postgres Pro in. cloud Microsoft Azure Now users of the cloud service are available DBMS Postgres Pro Standard and the most advanced version Postgres Pro Enterprise developed by Postgres Professional based on the project with. open source PostgreSQL

The Postgres Pro Enterprise database management system was developed by Postgres Professional specifically for high-load systems of large enterprises. Postgres Pro Enterprise features are indispensable for information systems running hundreds of millions of transactions per day. It adds dozens of important functions: block-level data compression allows you to reduce the physical amount of data storage from 2 to 10 times, the cluster multimaster provides transaction processing on several servers as a single complex, optimized partitioning allows you to work with thousands of partitions.

According to Postgres Professional, the Postgres Pro DBMS versions prepared for use in the Azure cloud automatically adapt to the selected version of the virtual server, contain built-in monitoring tools and require minimal effort to start and administer. The company plans to release cloud versions of its products and for other platforms.

Postgres Pro Standard 9.6.3.1 release

On May 16, 2017, Postgres Professional announced the release of Postgres Pro Standard 9.6.3.1.

This version was created on the PostgreSQL 9.6.3 platform and contains updates to previously added patches and extensions.

Postgres Pro Standard 9.6.3.1, (2017)


Implemented changes:

The base version contains many patches. Developers recommend an upgrade. Correction version 9.5.7.1 has been released.

Among the main improvements:

  • Added pg_tsparser extension for text search.
    • in addition to the individual parts of the word returned by default, pg_tsparser also returns the entire word if it contains:
    • * underline
    • * numbers and letters separated by a minus sign

  • The pg_pathman module has been upgraded to version 1.3.2. This version is compatible with the current release.
  • The sr_plan module now operates with a non-standard search_path value.
  • A spanning index corruption error in the WAL has been resolved.
  • Added distribution packages for SUSE Linux Enterprise Server 12 SP1 and Ubuntu 17.04.
  • Added refinements to optimize inheritance.
  • Revision of PTRACK has been updated to version 1.2.
  • Provides performance improvements for queries typical of 1C solutions.

Why the largest companies in Russia and the world choose Postgres. Results of PgConf.Russia 2017

On March 15-17, 2017, the III International Technical Conference of Developers and Users PostgreSQL - PgConf.Russia 2017 was held in the Digital October conference hall. This event is one of the largest events in the world community of post-Grexists, it brought together more than 500 people from Russia, countries near and far abroad. The conference was organized by Postgres Professional, a Russian vendor of this DBMS (more...)

Postgres Pro Standard 9.6.2.1

On March 3, 2017, Postgres Professional announced the release of Postgres Pro Standard 9.6.2.1.

As part of the release:

  • updates from PostgreSQL 9.6.2 - about 80 patches.
  • pg_pathman module upgraded to version 1.3
  • the sr_plan module is now initialized independently for each database instance.
  • patches for spanning indexes have been applied.
  • in systems on the RHEL Postgres Pro platform, it is now installed in a separate location - it can be installed simultaneously with the current installation of PostgreSQL.
  • improved algorithm for automatic TCP port selection in case of parallel installation of different versions of Postgres Pro on Windows systems.
  • updated backup manager pg_probackup.

2016

Postgres Pro became the main DBMS for SED Delo

On November 29, 2016, the company's press service announced the conclusion of a joint development agreement between Postgres Professional and Electronic Office Systems (EOS). The first joint project is the release of SED Delo on the Postgres Pro DBMS platform.

Read more on page 2A_.D0.9F.D0.B5.D1.80.D0.B5.D0.B2.D0.BE.D0.B4_.D0.A1.D0.AD.D0.94_D0.B0_.D0.D.D.AOST3.DGR0.A0.94_translation

DBMS Postgres Pro received a certificate of compliance with the FSTEC of Russia

The certificate certifies that the Postgres Pro DBMS can be used to protect information in state information systems and automated control systems up to 1 class of security, as well as provide up to 1 level of personal data protection in information systems.

Postgres Pro DBMS meets the requirements of the "Computer Tools. Protection against unauthorized access to information. Indicators of security against unauthorized access to information "(State Technical Commission of Russia, 1992) - in the 5th class of security," Protection against unauthorized access to information. Part 1. Information security software. Classification according to the level of control of the absence of undeclared capabilities "(State Technical Commission of Russia, 1999) - according to the 4th level of control and technical conditions when fulfilling the operating instructions given in the logbook.

Certification tests were carried out by the testing laboratory of CJSC NPO Echelon. Alexander Barabanov, Director of the Certification and Testing Department of Echelon NGO, noted: "We are pleased that one of the advanced database management systems, finalized taking into account the requirements of Russian legislation, has successfully passed tests on fairly serious requirements of the regulator. It is worth noting that the FSTEC certificate of Russia confirms the correct functioning of the Postgres Pro DBMS for almost all operating systems from the Unified Register of Russian Programs. "

Key Features of Postgres Pro Certified DBMS

  • Functionally fully complies with the standard version of Postgres Pro 9.5.2.1 with support for row level security (RLS).
  • Has built-in protection against unauthorized access to information, including cleaning of RAM and disk memory (file cleaning
  • In external memory before deletion, purge row versions (purge pages) before deletion, purge RAM before release, purge preemptive log before deletion or overwrite).
  • It has built-in integrity control of executable files, configuration files and system directory tables.
  • It operates under the following operating systems:
    • special-purpose OS "Astra Linux Special Edition" RUSB.10015-01
    • OS ROSA SX Cobalt - 64-bit
    • ROSA OS DX64 Cobalt - 64-bit
    • ALT Linux SPT 6.0 - 64-bit
    • ALT Linux SPT 7.0 - 64-bit
    • OS GosLinux 6

The Postgres Pro 9.5.2.1 certified DBMS can be purchased on disk. Attached to the disk is a form, a copy of the certificate of conformity and documentation for the Postgres Pro 9.5.2.1 DBMS security kit.

Testing on Hitachi Servers

On April 14, 2016, Postgres Professional reported testing the DBMS on the Hitachi Data Systems hardware platform, based on the Compute Blade 2500 solution.

The test task was the need for Postgres Professional developers to test performance and adapt the DBMS to the capabilities of Hitachi servers.

Testing was carried out on a multi-core system based on Intel processors provided by Hitachi: the inclusion of four HDS CB520X servers on the Intel processor platform in the Compute Blade 2500 blade chassis helped create an eight-processor server with 144 compute cores and 2 TB of RAM.

Test results: The PostgreSQL DBMS on Hitachi hardware works efficiently at high loads without losing performance.

File:Aquote1.png
author = Irina Yakhina, Head of HDS Technology Solutions
Database Management System PostgreSQL itself deserves the close attention of customers - the course towards import substitution only pushes it to development. Today, for such young and fast-growing services, it is necessary to think well about the promotion strategy in the Russian market: all processes, from the production and testing of the solution to integration and service support, must be established at the highest level. The company Hitachi Data Systems is pleased to provide Postgres Professional its equipment for the implementation of any joint projects. The growth rate of popularity PostgreSQL suggests that very soon this DBMS will be used in many enterprises that are important for the reliability and flexibility of solutions. A significant advantage for Russian customers will be the attractive cost of solutions based on. PostgreSQL
File:Aquote2.png

File:Aquote1.png
author = Ivan Panchenko, Deputy CEO of Postgres Professional
The partnership of Postgres Professional and Hitachi Data Systems will certainly bring great benefits to both companies. Testing PostgreSQL on the HDS hardware platform and adapting the DBMS to the features of Hitachi servers allows you to plan the development of new business solutions, focusing on HDS, as a global technology developer.
File:Aquote2.png

Postgres Pro tested on Inspur hardware platform

Postgres Professional and the Inspur company, the supplier of complete solutions and services for cloud computing, completed functional and stress testing of Postgres Pro on rack-mount serverakhinspur the NF series.

Postgres Pro has additional functionality compared to PostgreSQL, and is fully supported by Russian developers. The system has a number of advantages, including reliability and sustainability, heavy load competition, scalability, cross-platform, extensibility, and high compliance with key industry standards, including ANSI SQL 92, ANSI SQL 99, and ANSI SQL 2003, 2011.

During the testing, Postgres Pro DBMS was adapted to the capabilities of Inspur NF series servers, as a result of which optimal performance and reliability indicators were achieved. Testing opens up new opportunities for customers in choosing an innovative Postgres Pro solution on the high-performance Inspur hardware platform.

Postgres Pro

As of June 2016, Postgres Pro is a Russian fork of DBMS PostgreSQL, developed by Postgres Professional.

Notes