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.
say i have couple of json files in s3, I would to set up a crawler or a glue job, such that i can create table in aws rds (mysql or postgre) , such that in table 1, it creates a autogenerated id and...
1
answers
0
votes
194
views
asked 3 days agolg...
Since 11 has reached EOL, our company is planing to **Migrate from 11.17 to 16.2**.
It will be helpful if anyone could suggest us any step by step safer & standard approach to do the...
1
answers
0
votes
190
views
asked 5 days agolg...
Hi!
We've been trying to set up a pub/sub on RDS postgresql and it is failing with an error we were not able to understand.
Publisher is a Aurora postgresql 16.1 database, subscriber is also a...
1
answers
0
votes
355
views
asked 10 days agolg...
Hi Team,
IHAC who is trying to restore dump from PostgreSQL 15.6 to RDS Aurora serverless same version.
Restore fails after few hours with below error :-
“pg_restore: warning: errors ignored on...
Accepted AnswerAurora PostgreSQL
1
answers
0
votes
194
views
asked 10 days agolg...
We have Aurora Globale Cluster with Postgresql. The configurationn is as follows:
* A writer in us-east-1
* A read replica in eu-central-1
Now assume that the writer in us-east-1 crashes and I can...
1
answers
0
votes
379
views
asked 11 days agolg...
a company's SQL developer has left and I've been asked to build a series of queries for their postgres DB on an Aurora Postgres server in the interim. I can log into the RDS interface, but the query...
Accepted AnswerAurora PostgreSQL
2
answers
0
votes
198
views
asked 12 days agolg...
Hi,
I am trying to get oracle_fdw working for PostgreSQL-Aurora to access an on-prem OracleDB following this...
4
answers
0
votes
242
views
asked 15 days agolg...
I have a writer instance of a global Aurora Cluster in us-east-1 (N. Virginia) and want to replicate it to a read replica in eu-west-2 (London).
When I measure AuroraReplicaLag, it is in the range of...
1
answers
0
votes
270
views
asked 17 days agolg...
I've attempted to connect multiple ways through multiple tools. According to the [AWS Aurora documentation](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/database-authentication.html),...
1
answers
0
votes
316
views
asked 18 days agolg...
I'm working on a feature to archive old data from our Aurora Postgres database to S3 using the `aws_s3` extension. This operation takes 20-30 minutes, and sometimes my client gets disconnected and...
Accepted AnswerAurora PostgreSQL
1
answers
0
votes
211
views
asked 18 days agolg...
What are the performance considerations while using the Redshift Federated Queries to access and query data present in Amazon Aurora RDS PostgreSQL database? The Redshift Zero ETL feature is still in...
1
answers
0
votes
314
views
asked 19 days agolg...
I would like to query my Amazon Aurora Serverless v2 for Postgresql by sensible metrics and alarms.
I found several alarms...
1
answers
0
votes
349
views
asked 20 days agolg...