Questions 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

Browse through the questions and answers listed below or filter and sort to narrow down your results.

342 results
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
2675
views
asked 5 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
800
views
asked 5 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
897
views
Ed
asked 5 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
883
views
asked 5 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
1116
views
asked 5 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
773
views
asked 5 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
923
views
MK
asked 5 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
711
views
asked 5 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
173
views
asked 5 months ago
I have an RDS db.t4g.micro RDS Postgres instance that has been running without issue for several months now. Since launch, the Credit Balance accrued to 288 within a day or so, and has maintained this...
1
answers
0
votes
436
views
bryanus
asked 5 months ago
Hi, I can no longer connect to my postgres instance using my super user account, i receive the followig error: "pg_hba.conf rejects connection for host "redacted", user "admin", database "postgres",...
1
answers
0
votes
266
views
Jodie
asked 5 months ago
We have separate maintenance window options for our Aurora RDS Cluster as well as all the cluster instances, what is the difference between them? Do we have the option to enable and disable them...
1
answers
0
votes
305
views
asked 6 months ago