Oracle Cloud Infrastructure Documentation

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
Database System Event Example

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
Database Backup Event Example

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": {}
    }