---
# System prepended metadata

title: ADPG
tags: [' AD Postgres', ADPG]

---

---
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** |
