Questions tagged with Aurora PostgreSQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
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...
1
answers
0
votes
882
views
asked 8 months agolg...
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...
1
answers
0
votes
365
views
asked 8 months agolg...
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...
0
answers
0
votes
104
views
asked 8 months agolg...
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
2
answers
0
votes
791
views
asked 8 months agolg...
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....
3
answers
0
votes
223
views
asked 8 months agolg...
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...
1
answers
0
votes
858
views
asked 9 months agolg...
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...
Accepted AnswerAurora PostgreSQL
1
answers
0
votes
858
views
asked 9 months agolg...
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...
1
answers
0
votes
356
views
asked 9 months agolg...
Recently had to terminate an SQL query "update cron.job_run_details" that was running indefintely on our RDS db, using SELECT pg_terminate_backend(<jobid>);
Since then, no cron jobs are running. I've...
2
answers
0
votes
747
views
asked 9 months agolg...
I'm using the new auto-rotation for RDS that doesn't require a lambda - https://docs.aws.amazon.com/secretsmanager/latest/userguide/rotate-secrets_turn-on-for-db.html
The problem I'm facing is...
1
answers
0
votes
294
views
asked 9 months agolg...
Is it possible to create a Cloudwatch chart of the number of Aurora Postgres read replica instances? I've searched the documents and list of available Cloudwatch metrics, but I can't find...
2
answers
0
votes
293
views
asked 9 months agolg...
Our timeline has shifted and I either need to cancel or postpone a major version upgrade and I can't seem to find a place in the management UI or aws cli to stop this from happening in the next...
1
answers
0
votes
395
views
asked 9 months agolg...