Google Cloud AlloyDB for PostgreSQL

AlloyDB for PostgreSQL is a fully managed, PostgreSQL-compatible database service that's designed for your most demanding workloads, including hybrid transactional and analytical processing. For more details, refer to the GCP documentation

Log types

• Platform Logs
• Audit Logs

Setup

You can collect the logs for Sumo Logic's Google Cloud AlloyDB for PostgreSQL integration by following the below steps.

Configure logs collection

• Collect Audit Logs using the Google Cloud Platform source. These Audit Logs can be accessed based on the permissions and roles. To enable logging for Google AlloyDB, refer to Google documentation. For more detail on AlloyDB operations being audited, refer to audited operations. While creating the sync in GCP, as part of the Choose logs to include in sink section, you can use the following query:

  (resource.type=audited_resource resource.labels.service=alloydb.googleapis.com)

• Collect Platform Logs using the Google Cloud Platform source. AlloyDB platform logs include logs related to pgAudit and instance log which includes - PostgreSQL database logs, container logs for dataplane agents, and internal dogfish logs. To enabled pgAudit logs, refer to the GCP documentation. While creating the sync in GCP, as part of the Choose logs to include in sink section, you can use the below query:

  (resource.type=alloydb.googleapis.com/Instance)