Postgres Pro DBMS

The main articles are:

• Database Management System (DMS)
• SaaS - History. Philosophy. Development drivers

2024

Free licenses for educational institutions

The company Postgres Professional transferred licenses DBMS Postgres Pro Standard to educational institutions for free. The company announced this on November 14, 2024.

Postgres Pro Standard's academic license includes unlimited use of the system for educational purposes - teaching students, conducting research, student competitions and more.

Russian DBMS students from ten universities and colleges:

• Novosibirsk National Research State University;
• National Research Tomsk Polytechnic University;
• St. Petersburg State Maritime Technical University;
• Khakass State University named after N.F. Katanova;
• International Academy of Information Technology "IT HUB";
• St. Petersburg State University of Aerospace Instrumentation;
• MIREA - Russian University of Technology;
• Moscow Financial and Industrial University "Synergy."

Earlier, participants in the program were the Orsky Humanitarian and Technological Institute (branch) Orenburg State University and the Novokuznetsk Mining and Transport College named after V.F. Kuznetsova.

According to ours, since the beginning of to data 2022, popularity DBMS open source PostgreSQL has almost tripled, and the demand for post-Gresits is growing. Obviously, studying Postgres and Russian products based on it is a reality that educational programs at all levels must meet. Being in a vacuum of foreign solutions, future IT specialists do not receive the knowledge and skills necessary for real tasks, which means they are deliberately limited in their capabilities. For its part, Postgres Professional is ready for an open dialogue with educational institutions to share the accumulated experience, developments and does everything possible to involve the entire industry in it. noted Ivan Panchenko, co-founder and deputy general director of Postgres Professional.

In addition to the commercial product, Postgres Professional is actively developing the freely distributed PostgreSQL DBMS. Postgres Professional has created an internship program for students, collaborates with Moscow State University, HSE, ITMO, SPBPU, NSU, SibSU named after M.F. Reshetneva, Russian State University of Oil and Gas named after I.M. Gubkin, KalmSU named after B.B. Gorodovikova and other universities. In addition, Postgres Pro specialists have developed 15 educational courses and books freely available on the company's website.

Postgres Pro Standard 17.0.1 based on PostgreSQL 17

Postgres Professional has presented an updated version of the DBMS based on PostgreSQL 17 released in September 2024. The company announced this on November 12, 2024.

With the major update of Postgres Pro Standard, customers got access to all the features of the open Postgre SQL 17 in the proven the Russian DBMS Postgres Pro. The system includes more than 40 enhancements and features, as well as optimizations for working with "" and 1C: Enterprise round-the-clock user support.

The release includes a memory management system for VACUUM; Standard/JSON support SQL; Improve query performance support for incremental backup of pg_basebackup; improvements in logical replication.

This version also contains a number of changes and improvements available only in Postgres Pro Standard:

• Add SPLIT PARTITION and MERGE PARTITIONS to ALTER TABLE. The sub-teams improve the management of partitioned tables: the first divides one section into several, the second combines several sections into one.
• Added a pgpro_autopart extension to dynamically create partitions using triggers for partitioned table views.
• Removed deprecated pg_pathman extension.

The release updated most of the solutions that complement the basic functionality of PostgreSQL:

• The module for adaptive optimization of aqo requests has been updated to version 3.0. The module implements the sandbox mode, which allows you to work in an isolated environment without affecting the main knowledge base aqo, and also adds a learning mechanism in which aqo adjusts the estimate of the number of scheduler lines using its own predictions.
• The pgpro_pwr module, designed to identify the most resource-intensive operations in the database, has been updated to version 4.7 and received additional features - a mechanism of intermediate samples for collecting relatively rapidly changing data, new report tables, in particular related to session states and more.
• The pgpro_stats extension to collect scheduling and execution statistics for all SQL statements processed by the server has been updated to version 1.8. In addition to supporting the new fields of the module pg_stat_statements the extension has improved user access to views and functions.

In addition, updates were received: ODBC driver, oracle_fdw extensions, PLV8 and tds_fdw, orafce modules, pg_repack, pgpro_controldata and pg_filedump utilities, pg_probackup application.

Version 12, 13, 14, 15, 16 compatibility with Bitrix24 and 1C-Bitrix: Site Management

Postgres Professional and 1C-Bitrix announced compatibility of their products on November 7, 2024. The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Standard (versions 12, 13, 14, 15, 16) with Bitrix24 and 1C-Bitrix: Site Management.

Шаблон:Quote 'author=said Roman Strelnikov, Head of Information Security at 1C-Bitrix.

{{quote 'author=noted Ivan Panchenko, co-founder and deputy general director of Postgres Professional. | Compatibility of domestic solutions is one of the most important components on the way to independent Russian ITindustries-. Postgres Professional already has several hundred successful tests with partner developments. Its expansion with 1C-Bitrix opens up even more opportunities for our customers and system users,}}

Postgres Pro Certified Compatibility (Version 14,15,16 with RedCheck EPS

Postgres Professional and AltexSoft announced compatibility of their products on November 2, 2024.

The certificate issued by Postgres Professional confirms the correct operation of certified FSTEC editions - Postgres Pro Certified (version 14,15,16), Postgres Pro Enterprise Certified (version 13,14,15,16) - and SAZ. RedCheck More. here

Version 16 compatibility with BI.Qube 2.0

Postgres Professional and iT Pro (IT Pro) on October 31, 2024 announced the compatibility of their products. The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Standard 16 and BI.Qube 2.0. More here.

PerfExpert Compatibility

Postgres Professional and SoftPoint announced compatibility of their products on October 28, 2024.

The certificate issued by Postgres Professional confirms the correct operation of DBMS Postgres Pro Standard, their Postgres Pro Enterprise certified editions (versions 13, 14, 15, 16) and the performance monitoring platform and. servers databases PerfExpert More. here

Compatibility with EDMS "Delo" version 24.3

Postgres Professional and EOS Group of Companies on October 10, 2024 announced the compatibility of their products. The certificate issued by Postgres Professional confirms the correct operation of EDMS "Delo" version 24.3 with Postgres Pro Standard, Postgres Pro Enterprise and their certified editions (versions 13, 14, 15, 16). Read more here.

Compatible with SkyV IT Asset Management and SkyFLabs SkyV Monitoring

Postgres Professional and Skyfall Labs announced compatibility of their products on September 30, 2024.

The certificate issued by Postgres Professional confirms the correct operation of SkyV IT Asset Management and SkyV Monitoring solutions with Postgres Pro Standard, Postgres Pro Enterprise DBMS and their certified editions (version 16).

Шаблон:Quote 'author=Barteneva CEO Maria told Skyfall Labs.

Compatibility with ANT-CS solutions

ANT-CS confirmed the compatibility of the company's products with the Postgres Pro DBMS from the developer Postgres Professional, which announced this on September 26, 2024.

Certificates issued by Postgres Professional confirm the technological compatibility of ANT-CS software products with Postgres Pro Standard and Postgres Pro Enterprise (versions 15, 16).

ANT-CS has integrated with the Postgres Pro DBMS an automated production and dispatch management system for regional gas distribution systems, an integrated SHIVA data bus, information and monitoring control systems IMUS and OptIMUS, as well as other products.

We are aimed at full import substitution. The Russian software market is ready for the development and further implementation of domestic solutions not only in critical infrastructure facilities, but also in all areas of industry, - said Alexander Mamaev, General Director of ANT-CS.

Compatibility of versions 14, 15 with Basis Workplace

Postgres Professional and Basis announced the compatibility of their products on September 25, 2024. The certificate issued by Postgres Professional confirms the correct operation of the Basis Workplace VDI solution with Postgres Pro Standard (versions 14, 15) and Postgres Pro Enterprise (version 15). Read more here.

Postgres Pro Certified 14 compatibility with Cascade Zyfra platform

Postgres Professional, the developer of the Russian DBMS Postgres Pro, and SibCom Digital on September 16, 2024 announced the compatibility of their products.

The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Certified 14 and the Cascade Zyfra platform. Read more here.

BPMSoft Compatibility

Postgres Professional, the developer of the Russian DBMS Postgres Pro, and BPMSoft, the developer of the low-code platform BPMSoft, announced the compatibility of their products on September 10, 2024. Read more here.

Compatibility with sPACE PAM

Postgres Professional and Web Control on September 9, 2024 announced the compatibility of their products.

The certificate issued by Postgres Professional confirms the correct operation of sPACE PAM and certified editions of Postgres Pro Standard, Postgres Pro Enterprise (version 16). Read more here.

Russian DBMS for complex tasks: Postgres Pro Enterprise 16 review

Postgres Pro is the most popular Russian DBMS for enterprise tasks. Among the customers of the system are Russian Railways, Rosatom, Gazpromneft, the Federal Tax Service, the Federal Treasury, the Ministry of Foreign Affairs, Goznak, Rosfinmonitoring, the largest private companies in Russia from the RBC 500 list.

The company Postgres Professional ranks second in the world in terms of contribution to the development of the PostgreSQL open source system, on which the Postgres Pro commercial DBMS is based. This contribution is greater than that of,, Microsoft,, and Amazon. Fujitsu Google Apple Postgres Professional employs 70% of all Russian postgresists - contributors to PostgreSQL 15. Read more here. [1]

Postgres Pro Standard 16.4.1 with Alt 11 support

The company Postgres Professional announced a minor update DBMS to the Postgres Pro Standard on August 29, 2024. Release 16.4.1 includes the capabilities of Postgres Pro Standard 16.3.2 and free DBMS PostgreSQL 16.4, as well as a number of improvements.

Among the key changes are:

• The PASSWORD_GRACE_TIME profile parameter interacts with the VALID UNTIL attribute of the role. Now, if both are specified, an expiration warning will be displayed. password
• Prevented potential authentication delays due to locks caused by the role's last logon time being not updated when the role's USER_INACTIVE_TIME profile setting was set to UNLIMITED.

Eliminated:

• There is a problem with the nested loop parameters that causes the Memoize statement to permanently clear the cache. This fix speeds up query execution.
• Error causing optimizer to ignore columns from query conditions. Previously, with partial use of a composite index, the number of rows could be overstated, which led to the creation of an incorrect plan. The error occurred due to incorrect behavior of elements of multi-column statistics.
• An error in ANALYZE that may have occurred because the pg_statistic system directory could not be displayed. If the database has indexes with INCLUDE columns, after updating Postgres Pro, it is recommended that you run ANALYZE again for these columns so that this fix applies.

Compatibility with operating systems:

• Added support for Alt 11 OS.
• Support for Ubuntu 23.04 OS has been discontinued.
• Updated: ODBC driver to version 16.00.0005; Appendix pg_probackup up to version 2.8.3; pg_proaudit and mchar extensions; pg_filedump to version 17.0 and pgvector to version 0.7.4.

Also added is the hypopg extension, which provides support for hypothetical indexes in Postgres Pro, and fixed incorrect pg_wait_sampling behavior when used with an advanced query protocol.

Compatible with Secret Cloud Enterprise

Postgres Professional, the developer of the Russian DBMS Postgres Pro, and Secret Technologies, specializing in secure information exchange and storage systems, announced the compatibility of their products on August 27, 2024.

The certificate issued by Postgres Professional confirms the correct operation of Secret Cloud Enterprise with the Postgres Pro Certified DBMS and Postgres Pro Enterprise version 15. Read more here.

Terus Compatibility

Postgres Professional, the developer DBMS of the Russian Postgres Pro, and LLC "" TEKNO on August 21, 2024 announced the compatibility of their products.

The certificate issued by Postgres Professional confirms the correct operation of the Postgres Pro Enterprise, Postgres Pro Standard DBMS (versions 13, 14, 15, 16) and the Terus solution. Read more here.

Compatibility with CityVisor IC

Postgres Professional, developer the Russian DBMS Postgres Pro, and "" announced compatibility of Nakhodka AIS their products on August 12, 2024. The certificate issued by Postgres Professional confirms the correct operation of its DBMS and information system. CityVisor More. here

Postgres Pro Standard 16 compatibility with Zakroma Storage 2.0.1

Postgres Professional and the development company PODigital Spirit announced the compatibility of their products on July 11, 2024.

The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Standard 16 with version ZAKROMA. Wound 2.0.1. Read more here.

Compatibility with the Planet platform.

Postgres Professional and the IBS Group announced compatibility of their products on July 4, 2024.

The certificate issued by Postgres Professional confirms the correct operation of the Planet platform. And products based on it developed by IBS, and Postgres Pro Enterprise, Postgres Pro Enterprise Certified and Postgres Pro Certified (versions 14, 15). Read more here.

Compatibility with Catharsis version 8

Postgres Professional and KATARSIS LLC announced the compatibility of their products on July 2, 2024.

The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Enterprise, Postgres Pro Standard, as well as its certified edition (versions 14 and 16) with the Software Complex "[[Catharsis: Employment Software package 'Catharsis]] "version 8 (since version 8.54).

Compatibility with Platex ACP

Postgres Professional and Биллинг.РФ LLC, the developer of the Platex billing system, on June 27, 2024 announced the compatibility of their products.

The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Enterprise and Standard, as well as their certified editions (versions 13, 14, 15, 16) and ACP "Platex" (versions 7.2 and higher). Read more here.

Postgres Pro Standard 16 Terraflow Compatibility

Postgres Professional and Altek LLC on June 24, 2024 announced the compatibility of their products.

The certificate issued by Postgres Professional confirms the correct operation of Terraflow and the Postgres Pro Standard 16 DBMS, as well as its certified version. Read more here.

Compatibility with Galaxy products

Postgres Professional, developer the Russian DBMS Postgres Pro, Galaxy Corporation and on June 7, 2024 announced compatibility of their products.

The certificate issued by Postgres Professional confirms the correct operation of 16 versions of the Postgres Pro Enterprise, Postgres Pro Standard DBMS, as well as their certified editions and systems: Galaktika ERP, AMM Galaxy, MES Galaxy, Galaxy EAM and ESB Galaxy.

As of June 2024, the Galaxy product line is able to close the entire range of tasks of a modern enterprise with technological production of any complexity. The central product in the galactic ecosystem is ERP, which provides end-to-end management of the processes of all areas of financial, economic and production activities of holdings and corporations, as well as large enterprises of various industries of the Russian Federation. Solutions Galaxy AMM, Galaxy MES allow the company to plan and manage production processes at all levels, from the digital cooperation network to the digital workplace. Galaxy EAM provides management of maintenance and reliability of production assets. ESB Galaxy is an integration bus that allows you to consolidate heterogeneous solutions with minimal costs. All solutions are included in the register of domestic software. The Galaxy technology stack is compatible with Postgres Pro Standard 13, 14, 15 versions from March 2023.

Renewal of FSTEC certificate

Postgres Professional once again evaluated the certified editions of the Postgres Pro DBMS in accordance with the requirements of FSTEC. The compliance certificates of the FSTEC of Russia No. 4063 and No. 3647 have been extended until January 16 and October 5, 2029. The company announced this on June 5, 2024.

In addition, certified editions received updates. Postgres Pro Certified supports three versions of the database engine (14.11.2, 15.6.2, 16.2.2); Postgres Pro Enterprise Certified - four versions (13.14.3, 14.11.3, 15.6.3, 16.2.2).

Support has been discontinued and updates are not available for the 11th version of the Postgres Pro kernel. Users are encouraged to upgrade to newer major versions of the DBMS.

Certified editions allow you to use Postgres Pro:

• in significant objects of critical information infrastructure of the 1st category, in state information systems of the 1st security class;
• in automated control systems of production and technological processes of the 1st class of protection;
• in personal data information systems, if it is necessary to ensure 1 level of personal data security;
• In Class II public information systems.

Compatibility with Transflow service

Postgres Professional and Altek LLC on June 3, 2024 announced the compatibility of their products. The Transflow service is compatible with the Russian DBMS Postgres Pro. Read more here.

Astra Linux Special Edition Compatibility

Postgres Professional and Astra Group announced compatibility of their flagship solutions on May 31, 2024.

In the course of the work, experts conducted a comprehensive study, the results of which confirmed the correct operation of the secure special-purpose operating system Astra Linux and the Postgres Pro Enterprise 16 DBMS. Read more here.

Compatibility with Rosa Chrome 12 Server

Postgres Professional and STC IT ROSA on May 28, 2024 announced the compatibility of their products.

The certificate issued by Postgres Professional confirms the correct operation of the operating system ROSA Chrome 12 Server and DBMSostgres Pro Enterprise, Postgres Pro Standard, as well as their certified editions (versions 14, 15, 16). Read more here.

Compatibility with T2Plus

T2 SOFT, a Russian company developing its own software for automation of business processes and enterprise management, and Postgres Professional on May 15, 2024 announced the passage of compatibility certification and the conclusion of a technological partnership.

The correct operation of T2Plus solutions with DBMSostgres Pro Enterprise, Postgres Pro Standard and its certified edition has been confirmed. Read more here.

Compatibility with "Safe City of OS5000" and SP5000 MKA Housing and Utilities "Service for Monitoring and Control of Elimination of Accidents and Incidents in the Housing and Utilities Sector"

Postgres Professional, the developer of the Russian DBMS Postgres Pro, and Iskra Technologiya JSC on May 17, 2024 announced the compatibility of their products.

The certificate issued by Postgres Professional confirms the correct work of Postgres Pro Enterprise (versions 13, 14, 15), Postgres Pro Standard (versions 13, 14, 15), Postgres Pro Certified (versions 14, 15) and the Software Complex "Safe City OS5000," Software Complex "Safe City OS5000" version 2.0 and SP5000 MKA Housing and Communal Services "Service Monitoring and control of the elimination of accidents and incidents in the housing and utilities sector." Read more here.

Postgres Pro Standard 15, 16 compatibility with Waliot 1.0 platform

The First Monitoring Company has confirmed the compatibility of its fleet management platform Waliot version 1.0 and higher, with the Russian DBMS Postgres Pro Standard 15, 16 of Postgres Professional, which announced this on May 6, 2024. Read more here.

Compatibility of Postgres Pro Standard 15 with ECP.MIS and ECP.MIS

Postgres Professional and RT MIS on May 6, 2024 announced the compatibility of their products.

The correctness of the joint operation of the Postgres Pro Standard 15 DBMS and its certified version with the products "ECP.MIS" and "ECP.LIS" are confirmed by the relevant certificates. Solutions are included in the Register of Domestic Software, which also allows businesses to deploy a completely import-independent IT infrastructure. Read more here.

Compatibility with Postgres Pro Standard (versions 15, 16) with the Axiom platform

Postgres Professional confirms the correct operation of DBMSostgres Pro Enterprise (versions 14, 15, 16), Postgres Pro Standard (versions 15, 16) and the AXIOMA platform, the copyright holder of which is Interprocom LLC. Postgres Professional announced this on May 2, 2024. Read more here.

Compatibility with VeGA-Plus platform

Postgres Professionals Management and Finance announced the compatibility of their products on April 24, 2024. The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Standard (14, 15, 16 versions) and the software platform for the development of information systems "VeGA-Plus." Read more here.

Compatibility with "Comita Report Online"

Postgres Professional, the developer of the Russian DBMS Postgres Pro, and Comita JSC on April 22, 2024 announced the compatibility of their products. Certificate No. S378-24 of 27.03.2024 issued by Postgres Professional confirms the correct operation of the Postgres Pro Standard DBMS (versions 12, 13, 14, 15, 16) and COMITA REPORT Online. Read more here.

Comita AML Compatibility

Postgres Professional and JSC "Comita" on April 12, 2024 announced the compatibility of their products. Certificate No. S377-24 of 22.03.2024 issued by Postgres Professional confirms the correct operation of Postgres Pro Standard versions 12, 13, 14, 15, 16 and Comita AML. Read more here.

Compatible with InterIn Promis Alpha PG, InterIn Alpha, and InterIn SQL Studio

Postgres Professional and Interin Technology on April 8, 2024 announced the compatibility of their products. The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Standard DBMS (versions 13, 14, 15, 16) and Interin PROMIS Alpha PG, Interin Alpha and Interin SQL Studio products. Read more here.

XSQUARE-LCDP compatibility

Postgres Professional and LLC "CHI-Square" on April 4, 2024 announced the compatibility of their products. The certificate issued by Postgres Professional confirms the correct operation of the entire line of XSQUARE-LCDP and DBMSostgres Pro Enterprise, Postgres Pro Standard products, as well as their certified editions (13, 14, 15, 16 versions). Read more here.

Amber Platform Compatibility

AMBER, a developer of systems and applications based on its own AMBER platform, on March 25, 2024 announced successful compatibility testing of the AMBER platform and the Postgres Pro DBMS developed by the Russian developer Postgres Professional. Read more here.

Directum Product Compatibility

Directum has confirmed product compatibility with the latest version of the Postgres Pro DBMS. The company announced this on March 14, 2024.

Solutions are included in the Register of Domestic Software, which allows businesses to deploy a completely import-independent IT infrastructure.

Postgres Professional certificates issued based on the test results confirm the correct operation of the 16th version Postgres Pro DBMS (Enterprise, Standard and Certified editions) with all Directum systems:

• Directum RX - for digitalization of processes and document management in large companies and government agencies;
• Directum Ario One - for processing content using intelligent services;
• Directum HR Pro - to manage HR processes and documents;
• Directum Projects - for comprehensive project and team management;
• Directum Lite - for the organization of electronic document management in small companies.

The compatibility of Postgres Pro DBMS with Directum products guarantees customers high performance and stable operation of enterprise software, regardless of the company's scale.

Intersoft Contour Compatibility

and Postgres Professional Intersoft Lab"," a Russian developer data stores bank of business performance and risk management systems, announce compatibility of their products. The certificate issued by Postgres Professional confirms the correct operation of the platform "" with and Kontur DBMS Postgres Pro Enterprise Standard (versions 15, 16). More. here

Compatibility with "Forsyth. Analytical Platform, "" Forsyth. Investment Management "and" Forsyth. Budgeting "

Postgres Professional and Forsyth announced compatibility of their products on February 12, 2024.

The certificate issued by Postgres Professional confirmed the correct operation of the software products "Forsyth. Analytical Platform, "" Forsyth. Investment Management "and" Forsyth. Budgeting "with Postgres Pro Enterprise and Standard DBMS (version 13,14,15, as well as the latest 16 - Standard edition). Read more here.

Compatibility with EME.WMS

Postgres Professional, the developer of the Russian, and DBMS Postgres Pro the company, the EME developer of automation systems, logistics announced the compatibility of their products. The certificate issued by Postgres Professional confirms the correct work EME.WMS DBMS and Postgres Pro Standard. Postgres Professional announced this on February 22, 2024. More. here

Avandok Platform Compatibility

GK Corus Consulting"," the developer, and Avandok platforms, Postgres Professional the developer DBMS of Postgres Pro, conducted testing updated versions of their products for compatibility. Postgres Professional announced this on February 13, 2024. More. here

Compatibility with the "SK-11" platform

Postgres Professional and Monitor Electric announced compatibility of their products on February 5, 2024.

The certificate issued by Postgres Professional confirmed the correctness of the collaboration of the current version of the Postgres Pro Standard DBMS and the SK-11 platform. Read more here.

Compatible Postgres Pro Standard version 13, 14, 15, 16 with Pyramid software version 10

Postgres Professional and GC "Systems and Technologies" on February 1, 2024 announced the compatibility of their products.

As a result of joint testing, the correct operation of Pyramid 2.0 software version 10 and Postgres Pro Standard DBMS (versions 13, 14, 15, 16), Enterprise (versions 13, 14, 15), Certified (versions 11, 14, 15) was confirmed. Read more here.

Compatible with SmartVista platforms

Postgres Professional, developer the Russian DBMS Postgres Pro, and, BPS Innovative Software Solutions vendor of the Russian family of software platforms SmartVista, on January 31, 2024 announced the compatibility of their products. Certificates confirm the correct operation of the Postgres Pro Standard DBMS Postgres Pro Enterprise DBMS , with SmartVista platforms. More. here

Compatibility with EvaProject, EvaWiki and EvaServiceDesk

Postgres Professional and EvaTeam announced compatibility of their products on January 17, 2024.

The certificate issued by Postgres Professional confirms the correct operation of Postgres Pro Standard and Postgres Pro Enterprise with EvaProject, EvaWiki and EvaServiceDesk products.

The Russian analogues Jira, Confluence and Jira Service Management from EvaTeam work with the current versions of the DBMS, are included in the register of domestic software. The presence of the built-in functionality of popular plugins, all familiar tools and adaptation for large companies allow you to fully replace foreign products.

Since many Western vendors have left since 2020, companies need not only to replace one specific software, but also to ensure compatibility with all the updated infrastructure. Therefore, good work with other Russian products is a priority for us, - said Denis Kuchaev, Managing Director of EvaTeam.

2023

Postgres Pro Standard 15 DBMS compatibility with Astra Linux Special Edition

On November 27, 2023, Astra Group and Postgres Professional, the developer of the Russian DBMS Postgres Pro, announced the compatibility of their products on November 27, 2023. The certificate issued as part of the Ready for Astra IT manufacturers' technological cooperation program confirms the correct operation of the Postgres Pro Standard - 15 DBMS and the Astra Linux Special Edition special-purpose operating system.

Postgres Pro Standard is a significantly improved version of the PostgreSQL open database for high-load systems. Among its features are support for partitioning tables covering indexes, the pg_probackup utility, pgpro_pwr extension, incremental backup, and others.

The Astra Linux operating system and the Postgres Pro Standard version 15 DBMS form a system platform that serves as the basis for building an enterprise IT infrastructure of any scale and complexity. It is capable of working on domestic computing equipment of different architectures, compatible with a large range of Russian-made application software, which makes it possible for companies to completely switch to technologically independent import solutions, "said Dmitry Tarakanov, head of the department for the development of technological cooperation at Astra Group.

{{quote "In the context of increased attention to domestic developments, it is important to maintain and expand the map of Postgres Pro compatible solutions, in which there are already more than 230 products. Astra Linux vendor is one of the market leaders whose solutions are in demand among users, so joint integration is another step to expand the technological capabilities of our customers, - said Ivan Panchenko, Deputy General Director, co-founder of Postgres Professional. }}

Assessment of updated FSTEC requirements for information security to DBMS

On November 17, 2023, Postgres Professional announced that it had evaluated the certified versions of the Postgres Pro Standard DBMS and Postgres Pro Enterprise DBMS in accordance with the FSTEC information security requirements for the DBMS of April 14, 2023, approved by the Ministry of Justice in July 2023.

According to the company, certified versions allow you to use Postgres Pro in critical infrastructure of the first category and state information systems of the first class of security.

The secure development processes implemented in Postgres Professional, the system of quick release of releases and regulator support help us to quickly respond to the release of FSTEC requirements. In addition, we respond to the appearance of CVEs (security bugs) in the PostgreSQL open source DBMS and quickly fix them in Postgres Pro releases. noted Ivan Panchenko, Deputy General Director, co-founder of Postgres Professional

Previously certified versions of Postgres Pro mostly already met the requirements and contained the necessary protection mechanisms. To fully comply with the new requirements, the following changes were made to the DBMS:

• Updated documentation.
• The role model of the DBMS has been finalized. The roles of the DBMS administrator (PGPRO_DBMS_ADMIN), the DB administrator (PGPRO_DB_ADMIN) have been entered, the capabilities of the superuser are limited. This certified version of the DBMS has been updated with a Postgres Professional-developed patch to restrict role rights with the CREATE ROLE attribute. Now such a role can create a role only with the privileges that it possesses.
• Some commands and utilities have been improved - for example, CREATE PROFILE for the ability to work without a superuser, as well as a pg_integrity_check integrity utility, which will now be able to check the integrity of procedures in several databases.
• The pg_proaudit module has been improved, which allows you to register security events.

The updated version of Postgres Pro Certified supports three versions of the database engine: 11.21.2, 14.9.2, and 15.4.2. Compliance Certificate No. 3637 was re-issued on October 20, 2023. The updated version of Postgres Pro Enterprise Certified supports four versions of the database engine: 11.21.2, 13.12.3, 14.9.3 and 15.4.3. Certificate of Compliance No. 4063, reissued November 3, 2023. Postgres Pro DBMS Security Measures

Postgres Professional quarterly releases Postgres Pro Standard and Postgres Pro Enterprise updates based on the latest versions of PostgreSQL DBMS. Postgres Professional has implemented secure development processes, ON including static code analysis, dynamic code testing analysis, and analysis vulnerabilities in the code and components used. For testing, open-label software proprietary software Institute of System Programming of the Russian Academy of and company's own developments are used.

In addition to timely updating the functionality of the Postgres Pro DBMS, Postgres Professional regularly reports errors and vulnerabilities found in PostgreSQL to the community of this open DBMS. The list of vulnerabilities discovered by all PostgreSQL developers is published quarterly simultaneously with the release of the next minor releases. Postgres Professional releases its own products that fix vulnerabilities from this list in a month.

Postgres Professional uses information from the FSTEC vulnerability database and other open sources, exchanging information with the FSTEC NOS: the company's team of experts examines the source code for the impact of the vulnerability on functioning and offers compensatory measures. Postgres Professional is listed in the FSTEC NOS as a Russian DBMS vendor based on PostgreSQL.

In October 2023, Postgres Professional announced the release of Postgres Pro Standard 16. Its certified version of FSTEC will appear after the next inspection control.

In December 2023, Postgres Professional plans a major release of the flagship Postgres Pro Enterprise 16, which will include a number of solutions and improvements. In 2024, it is planned to release the next certified version of Postgres Pro Enterprise Certified.

Compatibility with Pragmatic Tools Migrator

Pragmatic Tools and Postgres Professional announced compatibility of their products on October 19, 2023. Testing and correct collaboration of the Pragmatic Tools Migrator system and Postgres Pro DBMS are confirmed by the corresponding certificate. The companies also announce the continuation of the technology partnership. Read more here.

Postgres Pro Standard Release with Debian 12 Support

The company Postgres Professional announced minor version updates DBMS Postgres Pro Enterprise and the Postgres Pro Standard on August 28, 2023. Releases issued for versions 11.21.1, 12.16.1, 13.12.1, 14.9.1, 15.4.1. A major update of both editions of the DBMS is expected after the release of version 16 of the Postgre open DBMS. SQL More. here

Turbo X compatibility

The automation platform business processes TURBO X has been certified for technological compatibility the Russian database management system with Postgres Pro. This was LANIT announced on May 17, 2023. More. here

RooX UIDM Compatibility

RooX on April 24, 2023 announced the compatibility of the RooX UIDM authentication and authorization management system with the PostgreSQL open database and its Postgres Pro build from the Russian company Postgres Professional. Read more here.

Compatibility with LEAD WMS FX

The Russian warehouse management system from LogistiX has been tested and confirmed correct operation under high load conditions on the Russian Postgres Pro Standard database management system. LogistiX announced this on April 21, 2023. Read more here.

Support by SearchInform CIB system

SearchInform presented an update to the DLP system - the solution implements support for the freely distributed PostgreSQL and its domestic analogue Postgres Pro. This became known on January 17, 2023. Read more here.

2022

Widnows End of Support Plan

The developer the Russian DBMS of the Postgres Pro line, the company, Postgres Professional intends to abandon support in its products. operating systems Microsoft Windows This was announced on November 2, 2022 by the deputy general director of the company. He Ivan Panchenko clarified that his organization has already decided for sure that the line will not OS Windows be supported in the next release under number 15 of the Enterprise-class DBMS for corporate clients.

As reported, as for the update of the standard version of the Standard DBMS for a wide range of customers, which may appear in November 2022, the developers have not yet made a decision to maintain or exclude support for the OS of the Western software giant.

In general, the company adheres to the idea that support for any product cannot be stopped at once. For this reason, changes regarding the exclusion of support for the Windows line of previous versions of the Postgres Pro DBMS will not affect.

Postgres Pro commercial DBMS is developed by Postgres Professional on the basis of classic free. PostgreSQL As of November 2022 Russia , it is the most popular product import-substituting in projects to switch from DBMS and. Oracle Microsoft

As Panchenko said, his company estimates the demand for support for Microsoft Windows as very low. According to the top manager, some demand for support for this OS is mainly maintained by small companies working with the software of the Russian company 1C.

Postgres Professional for November 2022 is trying to integrate as tightly as possible in its developments with current Russian technologies - both software and iron.

According to the top manager, his company supports all options for Russian processor architectures. In particular, he mentioned the Elbrus line, which is being developed by ICST.

We still support the Power processor architecture. Why? Because during testing, you can find bugs on it that cannot be found on Intel[1]. supplemented by Ivan Panchenko, deputy general director of the company

Compatible with Logistics Vision Suite

On August 8, 2022, ANT Technologies announced the verification and certification of the compatibility of the Logistics Vision Suite WMS warehouse management system with the Postgres Pro database management system. Testing by Logistics Vision Suite and Postgres Pro Standard has proven the robust health and responsiveness of software products, enabling joint solutions to build IT infrastructure for warehouse management. Read more here.

Compatible with all Axelot solutions

All software solutions developed by AXELOT have been certified and officially confirmed 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 and more organizations are forced to think about import substitution ON a complete 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 it had completed a set of tests of its software products together with Postgres Professional.

The results of tests performed in the domestic environment OS Viola confirmed the compatibility Mail Server Tegu Enterprise DBMS of PostgresPro. The components of the process stack work reliably, and load tests confirm several times the speed of operation than similar ones. servers More. here

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

A group of Russian developers consisting of RED SOFTWARE, BellSoft, Postgres Professional and EMDEV confirmed the correct collaboration of their software products. The installed Postgres Pro DBMS 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. Read more here.

2021

Postgres Pro Standard 14.1.1 with improved reliability and ease of use

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

This release is based on PostgreSQL 14.1, its distinctive feature is that the release contains all the functions and improvements of the main, original version - PostgreSQL 14, as well as corrections made to PostgreSQL 14.1. In addition, the release 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 zero 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 - the pgpro_pwr extension has been updated in Postgres Pro Standard 14.1.1. Now the Load distribution section has been 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 recorded, etc.). In addition, the tables of the reports "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 discontinued support for the legacy extension sr_plan and there is no WAITLSN statement incompatible with the SQL standard. Mamonsu has been updated 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 DZ Systems and Postgres Professional have 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. Read more here.

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

On August 26, 2021, the Galaxy AMM production management system was presented at the Postgres Pro DBMS. Read more here.

Nutanix AOS Compatibility

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

This collaboration opens up additional opportunities to choose 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 For Postgres Pro databases hosted virtualized in Nutanix environments, compatibility, proper operation of built-in functions, high performance and scalability are provided for solutions of both companies.

Testing was conducted for Postgres Pro Standard and Postgres Pro Enterprise versions on a hyperconverged computing platform running Nutanix AOS. The operation of databases has been tested both in conjunction with the built-in Nutanix AHV hypervisor and with the ESXi hypervisor.

Key pros available to Nutanix and Postgres Pro customers:

• Enterprise-level DBMSs, including for high-load, open-source systems with improved performance, reliability and security,
• validated hardware and software platforms, including typical technical solutions and sizing tools for rapid deployment,
• predicted infrastructure scalability through web-scale architecture.

{{quote "Our solutions are designed to build large PostgreSQL clusters with high availability. We have worked to achieve high efficiency and reliability in virtualized environments running Nutanix. This goal has been achieved, which is subject to joint tests. Now we expect that an increasing number of customers using Nutanix's private and public cloud environments 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 databases based on open source developments, and among them 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 Fintech Centre and Postgres Professional have signed a formal cooperation agreement. As a result of this stage of the partnership, the number of CFT solutions and customers using the Russian Postgres Pro DBMS will be expanded. This was announced on May 12, 2021 by the CFT. Read more here.

Compatibility of Postgres Pro version 13 with RuBackup backup module

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

As of April 2021, RuBackup supports full and differential backups of any Postgres Pro version 13 database clusters. Read more here.

2020

Availability for Docsvision 5.5.2

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

Postgres Pro Standard 11 and Standard 12 compatibility with Polycode platform

The Polilog agency, the developer of the Polycode software platform, and Postgres Professional, the domestic developer of the Postgres Pro DBMS, announced on August 17, 2020 that they had tested the compatibility of their solutions. The test results confirmed the guaranteed uninterrupted operation of Polycode with two versions of the Postgres Pro Standard 11 and Postgres Pro Standard 12 DBMS. Read more here.

Postgres Pro Cloud launch

On July 16, 2020, it became known that the cloudy platform Mail.ru Cloud Solutions , together Postgres Professional with, developed cloud service the managed Database-as-a-Service databases- Postgres Pro Cloud model. The solution provides reliable and secure performance and information storage easy scaling.

The partnership Russian between DBMS Postgres Professional cloudy Mail.ru and Cloud Solutions allows you to improve the operational characteristics of the relational management system, databases and also eliminates the need for customers to invest in the purchase of hardware and software resources. In addition, the solution provides easy database scaling: you can increase volume and power in the cloud.

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 receives a ready-to-use database in the desired configuration in a few clicks. Installation, configuration and support of DBMS is carried out on the side. provider Placing the database in the cloud allows you to organize safe storage: data high availability and reliable information protection storage combined backup with and fault-tolerant storage mitigate the risk of loss and. To leaks work with data, users of the cloud platform can connect processing services analysts and build on this basis. Data Lake

Companies interested in using a scalable and secure database with a per-second charge for expended resources can transfer data to Postgres Pro Cloud from any source: private or public cloud or physical infrastructure. Experts from Mail.ru Cloud Solutions and Postgres Pro help with migration and advise on building a scalable and fault-tolerant storage structure, as well as setting up interaction with On Premises systems, ETL and Streaming processes, building Data Warehouse and Data Lake.

Placing Postgres Pro in the MCS cloud gives our customers the opportunity to 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.

Cloud services are another stage of development for databases and DBMS, so cooperation 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 DBMS even more accessible to users, - Ivan Panchenko, co-founder, deputy general director of Postgres Professional.

As part of the PAC "BASEALT," EOS, Postgres Professional and "Norsi-Trans" for automation MPSC

On April 30, 2020, the company BASEALT"," and EOS Postgres Professional NORSI-TRANCE announced the creation of a programmaticallyhardware complex for multifunctional centers for the provision of state and municipal services (). MPSC More. here

2019

Inclusion in DeviceLock products

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

Security Vision Compatibility

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

DirectumRX Compatibility

On May 30, 2019, DIRECTUM announced that it had checked the compatibility of its products with Postgres Professional - DirectumRX ECM systems and Postgres Pro DBMS. The results of technical testing proved the correctness of their collaboration. Read more 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 platform Postgres Pro/PostgreSQL of a designer of user web interfaces to databases - Live Universal Interface (LUI). Read more here.

SafePhone Compatibility

On March 27, 2019, Postgres Professional announced that it had conducted compatibility testing with the SOKB Research Institute. The test results confirmed the full compatibility of the SafePhone 4.0 EMM platform with the Postgres Pro Certified 10 DBMS.

Earlier, the SafePhone EMM solution used primarily foreign-made DBMS, which, due to an active import substitution policy, was a blocking factor for some organizations, says Maria Yukhova, head of the marketing and sales department. - Now we are glad to offer our customers a SafePhone mobile platform using a certified domestic DBMS - Postgres Pro Certified 10. In this configuration, the SafePhone 4.0 mobile platform is perfect for organizations that are highly responsible for regulatory compliance issues.

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

Compatibility with the Alt family of operating systems

On March 26, 2019, BASEALT"" announced that it had Postgres Professional successfully completed compatibility testing of the latest versions DBMS of Postgres Pro Standard v. 11 manufactured by Postgres Professional and operating systems () OS of the "Viola BASEALT" family. Confirmed the correctness of product collaboration, which allows you to recommend them for building an enterprise IT infrastructures of any scale and complexity.

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 BASEALT. - The platform is capable of working on domestic computing equipment of different architectures, compatible with a wide range of domestic application software, which makes it possible for organizations to completely switch to technologically independent domestic solutions.

A complex of Alt operating systems, 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 a service level agreement (SLA ) valid throughout Russia. If necessary, the serviced complex can be expanded with other software, as well as hardware.

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 system market, so partnership with BASEALT and integration of our products are of strategic importance to us.

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

Lotus OS Compatibility

On March 18, 209, Postgres Professional reported that the results of technical testing confirmed the compatibility of the Postgres Pro database management system and the Lotus operating system. Read more here.

Compatibility with Documentino EDMS

On March 4, 2019, ID Management Technology"," ECM Documino Postgres Professional database management systems a platform developer, and Postgres Pro developer announced compatibility of their software products. More. here

Compatibility with CompanyMedia

On February 21, 2019, Postgres Professional announced that it had conducted compatibility testing with InterTrust. The test results confirmed the full compatibility of the CompanyMedia 5 document-oriented business process management system with the Postgres Pro 10 DBMS. Read more here.

Compatibility with 1C:Enterprise 8

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

Forsyth compatibility. Analytical platform

On January 23, 2019, Forsyth announced that it continues to develop a technological partnership with Postgres Professional. The companies ensured the compatibility of their solutions by combining the capabilities of the Forsyth software complex . Analytical Platform "and Postgres Pro DBMS. Read more here.

2018

Red OS Compatibility

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 bilateral compatibility certificate was signed.

RED SOFT AND Postgres Professional friends in several planes. In addition to bilateral technological cooperation, we work shoulder to shoulder in the Committee on integration Russian ON , ARPP "Domestic Software" we jointly participate in activities under the auspices of this structure. Testing for compatibility of our products is a natural process. 'Rustam Rustamov, Deputy General Director of RED SOFT '

In March 2018, we entered into a technological 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. 'Ivan Panchenko, Deputy CEO of Postgres Professional '

Compatibility with "Logic: SW EDO" and "Logic: EDMS"

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

Postgres Pro Standard Release 10.5.1 and 9.6.10.1

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

Updated releases of Postgres Pro for major versions 10 and 9.6 - Postgres Pro Standard 10.5.1 and Postgres Pro Standard 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 display the scheduling time.
• Fixed an issue where some Hunspell dictionaries with FLAG num affixes, such as ru_aot, could not be used.
• The module pg_probackup updated to version 2.0.19, in which the following features appeared:
  • The cluster can now be restored to a specified log position (LSN).
  • If one of the parent copies is corrupted, the incremental copy is ORPHAN (lost).
  • The show-config command now shows both the changed pg_probackup parameters and the values ​ ​ that remain unchanged. Its output can now be obtained in JSON format to simplify perception.
  • Restore can skip copy validation to speed up cluster recovery.
  • Improved 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.

• Improved version of Postgres Pro Standard for Windows:
  • Removed an implicit limit on the number of files opened simultaneously in each server subprocess.
  • Added the ability to disable checksums in the cluster. By default, checksums are enabled when Postgres Pro is installed.
  • Added support for the pg_probackup module.

When upgrading from the Postgres Pro Standard version based on the same main release of PostgreSQL, it is enough 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 have previously used pg_repack on Debian-based systems, you will need to manually reinstall the package when upgrading to version 10.5.1 because it was renamed pg-repack-std-10.

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

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 display the scheduling time.
• Auto-cleaning now immediately removes temporary tables that have become unnecessary to avoid littering the pg_class.
• Fixed an issue where some Hunspell dictionaries with FLAG num affixes, such as ru_aot, could not be used.
• The module pg_probackup updated to version 2.0.19, in which the following features appeared:
  • If one of the parent copies is corrupted, the incremental copy is ORPHAN (lost).
  • The show-config command now shows both the changed pg_probackup parameters and the values ​ ​ that remain unchanged. Its output can now be obtained in JSON format to simplify perception.
  • Restore can skip copy validation to speed up cluster recovery.
  • Improved 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 merge process can damage backups.

• The Windows version of Postgres Pro Standard has been finalized:
  • Removed an implicit limit on the number of files opened simultaneously in each server subprocess.
  • Added the ability to disable checksums in the cluster. By default, checksums are enabled when Postgres Pro is installed.

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

To update the DBMS from Postgres Pro Standard, based on the previous main release of PostgreSQL, you can upload/restore data using the pg_dumpall, or use the pg_upgrade utility. 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.

You do not need to upload/restore data to upgrade from Postgres Pro Standard, which is based on the same basic release of PostgreSQL. If you upgrade 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 directory number changed after Postgres Pro Standard 9.6.4.1, and also renames the pgpro_build function to pgpro_source_id. When updating the installation of Postgres Pro using a binary package, the script is pgpro_upgrade launched automatically, or it is proposed to run it manually.

When starting the pgpro_upgrade manually, you need to stop the postgres service. This script must be run by the database owner (usually postgres). An error will occur when trying to run the pgpro_upgrade as root. For details, refer to the description of the pgpro_upgrade.

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

On Linux distributions with RPM package system, when upgrading from version 9.6.2.1 or earlier, you must rename the pgsql data directory to pgpro before running the pgpro_upgrade script.

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

Postgres Pro 10.4.1

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

• updated the jsquery module, which is responsible for queries to the jsonb data type;

• The pg_probackup Database Cluster Backup and Recovery Management Utility has been upgraded to version 2.0.17 with new features. for example, DELTA mode has been added, in which all data files in the directory are read and an incremental copy is created for pages 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, which fixes a number of errors;

• fixed the sorting of the letters "E" and "Y" in the mchar module, which provides additional data types for compatibility with Ms SQL Server;

• finalised the Postgres Pro Standard version for. Windows

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

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

RED SOFTWARE, developer of RED OS, and Postgres Professional, developer of 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 DBMS Postgres Pro with the operating systems RED OS and Goslinux was confirmed. Performance and fault tolerance were evaluated using load testing methods for versions of the 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 from the Information Technology Department 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 PostgreSQL 10.1 open database and has a number of differences.

In this version of the Postgres Pro Standard 10.1.1 DBMS, there is functionality of the current version of the PostgreSQL DBMS, some errors have been fixed. All improvements 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 DBMS and the "vanilla" version of PostgreSQL:

• added including indexes and waitlsn in the kernel;
• includes all patches and extensions required for 1C operation;
• ICU 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 set with the create extension hunspell_ru_ru command;
• extensions dump_stat, jsquery, pg_query_state, pg_pathman, pg_tsparser, pg_variables, sr_plan, shared_ispell are also present in the distribution;
• the kit comes with an incremental backup utitilite pg_probackup;
• fully translated into Russian documentation, including man-pages on Linux.

Under the operating system, Windows psql works in unicode and displays any characters to the console. As a pager comes less. In psql, a story works under Windows, the addition of keywords is performed by the "tab" key. The binary installation package structure for different Linux distributions is unified, and although it differs from the vanilla PostgreSQL structure, it provides a number of advantages.

The Postgres Pro Standard 10.1.1 DBMS is available for download for free and is distributed under the PostgreSQL license 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, Postgres Pro a 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, DBMS PostgreSQL signed 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, recording and responding to information security incidents. Postgres Pro DBMS is developed on the basis of the PostgreSQL open source system and is adapted to the requirements of Russian users. Particular emphasis in development is placed on cluster technologies, working with semi-structured data and improving performance, pointed out in Postgres Professional.

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

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 the Postgres Pro DBMS certified according to the requirements of FSTEC allows us to ensure compliance with the security requirements put forward by domestic regulators, "- commented on the event CEO of R-Vision Alexander Bondarenko.

We consider the compatibility of Postgres Pro DBMS with application solutions of Russian developers to be one of the most important tasks and a criterion for 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, says Oleg Bartunov, CEO of Postgres Professional.

1C:Enterprise 8 is compatible with Postgres Pro

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 partner network of 1C.

Integrating 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 progress in solving automation problems based on domestic solutions. Oleg Bartunov, CEO of Postgres Professional

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

Postgres Pro DBMS hosted in 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 have access to the Postgres Pro Standard DBMS and the most advanced version Postgres Pro Enterprise developed by Postgres Professional based on the project with. open source PostgreSQL

Postgres Pro Enterprise database management system is developed by Postgres Professional specifically for high-load systems of large enterprises. The functions implemented in Postgres Pro Enterprise are indispensable for information systems operating in hundreds of millions of transactions per day. Dozens of important functions have been added to it: block-level data compression can reduce the physical volume data storage from 2 to 10 times, a multimaster cluster provides transaction processing on several servers as a single complex, optimized partitioning allows you to work with thousands of sections.

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

Postgres Pro Standard 9.6.3.1 released

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.

Changes implemented:

• support for Ubuntu 17/04
• pg_tsparser for full-text search.

The base version contains many fixes. The developers recommend an update. Corrective version 9.5.7.1 has been released.

Among the major improvements are:

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

• The module pg_pathman updated to version 1.3.2. This version is compatible with the current release.
• The sr_plan module now works with a non-standard search_path value.
• Fixed an error that corrupted the spanning indexes in the WAL.
• Added distribution packages for SUSE Linux Enterprise Server 12 SP1 and Ubuntu 17.04.
• Improvements have been added to optimize inheritance.
• The PTRACK revision 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 postgresists, it brought together more than 500 people from Russia, countries of 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 fixes.
• module pg_pathman updated to version 1.3
• The sr_plan module is now initialized independently for each database instance.
• Applied patches for spanning indexes.
• RHEL Postgres Pro systems are now installed in a separate location - it can be installed simultaneously with the current PostgreSQL installation.
• improved algorithm of automatic selection of TCP port in case of parallel installation of different versions of Postgres Pro on Windows systems.
• Updated the pg_probackup Backup Manager.

2016

Postgres Pro became the main DBMS for EDMS "Delo"

On November 29, 2016, the press service of the company announced the conclusion of an agreement on joint development by Postgres Professional and Electronic Office Systems (EOS). The first joint project is the release of the EDMS "Delo" on the Postgres Pro DBMS platform.

More details on the page#.2A_.D0.9F.D0.B5.D1.80.D0.B5.D0.B2.D0.BE.D0.B4_.D0.A1.D0.AD.D0.94_.D0.BD.D0.B0_.D0.A1.D0.A3.D0.91.D0.94_Postgres Translation of the EDMS into the Postgres DBMS

Postgres Pro DBMS receives Russian FSTEC compliance certificate

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 security class, as well as to ensure up to 1 level of personal data security in information systems.

Postgres Pro DBMS complies with the requirements of the guiding documents "Computer tools. Protection against unauthorized access to information. Indicators of protection against unauthorized access to information "(State Technical Commission of Russia, 1992) - according to the 5th class of protection," 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 level 4 of control and technical specifications when fulfilling the operating instructions given in the form.

Certification tests were carried out by the testing laboratory of NPO Echelon CJSC. Alexander Barabanov, Director of the Certification and Testing Department of NPO Echelon, noted: "We are glad that one of the advanced database management systems, finalized taking into account the requirements of Russian law, has successfully passed tests according to the rather serious requirements of the regulator. It is worth noting that the certificate of the FSTEC 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 the certified version of the Postgres Pro DBMS

• Functionally fully complies with the standard version of Postgres Pro 9.5.2.1 with support for row level security (RLS).
• It has built-in protection against unauthorized access to information, including cleaning RAM and disk memory (cleaning files
• In external memory before deleting, clearing line versions (clearing pages) before deleting, clearing RAM before freeing, clearing the proactive write log before deleting or overwriting).
• It has built-in integrity control of executable files, configuration files and system directory tables.
• It operates under the following operating systems:
  • Astra Linux Special Edition RUSB.10015-01
  • OS DEW SX Cobalt - 64-bit
  • OS Rosa DX64 Cobalt - 64-bit
  • ALT Linux SPT 6.0 - 64-bit
  • ALT Linux SPT 7.0 - 64-bit
  • OS GosLinux 6

Certified DBMS Postgres Pro 9.5.2.1 can be purchased on disk. The disk is accompanied by a form, a copy of the certificate of conformity and documentation for the set of security tools of the Postgres Pro 9.5.2.1 DBMS.

Launch of cloud service

In the summer of 2016, Postgres Professional signed the first agreements with Russian data center service providers to offer customers a local version of the PostgreSQL DBMS as a cloud service. Similar foreign services, according to the developers, are serious competition for them.

Stack Group Services

In August 2016, Stack Group, a service provider based on its own data centers, and Postgres Professional signed a cooperation agreement, under which they plan to offer their customers specialized solutions based on DBMSostgres Pro (the Russian version of PostgreSQL) from the cloud using a subscription model.

Stack Group notes that PostgreSQL DBMS is one of the most popular database Solutions SaaS in the world that can be consumed from a virtual environment.

DataLine Services

In July 2016, DataLine announced plans to launch a PostgreSQL-based cloud service. To do this, she also signed an agreement with Postgres Professional. The service includes fault-tolerant virtual machines with deployed PostgreSQL-based DBMS, full automatic backup, the ability to customize and optimize DBMS for the tasks of each customer, as well as administration.

The service is scheduled to go into commercial operation in September 2016.

Potential Service Users

PostgreSQL cloud services allow customers to forget about problems with ensuring high availability of DBMS and about independently solving a significant part of database administration tasks - this is taken over by the provider, said Ivan Panchenko, deputy general director of Postgres Professional, in a conversation with TAdviser. He believes that potentially such services are of interest to almost all DBMS users, and the choice will be determined by economic feasibility.

DataLine expects that PostgreSQL-based services will be of interest to everyone who wants to use domestic developments in the field of databases. The public sector is especially closely eyeing such alternatives, the company says: "the choice in favor of free software with support from Russian developers is consistent with the course of import substitution in the IT industry."

If the task is to reduce the cost of licenses for software, then PostgreSQL will be in demand in a company in any industry, added to DataLine.

Vladimir Lebedev, Business Development Director of Stack Group, believes that the service is interesting for companies that prefer to use open source software to build and optimize information systems.

First of all, these are software developers, SaaS services providers, companies that support their own corporate information systems, as well as companies from the e-commerce industry. As for the size of the business, these can be both customers of the SMB segment and Enterprise level, - said TAdviser Lebedev.

Roman Limberger, head of the SaaS department at CROC, on the contrary, believes that the PostgreSQL database service from the cloud is not very interesting to large Russian businesses, except for solving problems in developing software products: "Large companies thinking at the level of information systems in general, the possibility of renting DBMS is hardly interesting. More in demand is to transfer the information system itself to the cloud, "he believes. According to Limberger, such a service may be of interest to the SMB sector in order to reduce costs and receive technical support.

Roman Limberger added that the most attractive for CROC customers is the traditional implementation of Postgres DBMS within the framework of complex projects. At the same time, if one of the company's customers has a need to use the PostreSQL cloud service, CROC will be able to provide it on the basis of its own public cloud, he concluded.

Alexey Cherevkov, Director for the Development of the Competence Center, Department for the Development of Cloud Services and Products of Servionica (I-Teco Group of Companies), believes that such a service can become the basis for the provision of other services related to the development, administration, and provision of related infrastructure. In this context, in his opinion, such services can be quite in demand.

Cherevkov added that Servionica is focused on developing and implementing a platform for providing IaaS services, within which it uses the Postgres DBMS.

Many years of experience "Servionica" shows that this is one of the most stable DBMS capable of working with large amounts of data and versatile requests. The company does not plan to provide DBMS as a separate cloud service in 2016, - said the representative of Servionica.

Orders of magnitude cheaper than Oracle

Vladimir Lebedev from Stack Group notes that the cost of the computing resources themselves involved in organizing the Oracle and PostgreSQL databases will not differ, but the cost of the Oracle cloud service may be orders of magnitude higher than PostgreSQL due to the licensing policy and the cost of Oracle-based solutions.

A license for using one Oracle server can reach several hundred thousand rubles a month, while PostgreSQL is distributed free of charge, and the cost of the service will be based mainly only on its support, - explained TAdviser Lebedev.

The representative of Stack Group added that at the same time, the targets for using PostgreSQL and Oracle differ and overlap only in a small percentage of use cases: Oracle is Enterprise-level loaded IT systems, and PostgreSQL DBMS is more focused on the middle segment, although it is also able to solve the problems of part of the Enterprise segment, concluded Vladimir Lebedev.

Russian "registration" as an advantage

Abroad, PostgreSQL cloud services offer, for example, the Heroku and Aliyun projects. Ivan Panchenko from Postgres Professional notes that foreign services are serious competitors. In this regard, Russian services, first of all, can count on demand from those who are obliged to store their data in Russia.

It is also of some importance that the service will be provided on the basis of the Postgres Pro DBMS, the Russian version of PostgreSQL, which is included in the register of domestic software, and is under certification in FSTEC, after which it will be possible to create systems on its basis to store personal and confidential data.

Postgres Pro - Russian fork PostgreSQL

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

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 check performance and adapt the DBMS to the capabilities of Hitachi servers.

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

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

author = Irina Yakhina, Head of Technology Solutions at HDS Database Management System PostgreSQL in itself deserves close attention of customers - the course of import substitution only pushes it to development. Today, for such young and rapidly developing services, it is necessary to think well about a strategy for promotion on the Russian market: all processes, from 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, which 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

author = Ivan Panchenko, Deputy General Director of Postgres Professional The partnership and Postgres Professional Hitachi Data Systems will certainly be of great benefit to both companies. Testing on PostgreSQL a hardware platform HDS and adapting DBMS to server features Hitachi allows you to plan the development of new business solutions, focusing on how to develop HDS technologies with a global reputation.

Postgres Pro tested on Inspur hardware platform

Postgres Professional and Inspur, a provider of end-to-end cloud computing solutions and services, have completed functional and load testing of Postgres Pro on the Inspur NF Series rack servers.

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 stability, competitive work under heavy loads, scalability, cross-platform, extensibility and high compliance with key industry standards, including ANSI SQL 92, ANSI SQL 99 and ANSI SQL 2003, 2011.

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

Notes