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.
Hi, I have some RDS but i want to import them into terraform, so they can be easier to manage, i saw that there is an import command but I'm not sure if using this will be the best approach because if...
2
answers
0
votes
864
views
asked 8 months agolg...
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
630
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
283
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
302
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
473
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
652
views
asked 9 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
217
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
937
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
425
views
asked 9 months agolg...