Create PostgreSQL Account Alert Rules
PostgreSQL alert rules can be setup at an account-level for all of your PostgreSQL deployments. Easily create new rules with a few simple clicks on your metrics and customize your thresholds.
ScaleGrid's alerts and rules allow you to stay on top of your PostgreSQL cloud deployment activity. Every database type has a different set of alert rules that can be configured for your database application monitoring needs. You can get alerts sent directly to you via SMS text, email, PagerDuty, Opsgenie or Slack notifications.
Overriding Global Alert Rules
Account-Level Alert Rules will override any Global Alert Rule created on the same metric.
Account Level Rules
The PostgreSQL account-level rules are enforced by you and apply to all PostgreSQL cluster deployments in your ScaleGrid account based on database type. You can configure account level rules under:
Settings > Global Rules > Alert Rules
PostgreSQL Metrics for Alerts
Check out our PostgreSQL Alerts & Rules page to see the full list of metrics you can setup your custom notifications on.
To learn how to setup alerts for a specific PostgreSQL deployment, check out our Create PostgreSQL Cluster Alert Rules doc.
Create PostgreSQL Account-Level Alert Rules
These rules apply to all PostgreSQL clusters of a database type in your ScaleGrid account. Here are the steps to create an account-level PostgreSQL Alert Rule:
- Log into the ScaleGrid console.
- Select 'Settings' in the left-side menu.
- Click on the 'Rules' tab to the left, then 'Alert Rules' in the top menu.
- Click the green 'Create Rule' dropdown button, and select 'New PostgreSQL Rule'
![ScaleGrid-PostgreSQL-Hosting-Alerts-and-Rules-Account-Level.png 2329](https://files.readme.io/c834ee4-ScaleGrid-PostgreSQL-Hosting-Alerts-and-Rules-Account-Level.png)
Create PostgreSQL Cluster Account-Level Alert Rules
The procedure for creating an account-level alert rule is the same as of the cluster level. The only difference is that cluster-level rules are applied at the cluster level, but the account-level rules are applied to all clusters across a specific database.
- Once the account-level PostgreSQL new alert rule wizard opens, you can select the alert type: Metric, Disk Free (%), or Server Role Change, and configure the parameters for the alert.
![MySQL-Console-Configure-New-Alert-Rule-by-Metric-ScaleGrid.png 592](https://files.readme.io/10ab5a4-MySQL-Console-Configure-New-Alert-Rule-by-Metric-ScaleGrid.png)
Create PostgreSQL Account-Level Alert Rules for Metrics
![MySQL-Console-Configure-New-Alert-Rule-by-Disk-Free-Percentage-ScaleGrid.png 592](https://files.readme.io/331a711-MySQL-Console-Configure-New-Alert-Rule-by-Disk-Free-Percentage-ScaleGrid.png)
Create PostgreSQL Account-Level Alert Rules for Disk Free %
Disk Free alerts are set at 20% by default.
![MySQL-Console-Configure-New-Alert-Rule-by-Server-Role-Change-ScaleGrid.png 590](https://files.readme.io/eefb24e-MySQL-Console-Configure-New-Alert-Rule-by-Server-Role-Change-ScaleGrid.png)
Create PostgreSQL Account-Level Alert Rules for Server Role Change
A Server Role Change is triggered when a new master is elected.
Once you've configured the PostgreSQL account-level alert rule type, you can select how you would like to be notified of the alert. ScaleGrid supports email (by default), SMS text, PagerDuty, Opsgenie and Slack.
![MySQL-Console-Configure-New-Alert-Rule-Notifications-ScaleGrid.png 590](https://files.readme.io/435b324-MySQL-Console-Configure-New-Alert-Rule-Notifications-ScaleGrid.png)
Create PostgreSQL Account-Level Alert Rules - Select Notification Type
PagerDuty and Mobile SMS Notifications
For PageDuty and SMS text notifications to work for your PostgreSQL alert rules, you need to add a PageDuty key and a phone number in your Settings. You can add a key by visiting: Settings > Notifications > PagerDuty or Phone Numbers.
Once the alert rules have been created, click the Save button and you're done! Give it a minute or two before the alerts show up in the Cluster Details page.
Editing Alert Rules
At this point, you can edit the rule you created and change the threshold and notification parameters. The alert type, however, cannot be edited. If you would like to edit the alert type, you need to delete the rule and start over.
Deleting Alert Rules
Please note that alert rules can only be deleted if there are no alerts of it's type. For example, if you have a Disk Space (%) alert and you try to delete the Disk Space (%) rule, it won't be deleted.
Updated over 1 year ago