Bitrix24 on PostgreSQL: the need for transition and migration guide

[mdabuhasan]

Legislative context
The official Internet portal of legal information published the decree of June 13, 2024, No. 500, which introduces significant amendments to the decree of May 1, 2022, No. 250 "On additional measures to ensure information security of the Russian Federation". The document applies to government agencies, state corporations and critical information infrastructure (CII) entities.

The new amendments significantly expanded the existing ban on the use of information security systems from unfriendly countries. Starting in 2025, companies covered by the decree will be prohibited from using any cybersecurity services (including work and services) from organizations in these countries. It is important to note that the ban previously only applied to the installation of software.

Who and why should whatsapp number list switch from MySQL to PostgreSQL
For a long time, MySQL was the only database option for Bitrix24, which was widely used by many state-owned companies and large businesses to solve various problems. However, from May 1, 2022, this solution no longer complies with the requirements of Russian legislation.

In response to the changed requirements, Bitrix24 announced the release of a special edition based on PostgreSQL. This solution gives customers the opportunity to switch to a fully Russian technology stack, ensuring compliance with all regulatory requirements.

PostgreSQL: A Detailed Overview of Features
PostgreSQL is deservedly considered a recognized standard in the Russian market of database management systems (DBMS). The system fully complies with the requirements of the Russian Federation legislation and current information security standards. It is a free DBMS with open source code, allowing you to create, store databases and work with data using queries in the SQL language.

As of 2022, PostgreSQL ranked fourth in the global ranking of popular DBMS. Let's take a closer look at all the key advantages of the system:

1. Free access
PostgreSQL provides the ability to install and immediately start working with databases for free. The only possible costs are associated with placing the database and DBMS in cloud storage, if necessary.

2. Cross-platform
The system demonstrates excellent compatibility with all popular operating systems, including Linux, macOS and Windows. It is especially important that the user receives a fully ready-to-use solution "out of the box" - installation and start of use do not require additional tools or complex settings.

3. Support various data formats
PostgreSQL has extensive capabilities for working with various data types and structures, including:

Network addresses
Data in JSON text format
Geometric data for geolocation coordinates
Many other specialized formats
4. Scalability
One of the key advantages of PostgreSQL is the absence of restrictions on the size of the database. The only limiting factor is the amount of free memory in the storage location, be it a server, a local computer or cloud storage.

5. ACID Compliance
PostgreSQL is fully ACID compliant:

Atomicity
Consistency
Isolation
Durability
6. Modern functionality
The system supports all modern database functions, including:

Window functions
Nested transactions
Triggers
Advanced capabilities for working with data
7. Optimized SQL dialect
About 80% of operations in the DBMS are performed using classic SQL. At the same time, PostgreSQL offers its own optimized queries for certain actions, which significantly simplifies working with the database.

8. Replication capabilities
PostgreSQL supports logical replication, which allows you to create and synchronize copies of the database on different servers. In this case, all changes are automatically synchronized in all copies, ensuring data integrity.

9. Ease of migration
The system provides effective tools for data migration from other DBMS. Small and medium-sized companies can migrate quickly and without data loss, while for large companies with data volumes of about 10 terabytes, the process will require more careful planning.