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.
How can I manage large datasheets in PostgreSQL with pgvector using RAG approach with AWS Bedrock?lg...
Hi Guys!
I was doing some tests and I loaded a very long excel file into my pgvector postgresql database. Then I did a query to get the embeddings by the user id, and got the response, but when...
1
answers
0
votes
893
views
asked 5 months agolg...
I have a postgres RDS instance with db engine version 12.17, RDS instance db.m5.2xlarge. It is having temp file of 12TB, so I was modifying the DB instance parameter group, temp_file option. But when...
1
answers
1
votes
708
views
asked 5 months agolg...
We have a very large database that has been cleaned up and the size reduced from 35Tb to ~7Tb and have attempted to initiate a DMS as no other options are able to maintain up time adequately. We have...
1
answers
0
votes
237
views
asked 5 months agolg...
I'm trying to use an Aurora Postgres blue/green deployment to modify a partitioned table without downtime. My goal is to split a large partition into several smaller partitions by running the...
1
answers
0
votes
195
views
asked 5 months agolg...
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
415
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
861
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
114
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
471
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
464
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
525
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
473
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
131
views
asked 5 months agolg...