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 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
836
views
asked 4 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
110
views
asked 4 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
458
views
asked 4 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
439
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
513
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
437
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
126
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
317
views
asked 5 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
286
views
asked 5 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
261
views
asked 5 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
405
views
asked 5 months agolg...
I need a configuration for DMS to always replicate the entire row when a change occurs and not just the data that has changed, which config can I use? the source database is postgresql and the task is...
1
answers
0
votes
350
views
asked 5 months agolg...