All Content tagged with Aurora PostgreSQL

The PostgreSQL-compatible edition of Aurora delivers up to 3X the throughput of standard PostgreSQL running on the same hardware, enabling existing PostgreSQL applications and tools to run without requiring modification.

Content language: English

Select up to 5 tags to filter
Sort by most recent
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
872
views
asked 4 months ago
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
1008
views
asked 4 months ago
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
869
views
asked 4 months ago
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
2659
views
asked 4 months ago
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
784
views
asked 4 months ago
Hi, I am trying to get oracle_fdw working for PostgreSQL-Aurora to access an on-prem OracleDB following this...
4
answers
0
votes
873
views
Ed
asked 4 months ago
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
867
views
asked 4 months ago
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
1043
views
asked 4 months ago
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
761
views
asked 4 months ago
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
893
views
MK
asked 4 months ago
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
633
views
asked 4 months ago
Hello AWS Community, I'm seeking advice regarding a persistent error we're facing with our Aurora PostgreSQL Serverless V2 setup running PostgreSQL 15.5. We are periodically receiving an error...
0
answers
1
votes
171
views
asked 4 months ago