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 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
488
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...
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
325
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
296
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
280
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
439
views
asked 6 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
368
views
asked 6 months agolg...
Tokenization in Postgres SQl RDS , So that sensitive information store in encrypted format. If any body want to access the information must provide the token
1
answers
0
votes
223
views
asked 6 months agolg...
Hello,
Not sure if this is the correct place to file this issue but we are seeing a ~20% increase in the storage size of our jsonb data since upgrading from Postgres 14.8 to 15.5.
We have tested...
Accepted AnswerPostgreSQL
1
answers
0
votes
342
views
asked 6 months agolg...
I have an Ubuntu EC2 server running in us-east-2 in one of my aws accounts, and I need to connect the EC2 to Postgress database in us-east-1 in another aws account that I manage.
Note:
1. The Postgres...
1
answers
0
votes
361
views
asked 6 months agolg...
Any thoughts on when DMS will support PostgreSQL 16 as source?
2
answers
4
votes
1146
views
asked 6 months agolg...
Hello,
as AWS has prevented migrating back to RDS using snapshot, I have tried using logical replication as a backup solution. But it seems that even logical replication won't work.
If I create...
1
answers
0
votes
277
views
asked 6 months agolg...