Integrating Amazon Aurora PostgreSQL with other Amazon services
Amazon Aurora integrates with other Amazon services so that you can extend your Aurora PostgreSQL DB cluster to use additional capabilities in the Amazon Cloud. Your Aurora PostgreSQL DB cluster can use Amazon services to do the following:
-
Quickly collect, view, and assess performance for your Aurora PostgreSQL DB instances with Amazon RDS Performance Insights. Performance Insights expands on existing Amazon RDS monitoring features to illustrate your database's performance and help you analyze any issues that affect it. With the Performance Insights dashboard, you can visualize the database load and filter the load by waits, SQL statements, hosts, or users. For more information about Performance Insights, see Monitoring DB load with Amazon CloudWatch Database Insights on Amazon Aurora.
-
Configure your Aurora PostgreSQL DB cluster to publish log data to Amazon CloudWatch Logs. CloudWatch Logs provide highly durable storage for your log records. With CloudWatch Logs, you can perform real-time analysis of the log data, and use CloudWatch to create alarms and view metrics. For more information, see Publishing Aurora PostgreSQL logs to Amazon CloudWatch Logs.
-
Import data from an Amazon S3 bucket to an Aurora PostgreSQL DB cluster, or export data from an Aurora PostgreSQL DB cluster to an Amazon S3 bucket. For more information, see Importing data from Amazon S3 into an Aurora PostgreSQL DB cluster and Exporting data from an Aurora PostgreSQL DB cluster to Amazon S3.
-
Add machine learning-based predictions to database applications using the SQL language. Aurora machine learning uses a highly optimized integration between the Aurora database and the Amazon machine learning (ML) services SageMaker AI and Amazon Comprehend. For more information, see Using Amazon Aurora machine learning with Aurora PostgreSQL.
-
Invoke Amazon Lambda functions from an Aurora PostgreSQL DB cluster. To do this, use the
aws_lambdaPostgreSQL extension provided with Aurora PostgreSQL. For more information, see Invoking an Amazon Lambda function from an Aurora PostgreSQL DB cluster . -
Integrate queries from Amazon Redshift and Aurora PostgreSQL. For more information, see Getting started with using federated queries to PostgreSQL in the Amazon Redshift Database Developer Guide.
DNS resolution conflicts with Kerberos authentication and Amazon service VPC endpoints
Connections from your DB cluster to Amazon services may fail if you enable Kerberos authentication and configure VPC endpoints for those services in your Amazon Managed Microsoft AD VPC.
When you enable Kerberos authentication, your DB cluster prioritizes Amazon Managed Microsoft AD DNS servers over the VPC DNS resolver. If endpoint records for Amazon services (such as Lambda, Amazon S3, or SageMaker AI) exist in your Amazon Managed Microsoft AD DNS, the endpoints may resolve to IP addresses in your Active Directory VPC rather than your database VPC. This configuration prevents successful connections from your DB cluster to those services.
For more information, see Using Kerberos authentication with Aurora PostgreSQL.