Updated on 2022-08-12 GMT+08:00

Overview

PoWA is an open-source system used to monitor the performance of RDS for PostgreSQL databases. It consists of the PoWA-archivist, PoWA-collector, and PoWA-web components and obtains performance data through other plug-ins installed in the RDS for PostgreSQL databases. The key components are as follows:

  • PoWA-archivist: the PostgreSQL plug-in for collecting performance data obtained by other plug-ins.
  • PoWA-collector: the daemon that gathers performance metrics from remote PostgreSQL instances on a dedicated repository server.
  • PoWA-web: the web-based user interface displaying performance metrics collected by the PoWA-collector.
  • Other plug-ins: the sources of performance metric data. They are installed on the destination PostgreSQL database.
  • PoWA: the system name.

Security Risk Warning

The following security risks may exist during PoWA deployment and configuration.

  • (Remote mode) When configuring instance performance metric information to be collected in powa-repository, you need to enter the IP address, root username, and connection password of the destination instance. You can query related information in the powa_servers table. The connection password is displayed in plaintext.
  • In the PoWA-collector configuration file, the powa-repository connection information does not contain the connection password. It means that the powa-repository connection configuration item for PoWA-collector must be trust.
  • In the PoWA-web configuration file, the root user and connection password of powa-repository (remote mode) or DB instance (local mode) are optional and stored in plaintext.

Before using the PoWA, you need to be aware of the preceding security risks. For details about how to harden security, see PoWA official document.