Questions tagged with Aurora PostgreSQL

Following [this guide from AWS about Enabling cross-Region automated backups](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReplicateBackups.html#AutomatedBackups.Replicating.Enable), I...

I am trying to switch an existing cluster from UTC to timezone "America/Los_Angeles" for a legacy service that requires this tz. - I tried setting the timezone parameter in a custom parameter group...

Hi. Given an application that used to run multiple DB scripts against SQL Server in a single transaction, how can I implement the same when moving the Aurora Postgres? The challenge is as...

Hi All, I hope everyone is doing well! I am attempting to create a federated query between Redshift and Aurora Postgres 14. I am following the instructions on this page:...

I downloaded the latest global-bundle.pem as directed, and set my env vars: PGSSLROOTCERT=/.../global-bundle.pem PGSSLMODE=require psql -h [myDatabaseName].us-east-1.rds.amazonaws.com -d postgres...

I have Java 11 Lambda's connecting to Aurora PostgreSQL which were broken when I updated my Aurora instance from rds-ca-2019 as recommended by the console. The connections failed with a SSL_handshake...

From reading this article https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html#rds-proxy-pinning, it seems like it does. But from reading this Reddit comment...

Looking for a solution to create an alert for blocking locks in Aurora Postgres or RDS postgres. Has anyone done this and how did you accomplish this? Thanks! Jeremy

We have RDS postgres database in both Prod and dev environments. We would like to rotate the pem file of underlying EC2 machine but we want to make sure this will not cause downtime to our database....

Hello, When trying to create a function using C language an error is raised: > *ERROR: permission denied for language c.* I'm using RDS Aurora PostgreSQL 12 and my user has the rds_superuser...

I need to import a CSV file from s3 bucket into my Aurora database table. However some fields could contain double quote character which will break the process. ``` 32533|Lease changed from "12...

Update: Turns out it is the call to SSM (Parameter Store) to get DB info that is timing out, so this is not actually related to Aurora Serverless. Our staging environment is setup to scale down to 0...