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.
Hello team,
Is there any way to connect stored procedure with AWS Quicksight via custom sql route?
1
answers
0
votes
290
views
asked 8 months agolg...
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
870
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
311
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
635
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
286
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
303
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
478
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
663
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
301
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
263
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
218
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
948
views
asked 9 months agolg...