Arenadata Documentation
Our passion is to build efficient flexible solutions that scale up to dozens of petabytes
ADB
ADH
ADQM
ADS
ADPG
ADCM
ADPS
ADSCONTROL
Showing results: 5 of 16. See all results...
Products
Explore our range of solutions in the world of Big Data

Arenadata Postgres

Arenadata Postgres (ADPG) is a DBMS for efficient work with loads of different profiles (primarily OLTP - Online Transaction Processing). ADPG allows you to work with various amounts of data and supports a wide range of data types (including JSON and custom types) with the ability to create data processing mechanisms.
ADPG key features:
  • complex queries that process large amounts of data with complex analytical functions (including user behavior analytics);
  • variety of reporting types (operational, managerial, mandatory regulatory);
  • deep AD-HOC analysis;
  • efficient joining of large tables;
  • integration with marketing campaign systems and loyalty systems;
  • full-text search;
  • predictive analytics (demand, balances).
Use cases
Web applications

ADPG is an excellent choice for building web applications due to its support for structured and unstructured data, rich data types, and scalability. Many web applications, including social media platforms, e-commerce websites, and content management systems, use PostgreSQL as their primary database.

Analytics and business intelligence

With its advanced analytics capabilities, ADPG is an excellent choice for businesses that require robust data analysis and business intelligence tools. Its support for advanced SQL features, such as window functions and common table expressions, make it easy to perform complex data analysis tasks.

Financial services

ADPG supports for ACID transactions, multi-version concurrency control (MVCC), and data integrity. These features make ADPG an ideal choice for financial applications such as trading platforms, payment processing systems, and banking applications.

Geographic information systems

Support for spatial data types and integration with GIS tools make ADPG an excellent solution for storing and analyzing geographic data in mapping, geocoding, and routing applications.

Internet of things

ADPG can process time-series and supports JSON data types. This allows ADPG to be successfully used in IoT applications that require storing and analyzing large amounts of sensor data.

Healthcare

PostgreSQL is widely used in healthcare applications, where data security and compliance are of utmost importance. You can utilize ADPG to store patient records, medical researches, and clinical trial data.

Enterprise
Community
Offline installation
Highly available cluster
Load balancing
Built-in PostGIS
Built-in contrib
Cluster monitoring
TimescaleDB support
Technical support 24/7
Corporate training courses
Deploy & upgrade automation
Incremental/differential backups
Connection pooler
Available integrations
ADQM
ADQM
Special database's and table's engines of Arenadata QuickMarts (ADQM) allow you to replicate data form ADPG databases and single tables and use INSERT statements.
ADB
ADB
ADPG can be used as data source for Arenadata Database (ADB) as well as data storage for ADB Control and Arenadata DB Backup Manager products.
ADH
ADH
ADPG can be used as the metastore for Arenadata Hadoop (ADH) components.
ClickHouse
ClickHouse
Special database's and table's engines of ClickHouse allow you to replicate data from ADPG databases and single tables and use INSERT statements.
Greenplum
Greenplum
The postgres_fdw extensions, which have the same names in Greenplum and ADPG, can be used to access Greenplum data from ADPG and vice versa.
Apache Hive
Apache Hive
ADPG can be used as the metastore for Apache Hive.
Apache Ranger
Apache Ranger
ADPG can be used as the metastore for Apache Ranger.
Oracle
Oracle
ADPG can use the oracle_fdw extension to collect data from Oracle Database.
MS SQL
MS SQL
ADPG can use the tds_fdw extension to collect data from MS SQL Server.
MySQL
MySQL
ADPG can use the mysql_fdw extension to collect data from MySQL Server.
Apache Spark
Apache Spark
Apache Spark is compatible with ADPG via JDBC and allows you to manage and analyze big data.
Apache Superset
Apache Superset
Apache Superset Business Intelligence framework is compatible with ADPG and allows you to analyze and visualize big data.
Operating systems
CentOS
CentOS 7 is supported
RedHat
RedHat 7 is supported
Alt Linux
Alt Linux 8 SP is supported
Astra Linux
Astra Linux SE 1.7 Orel is supported
Ubuntu
Ubuntu 22.04.4 LTS is supported
Red OS
Red OS 7.3 in development
Offline installation
Highly available cluster
Load balancing
Built-in PostGIS
Built-in contrib
Cluster monitoring
TimescaleDB support
Technical support 24/7
Corporate training courses
Deploy & upgrade automation
Incremental/differential backups
Connection pooler
Available integrations
ADQM
ADQM
Special database's and table's engines of Arenadata QuickMarts (ADQM) allow you to replicate data form ADPG databases and single tables and use INSERT statements.
ADB
ADB
ADPG can be used as data source for Arenadata Database (ADB) as well as data storage for ADB Control and Arenadata DB Backup Manager products.
ADH
ADH
ADPG can be used as the metastore for Arenadata Hadoop (ADH) components.
ClickHouse
ClickHouse
Special database's and table's engines of ClickHouse allow you to replicate data from ADPG databases and single tables and use INSERT statements.
Greenplum
Greenplum
The postgres_fdw extensions, which have the same names in Greenplum and ADPG, can be used to access Greenplum data from ADPG and vice versa.
Apache Hive
Apache Hive
ADPG can be used as the metastore for Apache Hive.
Apache Ranger
Apache Ranger
ADPG can be used as the metastore for Apache Ranger.
Oracle
Oracle
ADPG can use the oracle_fdw extension to collect data from Oracle Database.
MS SQL
MS SQL
ADPG can use the tds_fdw extension to collect data from MS SQL Server.
MySQL
MySQL
ADPG can use the mysql_fdw extension to collect data from MySQL Server.
Apache Spark
Apache Spark
Apache Spark is compatible with ADPG via JDBC and allows you to manage and analyze big data.
Apache Superset
Apache Superset
Apache Superset Business Intelligence framework is compatible with ADPG and allows you to analyze and visualize big data.
Operating systems
CentOS
CentOS 7 is supported
RedHat
RedHat 7 is supported
Alt Linux
Available only for Enterprise
Astra Linux
Available only for Enterprise
Ubuntu
Ubuntu 22.04.4 LTS is supported
Red OS
Available only for Enterprise
Features
Reliability
Highly available cluster with automatic failover
Observability
Advanced monitoring features
Performance
Read-only load balancing on the cluster nodes
Scalability
Replication allows you to scale cluster to any number of databases
Convenience
Cluster deployment, upgrading and management with ADCM
Product comparison

Compare with

Compare with

Infrastructure
Management system
Arenadata Cluster Manager (ADCM)

A single tool for managing the lifecycle of all Arenadata products.

SQL Server Management Studio (SSMS)
Oracle Enterprise Manager
MySQL Enterprise Monitor
Trusted Postgres Architect
AWS Console, AWS product management a web interface.
Azure cloud web interface
Raw ansible scripts
Percona Everest

For cloud installations only

Cluster expansion
ADCM
SSMS
Yes
MySQL InnoDB Cluster
Yes
Yes
Yes
Yes
No
Multi-cloud
ADCM
Distributed availability groups
Oracle Sharding
MySQL HeatWave
Yes
AWS cloud only
Azure cloud only
Yes
No
Cloud support
Google Cloud Platform
No
IaaS, PaaS
No
Yes
Yes

Not relevant

Not relevant

Crunchy Bridge DBaaS
Percona Operator for PostgreSQL
Yandex
IaaS only

(no official ADPG Cloud bundle)

No
No
Yes
No

Not relevant

Not relevant

No
No
VK Cloud
IaaS only

(no official ADPG Cloud bundle)

No
No
PaaS
No

Not relevant

Not relevant

No
No
Sber
IaaS only

(no official ADPG Cloud bundle)

No
No
PaaS
No

Not relevant

Not relevant

No
No
Azure
No
Yes
Yes
Paas, IaaS
Yes

Not relevant

cloud-native by design
Crunchy Bridge DBaaS
No
AWS
No
IaaS, PaaS
Yes
Paas, IaaS
Yes
cloud-native by design

Not relevant

Crunchy Bridge DBaaS
Percona Operator for PostgreSQL
Operator for K8s
No
No
oracle-database-operator
mysql-operator
CloudNativePG

Not relevant

Not relevant

Crunchy Data PostgreSQL Operator (PGO)
Percona Operator for PostgreSQL
Operating system support
CentOS
Yes
Yes
Yes
Yes
Yes

Not relevant

Not relevant

Yes
No
RedHat
Yes
Yes
Yes
Yes
Yes

Not relevant

Not relevant

Yes
Yes
Ubuntu
Yes
Yes
Yes
Yes
Yes

Not relevant

Not relevant

Yes
Yes
Debian
No
Yes
Yes
Yes
Yes

Not relevant

Not relevant

Yes
Yes
Alt Linux
Yes
No
No
Yes
No

Not relevant

Not relevant

No
No
Astra Linux
Yes
No
No
MariaDB only
No

Not relevant

Not relevant

No
No
RED OS
In development
No
No
MariaDB only
No

Not relevant

Not relevant

No
No
Features
Query monitoring
pg_stat_statements
SQL Server Management Studio (SSMS)
Oracle Enterprise Manager
MySQL Enterprise Monitor
EDB Query Advisor
Amazon CloudWatch
Query Store feature
pg_stat_statements
Percona Monitoring and Management (PMM)
HA
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Patroni
Cluster monitoring
Pgwatch2, TimescaleDB, Grafana
SQL Server Management Studio (SSMS)
Oracle Enterprise Manager
MySQL Enterprise Monitor
Via Postgres Enterprise Manager (PEM)
Amazon CloudWatch
Azure Monitor metrics explorer
pgMonitor
Percona Monitoring and Management (PMM)
Load balancing
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
HAProxy
Connection pooler
Yes
Yes
Yes
MySQL Connector/J
Yes
Yes
Yes
Yes
pgpool2, pgbouncer
Incremental/differential backups
Yes
Yes
Yes
MySQL Connector/J
Yes
Yes
Yes
Yes
pg_backrest
Sharding
No
No
Via Oracle Sharding
MySQL Connector/J
No
No
No
No
No
Integrations
ClickHouse
Yes
  • ClickHouse PostgreSQL table engine
  • PostgreSQL database engine
  • table function
clickhouse-odbc-bridge
ClickHouse JDBC Bridge
clickhouse-odbc-bridge
Yes
Yes
Yes
Yes
clickhousedb_fdw
Greenplum
Yes
  • postgres_fdw
  • PXF JDBC connector
SQL Server Integration Services
PXF JDBC connector
PXF JDBC connector
Yes
Yes
Yes
Yes
postgres_fdw
Kafka
Yes
  • Kafka Connect
  • Kafka JDBC Connector
Debezium SQL Server Source Connector
Kafka JDBC Connector
Debezium MySQL Connector
Yes
Yes
Yes
Yes
Yes
  • Kafka Connect
  • Kafka JDBC Connector
Hadoop
Yes
  • Via Spark JDBC connector
  • Hive JdbcStorageHandler
  • Flink JDBC connector
Sqoop
Oracle SQL Connector for HDFS
Sqoop
hdfs_fdw
Yes
Yes
Yes
Yes
  • Via Spark JDBC connector
  • Hive JdbcStorageHandler
  • Flink JDBC connector
JDBC (BI Tools)
ClickHouse JDBC Bridge
MSSQL JDBC Driver
Oracle JDBC Driver
MySQL JDBC Driver
PostgreSQL JDBC Driver
Amazon Web Services (AWS) JDBC Driver
PostgreSQL JDBC Driver
PostgreSQL JDBC Driver
PostgreSQL JDBC Driver
Additionally
Technical support 24/7
Yes
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Training/workshops
Yes

Full training on working with Arenadata products

Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Community version
Yes
No
No
Yes
No
No
No
No
Yes
Documentation
Yes

Detailed documentation in Russian and English languages.

Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Not available in Russian language
Registration in the register of domestic software
Yes
No
No
No
No
No
No
No
No
FSTEC certification
No
No
No
No
No
No
No
No
No
1C optimized version
No
Proven, but not available for Russia
Proven, but not available for Russia
No
No
No
No
No
No

“Product comparison” section is relevant on the date of 19.06.2024.

Releases
2023
ADPG 16.3.1
  • Upgraded the PostgreSQL version to 16.3
  • Added support for Ubuntu 22.04
  • Added the pg_walinspect extension
  • Added dynamic URLs to ADPG services
Read more
ADPG 14.3.8
  • ADPG14 cluster components were amended and upgraded to support smooth major upgrade to ADPG16
  • Added UUID to the ADPG cluster
Read more
ADPG 14.3.7
  • Added the ability to create backups using the functionality of the pgBackRest utility
Read more
ADPG 14.3.6
  • Astra Linux SE 1.7 Orel is supported in ADPG Enterprise edition
  • A connection pooler is implemented based on PgBouncer in ADPG Enterprise edition
Read more
ADPG 14.3.4
  • Cluster monitoring feature based on pgwatch2 is added
  • TimescaleDB extension for metrics storage is supported
  • Grafana dashboards with monitoring metrics are provided
Read more
ADPG 14.3.3
  • Load balancing feature is added
  • The contrib and PostGIS extensions are included in ADPG and do not require installation
Read more
ADPG 14.3.2
  • High availability (HA) feature based on Patroni is implemented
  • The Etcd service required for HA is added
  • Offline installation is supported
Read more
ADPG 14.3.1
  • ADPG migrates to PostgreSQL 14.3
  • Alt Linux 8.4 SP is supported
  • Base monitoring system is implemented
Read more
ADPG 14.2.1
  • The ADCM-integrated ADPG bundle is created based on PostgreSQL 14.2
  • The contrib and PostGIS 3.1.5 extensions are supported
Read more