PostgreSQL is distribut under its own free license, similar to the BSD or MIT licenses. The documentation is in Russian, but professional support is paid.
The license allows creating various versions, including commercial ones, on the basis of the main product. For example, in Russia, the Postgres Professional company is developing the Postgres Pro distribution . This version is certifi by FSTEC and a number of large Russian organizations for import substitution purposes. But if the team is familiar with the DBMS and is not afraid of being left without vendor support, and the information security requirements are not so strict, then there is no particular sense in switching to the commercial version.
For Bitrix24 on PostgreSQL, you ne to purchase a special license “Enterprise for Postgres”, since the regular “Enterprise” license is intend for MySQL. If you plan to switch from MySQL to PostgreSQL, then the vendor provides a key for 6 months for testing.
Methods for converting a database from MySQL to PostgreSQL
For projects that previously work on MySQL, there are several ways to convert the database:
- manually, via the command line in the server console
- using the Migration Wizard built into Bitrix24
- using third-party utilities: pg_dump and pgloader. The latter supports on-the-fly conversion, but requires instructions on converting data types (and there are usually many of them).
The vendor recommends using the first two migration options and has prepar the corresponding instructions for them . When choosing any of the albania email list methods, you ne to take into account that not all modules that work in Enterprise will be support in Enterprise for Postgres. After migration, some functionality may be disabl. You can check this either using the code from the instructions, or it will happen automatically during the migration wizard.
In particular, the following modules will be disabl:
- BI connector;
- Wiki;
- A/B testing, Web analytics, Conversion, Advertising and banners;
- Web Services and Web Forms;
- Report designer and some others.
In other words, if you switch to Bitrix24 or 1C-Bitrix:Site Management with PostgreSQL support, you are guarante to be left without analytics and marketing “out of the box” . In total, up to 18 modules can be disabl.
How to replace the disabl functionality
Some of the modules that can be disabl are china numbers rarely us and can be painlessly abandon. For example:
- The “Advertisement and Banners” module allows you to organize the display of advertising banners on the site. However, if the owners of the resource with the Enterprise license do not earn money from monetizing advertising on the site, then the module is not particularly ne.
- A/B testing can be done not only with the built-in B24 tool. Google Analytics, Google Optimize, A/B Experiments and Varioqub from Yandex, UX Rocket and others are also suitable for this.
- Wiki is an important part of internal organizational learning, but this module is outdat and has been gradually replac by a more functional Knowlge Base.
- Document flow. The same outdat module as Wiki, which is rarely us. The task of document approval is often solv with the help of business processes, automat workplaces. For personnel document flow, there is a built-in KO.
The modules includ in the assembly are enough
To solve most problems, but if you ne PostgreSQL along with something rare and special, we will help. We will develop a module of any complexity to suit your requirements.
For example, the BI connector is what licenses will be needed? design to connect to external BI systems to process statistical data collect during the operation of the portal and website. Very useful functionality, but there is no ready-made alternative. To ensure that you do not lose the ability to make decisions bas on data, we will help you integrate the site or portal with an external analytics system, such as Yandex Data Lens or Power BI. If this solution is not suitable, we will create an analytics subsystem inside Bitrix.
The task of migrating to PostgreSQL for large and load projects is necessary and useful, but not easy. If you are not ready to risk your data and do everything yourself, fill out the form below. Our analyst will contact you to arrange an online meeting, where we will answer your questions and discuss the details.
