AWS RDS PostgreSQL

Use the script package series of "Guance Cloud Sync" in the script market to synchronize cloud monitoring and cloud asset data to Guance

Configuration¶

Install Func¶

It is recommended to activate Guance Integration - Extension - Hosted Func: all prerequisites are automatically installed. Please proceed with the script installation.

If you deploy Func on your own, refer to Self-deploy Func

Install Script¶

Note: Please prepare the required Amazon AK in advance (for simplicity, you can directly grant global read-only permission ReadOnlyAccess).

Hosted Edition Script Activation¶

1. Log in to Guance Console
2. Click the 【Integration】 menu and select 【Cloud Account Management】
3. Click 【Add Cloud Account】, choose 【AWS】, and fill in the information required on the interface. If you have configured cloud account information before, skip this step.
4. Click 【Test】. After a successful test, click 【Save】. If the test fails, check whether the related configuration information is correct and retest.
5. In the 【Cloud Account Management】 list, you can see the added cloud account. Click the corresponding cloud account to enter the details page.
6. On the cloud account detail page, click the 【Integration】 button. Under the Not Installed list, find AWS RDS PostgreSQL, click the 【Install】 button, and install it via the pop-up installation interface.

Manual Script Activation¶

1. Log in to the Func Console, click 【Script Market】, enter the official script market, and search for guance_aws_rds_postgresql
2. After clicking 【Install】, input the corresponding parameters: AWS AK ID, AK Secret, and account name.
3. Click 【Deploy Startup Script】, and the system will automatically create a Startup script set and configure the corresponding startup script.
4. After enabling, you can see the corresponding automatic trigger configuration in the 「Management / Automatic Trigger Configuration」. Click 【Execute】 to immediately run once without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs.

Verification¶

1. Confirm in 「Management / Automatic Trigger Configuration」 whether the corresponding task has an automatic trigger configuration, and at the same time, you can view the corresponding task records and logs to check for any anomalies.
2. In Guance, under 「Infrastructure - Resource Catalog」, check if there is any asset information.
3. In Guance, under 「Metrics」, check if there is any corresponding monitoring data.

Metrics¶

Configure Amazon - CloudWatch by configuring more metrics Amazon CloudWatch Metric Details

Amazon RDS Amazon CloudWatch Metrics¶

The AWS/RDS namespace in Amazon CloudWatch includes the following instance-level metrics.

Note: The Amazon RDS console may display metrics in units different from those sent to Amazon CloudWatch. For example, the Amazon RDS console might display a metric in megabytes (MB), while sending that metric to Amazon CloudWatch in bytes.

Objects¶

Data structure of collected AWS RDS PostgreSQL objects, which can be viewed in the 「Infrastructure - Resource Catalog」.

{
  "measurement": "aws_rds",
  "tags": {
    "name"                     : "xxxxx",
    "RegionId"                 : "cn-northwest-1",
    "Engine"                   : "postgres",
    "DBInstanceClass"          : "db.t3.medium",
    "DBInstanceIdentifier"     : "xxxxxx",
    "AvailabilityZone"         : "cn-northwest-1c",
    "SecondaryAvailabilityZone": "ap-southeast-1c"
  },
  "fields": {
    "InstanceCreateTime"  : "2025-05-19T19:54:07.871Z",
    "LatestRestorableTime": "2025-05-19T19:54:07.871Z",
    "Endpoint"            : "{connection address JSON data}",
    "AllocatedStorage"    : 100,
    "message"             : "{instance JSON data}",
  }
}

Note: Fields in tags and fields may change with subsequent updates.

Tip 1: The value of tags.name is the instance ID, used as a unique identifier.

Tip 2: Both fields.message and fields.Endpoint are serialized JSON strings.