Minimum Requirements
The minimum requirements for installing PostgreSYS components may vary depending on the desired workload or the technical and organizational needs of each environment and project.
However, to meet the minimum requirements of production environments, we suggest:
| Service | Component | CPU | RAM | Disk | Remarks |
|---|---|---|---|---|---|
| Orquestration | PgSmart CLI | 1 GHZ Dual Core | 512 MB | 100 MB | |
| PgSmart Web | 2 GHZ Dual Core | 2 GB | 1 GB | ||
| PgSmart Agent | 1 GHZ Dual Core | 512 MB | 100 MB | ||
| Database | PostgreSQL | 1 GHZ Dual Core | 4 GB [^1] | 2 GB | Recommended CPU with 4 or more cores.. |
| PostGIS | 1 GHZ Dual Core | 1 GB [^6] | 100 MB | ||
| Pool de Conexões | PgBouncer | 1 GHZ Dual Core | 1 GB [^2] | 100 MB | |
| Backups Management | pgBackRest | 1 GHZ Dual Core | 512 MB | 100 MB | Consider resizing computational resources when using WAL-E and WAL-G.. |
| High Availability | Patroni [^3] | 1 GHZ Dual Core | 2 GB | 100 MB | |
| etcd | 2 GHZ Dual Core | 2 GB [^4] | 100 MB | SSD disks are recommended. | |
| HAProxy | 1GHZ Dual Core | 1 GB [^5] | 100 MB | ||
| Observability | Prometheus | 1 GHZ Dual Core | 4 GB | - | SSD disks are recommended. |
| Prometheus Exporter | 1 GHz Dual Core | 512 MB | - | ||
| Grafana | 2 GHZ Dual Core | 2 GB | 1 GB | For installation and logs. | |
| Alertmanager | 1 GHZ Dual Core | 2 GB | - | ||
| Karma | 1 GHz Dual Core | 1 GB | - |
Up to 5 GB of free disk space is required to download the installation packages. If needed, request support at the Área de Suporte.:::
Recommendations
Although the distribution of services changes according to available resources, the desired level of isolation and availability, and the performance requirements of each environment, here are some recommendations that can be observed as general guidelines.
| Service | Component | Recomendations |
|---|---|---|
| Database | PostgreSQL | Whenever possible, use a dedicated host for this component. |
| Backup | pgBackRest | Whenever possible, use a dedicated host for this component. If this component is installed on the same host as the database service component, it is recommended to use separate disks for backup. |
| Alta Disponibilidade (HA) | Patroni | It must be installed on the host(s) of the database instance(s).. |
| Alta Disponibilidade (HA) | etcd | In production, it must be installed on at least 3 distinct and, if possible, dedicated hosts. Additionally, an odd number of members in the etcd cluster is recommended. Since this component uses the Raft consensus algorithm, which relies on a majority of votes (quorum) to elect a leader and apply changes to the cluster, having an odd number maximizes fault tolerance with the fewest possible nodes. |
| Alta Disponibilidade (HA) | HAProxy | It is recommended that this component be installed on a dedicated proxy server (virtual IP). |
| Pool de Conexões | pgBouncer | Whenever possible, use a dedicated host for this component. |
| Observabilidade | Prometheus | Whenever possible, use a dedicated host for this component. |
| Observabilidade | Grafana | Whenever possible, use a dedicated host for this component. Otherwise, preferably place it on the same server as Prometheus. |
| Observabilidade | Alertmanager | Whenever possible, use a dedicated host for this component. Otherwise, preferably place it on the same server as Prometheus. |
| Observabilidade | Karma | Whenever possible, use a dedicated host for this component. Otherwise, preferably place it on the same server as Prometheus. |
We emphasize that each environment is unique and should be assessed individually for proper configuration.
Supported Operating Systems
PostgreSYS is available for the following operating systems:
| PostgreSYS | Operating System | Version | Architecture. |
|---|---|---|---|
| 4.0.0 | CentOS | 8.x | x86-64 |
| 4.0.0 | Red Hat Enterprise Linux | 8.x | x86-64 |
| 4.0.0 | Red Hat Enterprise Linux | 9.x | x86-64 |
| 4.0.0 | Oracle Linux | 8.x | x86-64 |
| 4.0.0 | Oracle Linux | 9.x | x86-64 |
| 4.0.0 | Rocky Linux | 8.x | x86-64 |
| 4.0.0 | Rocky Linux | 9.x | x86-64 |
| 4.0.0 | AlmaLinux | 8.x | x86-64 |
| 4.0.0 | AlmaLinux | 9.x | x86-64 |
| 4.0.0 | SUSE/OpenSUSE | 15.6 ou superior | x86-64 |
New Linux distributions will be supported soon.