OCI Database with PostgreSQL Events
Oracle Cloud Infrastructure Events are JSON files that are emitted with some service operations and carry information about that operation.
You can define rules that trigger a specific action when an event occurs. For more information, see Overview of Events, Get Started with Events, and Managing Rules for Events.
OCI Database with PostgreSQL emits events during the following:
- A database is created
- A database is updated
- A database is deleted
- A database backup is created
- A database backup is deleted
Event Types for Database Systems
When you create, update, or delete a database, OCI Database with PostgreSQL emits events when the operation begins and ends. For example, you can set up the Oracle Cloud Infrastructure Events service to send you an email when a database is created.
| Friendly Name | Description | Event Type |
|---|---|---|
| Database - Create Begin |
When OCI Database with PostgreSQL starts creating a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.createdbsystem.begin |
| Database - Create End |
When OCI Database with PostgreSQL finishes creating a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.createdbsystem.end |
| Database - Update Begin |
When OCI Database with PostgreSQL starts updating a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.updatedbsystem.begin |
| Database - Update End |
When OCI Database with PostgreSQL finishes updating a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.updatedbsystem.end |
| Database - Delete Begin |
When OCI Database with PostgreSQL starts deleting a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.deletedbsystem.begin |
| Database - Delete End |
When OCI Database with PostgreSQL finishes deleting a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.deletedbsystem.end |
Here is a reference event for a create database event that completes successfully:
"exampleEvent": {
"eventType": "com.oraclecloud.postgresql.createdbsystem.begin",
"cloudEventsVersion": "0.1",
"eventTypeVersion": "2.0",
"source": "postgresql",
"eventID": "exampleunique_ID",
"eventTime": "2023-02-15T10:04:12.926Z",
"contentType": "application/json",
"extensions": {},
"data": {
"eventGroupingId": "ocid1.postgresqlworkrequest.oc1.phx.exampleunique_ID",
"eventName": "Database - Create Begin",
"compartmentId": "ocid1.compartment.oc1..exampleunique_ID",
"compartmentName": "example_compartment",
"resourceName": "example_resource",
"resourceId": "ocid1.postgresqldbsystem.oc1.phx.exampleunique_ID",
"availabilityDomain": "availability_domain",
"freeformTags": {},
"definedTags": {},
"additionalDetails": {
"X-Real-Port": "stub"
}
}Event Types for Database Backups
When you create or delete a database backup, OCI Database with PostgreSQL emits events when the operation begins and ends. For example, you can set up the Oracle Cloud Infrastructure Events service to send you an email when a backup is created.
| Friendly Name | Description | Event Type |
|---|---|---|
| Backup - Create Begin |
When OCI Database with PostgreSQL starts creating a database backup, it emits an event that has information about the backup. |
com.oraclecloud.postgresql.createbackup.begin |
| Backup - Create End |
When OCI Database with PostgreSQL finishes creating a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.createbackup.end |
| Backup - Delete Begin |
When OCI Database with PostgreSQL starts deleting a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.deletebackup.begin |
| Backup - Delete End |
When OCI Database with PostgreSQL finishes deleting a database, it emits an event that has information about the database. |
com.oraclecloud.postgresql.deletebackup.end |
Here is a reference event for a backup begin event that completes successfully:
"exampleEvent": {
"eventType": "com.oraclecloud.postgresql.createbackup.end",
"cloudEventsVersion": "0.1",
"eventTypeVersion": "2.0",
"source": "postgresql",
"eventID": "exampleunique_ID",
"eventTime": "2023-02-15T14:06:01.220Z",
"contentType": "application/json",
"data": {
"eventGroupingId": "ocid1.postgresqlworkrequest.oc1.phx.exampleunique_ID",
"eventName": "Backup - Create Begin",
"compartmentId": "ocid1.compartment.oc1..exampleunique_ID",
"compartmentName": "example_compartment",
"resourceName": "example_resource",
"resourceId": "ocid1.postgresqlbackup.oc1.phx.exampleunique_ID",
"availabilityDomain": "availability_domain",
"freeformTags": {},
"definedTags": {}
}