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 have an r6g.large write instance in our cluster which is perfectly enough for us during off-peak hours which is about 16 hours a day on workdays.
But during the 8 peak hours we would need a larger...
1
answers
1
votes
308
views
asked 8 months agolg...
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
628
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
282
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
301
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
468
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
649
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
298
views
asked 9 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
260
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
216
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
936
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
424
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
111
views
asked 9 months agolg...