--- title: ADPG tags: ADPG, AD Postgres description: ADPG. Current Status --- # ADPG Roadmap Here is the preliminary [roadmap](https://xmind.works/#/e0d602) for the first four releases. ![](https://i.imgur.com/7b6Ilo4.png) --- # Release ADPG_v14.1_arenadata1 Here is the [mindmap](https://xmind.works/#/731523) of bundle tasks of the first release of ADPG ![](https://i.imgur.com/6ameuaC.png) Here is the [detailed list of tasks](https://docs.google.com/spreadsheets/d/1IPHFTvi6t3bLoTRu1GjbKU4YtAcUOn3FmOGcviexuZI/edit#gid=0) of the **ADPG_v14.1_arenadata1** release: | Stage | Task | Description | Task dependancy | Bundle score (m/d) | QA score (m/d) | | ----- | ----- | ----------- | --------------- | ------------------- | --------------- | | Preparing | | | | **10** | **3** | | | Prepare bundle template | Configuration, playbooks and roles, autobump, repo manager, repositories | T0 | 3 | 0 | | | Preparing of Operation System | Firewall, SELinux, sysctl (based on documentation) | T0 | 2 | 0 | | | Preparing of repositories | centos7/rhel7, altinux 8.3 (x86_64) | T0 | 5 | 3 | | ADPG Service (stage 1) | | | | **14** | **8** | | | config.yaml parameters | sysctl, user params, database path\name | T0 | 2 | 0 | | | Precheck | Packages, SELinux, firewall, access rights, already installed PostgreSQL, network address and port | T0 | 5 | 2 | | | Install/Reinstall | Create user, install packages, initdb, systemd configuration | T0 | 5 | 3 | | | Check service | Check action | T0 | 1 | 1 | | | Start\Stop actions | | T0 | 1 | 2 | | ADPG service (stage 2) | | | | **8** | **6** | | | Install/uninstall contrib | centos7/rhel7, altinux 8.3 (x86_64) | T1 | 2 | 2 | | | Install/uninstall PostGIS | centos7/rhel7, altinux 8.3 (x86_64) | T1 | 2 | 2 | | | Run SQL | Use default database, user can set database name | T2 | 1 | 1 | | | Append pg_hba.conf entry | | T3 | 3 | 1 | | ADPG service (stage 3) | | | | **9** | **5** | | | postgresql.conf parameters | resource and logging | T4 | 3 | 0 | | | Reconfigure restart | | T4 | 1 | 1 | | | Minor upgrade | | T5 | 3 | 2 | | | Major upgrade | stub | T5 | 2 | 2 | | Chrony | | | | **5** | **2** | | | Install/Uninstall actions | Move to submodule from ADB, reconfigure restart, NTP servers configuration | T6 | 5 | 2 | | **Total score** | | | | **46** | **24** | The release deadline is **the 1th of May 2022**. --- # Plans - Update roadmap with the highest priority goals. - Start research of: - Clustering with bundles - PostgreSQL upgrade - Monitoring - ADCC integration --- # Current status | Scope | Tasks | Details | Status | | ----- | ----- | ------- | ------ | | Setup [Jira dashboards](https://arenadata.atlassian.net/jira/software/c/projects/ADPG/boards/150) | | | **Done** | | ADPG_v14.1_arenadata1 release | | | | | | [Architecture documentation](https://arenadata.atlassian.net/wiki/spaces/ADPG/pages/890274030/Arenadata+Postgres+ADPG+v14.1+arenadata1+Configuration) | | **Done** | | | Prepare tasks with scores | | **Done** | | | Russian Software Registry certification | | **In Progress** | | | Packages | PostgreSQL 14.1 (centos7/rhel7, alt linux 8.3, x86_64) | **Done** | | | | PostgreSQL 14.1 Contrib (centos7/rhel7, alt linux 8.3, x86_64) | **Done** | | | | PostGIS 4.1.3 (centos7/rhel7, alt linux 8.3, x86_64) | **In Progress** | | Bundle works | | **Started** | | | Documentation | | **In Planning** | | Future releases | | | | | | ADPG clustering research | | **Started** |