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.
We configured an Aurora Serverless V2 PostgreSQL in our cluster but unfortunately it doesn't scale down to 0.5 ACU. Our database size is around 700-800 gb. Database version: Aurora PostgreSQL 13.11...
1
answers
0
votes
616
views
asked 8 months agolg...
I am trying to download log file of writer instance using aws cli. So for that I am using 'download-db-log-file-portion' command like this:
aws rds download-db-log-file-portion...
1
answers
0
votes
279
views
asked 8 months agolg...
Hi all,
This is something that was working months ago, but suddenly is not working anymore. When invoking a Lambda from the database either using
SELECT * FROM aws_lambda.invoke(<function_arn>,...
1
answers
0
votes
297
views
asked 8 months agolg...
Is it currently possible to use Zero-ETL Integrations between Aurora PostgreSQL and Redshift. These Database Instances are in 2 different AWS Account.
If this is not possible, how do I replicate the...
1
answers
0
votes
454
views
asked 8 months agolg...
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...
1
answers
0
votes
632
views
asked 8 months agolg...
How to switch an Aurora Postgres cluster and all databases therein from UTC to a different timezonelg...
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...
Accepted AnswerAurora PostgreSQL
2
answers
0
votes
295
views
asked 8 months agolg...
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...
2
answers
0
votes
257
views
asked 9 months agolg...
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:...
0
answers
0
votes
215
views
asked 9 months agolg...
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
928
views
asked 9 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
420
views
asked 9 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
109
views
asked 9 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
897
views
asked 9 months agolg...