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 tags to filter
Sort by most recent

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

378 results
Hi, For some reason, we have an Aurora PostgreSQL where the Writer and the Reader has Region & AZ showing both at ap-southeast-2b, Multi-AZ is No. Not sure how this has happened. Is this an issue? ...
1
answers
0
votes
10
views
asked a day ago
Hello, we have an **Amazon RDS Aurora PostgreSQL 14.9 cluster** with two instances (db.r6g.large) that was created in April 2023. We are currently using the **pgvector extension (version 0.5.0)** for...
2
answers
0
votes
28
views
asked 8 days ago
Hi, Reading on [https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.MajorVersion.html]() It mentions the following: ``` Before upgrading your production A...
1
answers
0
votes
21
views
asked 10 days ago
Hi, We are planning on upgrading from PostgreSQL 12 to 16 to avoid the cost of Extended Support. Currently reading on the following [https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USE...
1
answers
0
votes
40
views
asked 11 days ago
We have an AWS RDS instance running on PostgreSQL version 13.15. This has a read-replica as well as an Aurora cluster attached to it. If we test Blue/Green deployment on this, the primary server as we...
1
answers
0
votes
53
views
asked 14 days ago
Hi, I am trying to work out what are the supposedly 'default' settings of parameters from the AWS console. I can see the Source column showing Engine default, System default, Modified. I guess Modifi...
1
answers
0
votes
19
views
asked 15 days ago
We have an RDS instance (Postgres) that we need to run the below command, but receive an error ``` ALTER USER <user_name> REPLICATION; ``` ``` SQL Error [42501]: ERROR: must be superuser to alter repl...
3
answers
0
votes
45
views
asked 15 days ago
Hi, We are planning on upgrading from Aurora PostgreSQL 12 to 16. We are concern about parameter group settings and will want to do a comparison of some sort. There is an option to compare custom Par...
1
answers
0
votes
26
views
asked 15 days ago
I am writing to seek clarification on the maximum supported PostgreSQL version for upgrades from version 12.16. I have reviewed the two relevant AWS documentation pages: "Upgrading the PostgreSQL Dat...
2
answers
0
votes
34
views
asked 17 days ago
I would like to inquire about the correct end of support date for PostgreSQL 15. According to the information provided in the link and the attached images, there seems to be a discrepancy between the ...
2
answers
0
votes
63
views
asked 17 days ago
I have a bedrock knowledge base that use aurora as a vector database, using plain text files as source in s3. As i read here [amazon-bedrock-knowledge-bases-now-supports-metadata-filtering-to-improve...
2
answers
0
votes
95
views
asked a month ago
As of Jan 2025, confirming that `ServerlessCluster` is NOT what you use for "Aurora-V2-Serverless" (in my case Postgres). You must use `DatabaseCluster` (FYI only, `DBCluster` if written in CloudForma...
2
answers
0
votes
223
views
asked a month ago