Questions tagged with 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.
I'm encountering difficulties while trying to upgrade my Amazon Aurora PostgreSQL database from version 13 to version 15 using the pg_upgrade utility. The upgrade process is failing with an error, and...
2
answers
2
votes
420
views
asked 5 months agolg...
I am writing to address a critical issue regarding our Production RDS database instance ([db.m5.xlarge, Postgres]).
Unexpected Upgrade:
We were recently shocked to discover that Postgres has...
1
answers
0
votes
895
views
asked 5 months agolg...
The situation is I have a RDS cluster running with RDS instance in it. Sometimes when we update the stack for RDS cluster it deletes the physical resource and re creates it. But as the RDS instance is...
0
answers
0
votes
115
views
asked 5 months agolg...
My RDS(Aurora PostgreSQL) serverless reader instance database capacity count spikes every hour.lg...
I have Aurora PostgreSQL reader and writer instance connected to node js application which uses TypeORM for db connectivity.
A few days ago, my serverless reader instance started spiking every...
2
answers
0
votes
489
views
asked 5 months agolg...
I'm using a Serverless migration (`Full load and change data capture`) to move from Oracle on-prem to Aurora Postgres. After a bunch of tuning, I've got it close to ready. However, I noticed that...
2
answers
0
votes
514
views
asked 5 months agolg...
We are currently running Postgres 11.20 on db.t2.medium which only supports Lower than PostgreSQL 13
To upgrade to PostgresSQL 13.9, we have to upgrade the DB instance
From the AWS console, we could...
1
answers
0
votes
533
views
asked 5 months agolg...
I have a number of users connecting to a database, some IaM enabled and others which use password authentication. **Generally** connection and authentication is fine for both types of users and our...
1
answers
0
votes
507
views
asked 5 months agolg...
Hello,
On my DEV env, the type public.geometry is missing, the postgis extension is already exists and in use by other schema (i can't drop and create because of that), and if i am trying to create...
0
answers
0
votes
132
views
asked 5 months agolg...
Hi everyone,
I upgraded all of my PostgreSQL 11 instances to 15+ earlier this month, but I am still getting AWS emails that begin with "You are receiving this message because you have one or more...
1
answers
1
votes
329
views
asked 6 months agolg...
I have some database on my RDS but suddently when i want to check the database was gone meanwhile i have the record, how it can be happend? is the anyone outside can help me how to recovery the...
2
answers
0
votes
302
views
asked 6 months agolg...
Hello everyone,
I'm currently utilizing the `pgvector` extension for storing vector embeddings in a PostgreSQL database. Additionally, I've implemented the `hnsw` indexing algorithm for indexing...
1
answers
0
votes
288
views
asked 6 months agolg...
Hello,
I'm currently developing a Proof of Concept utilizing Amazon Q chatbot and the RDS PostgreSQL connector. My data source is successfully set up, and I'm able to connect to my RDS instance and...
1
answers
0
votes
455
views
asked 6 months agolg...