Questions tagged with PostgreSQL

Hello everyone. I have varchar type (without specified length) in Postgres DB and according to...

I have two PostgreSQL RDS databases in different regions and would like database A (us-south-1) to be able to query database B (us-west-1) using PostgreSQL's...

**Context**: I'm running into this problem on PostgreSQL running on both Aurora Serverless V2 and PostgreSQL running on RDS. The PostgreSQL database running on RDS is a `db.t4g.xlarge`. I am using IAM...

Hello, We are using aws dms to copy the rds postgres data to our datawarehouse redshift. The issue we are facing was , in one of the tables we have jsonb as datatype in our source postgres , when...

Hi there! Does anyone understand what exactly this CreateDBInstance:0014 means? Why do I have two db.t3.small databases on one account and this operation takes $3 per day there, and on another account...

I was notified of the requirement to update my RDS certificates by August 22, 2024. Checking my RDS instance, I note that it has expired in the past. I receive an info message "Your database has...

Dear Team, I am writing to seek assistance regarding an issue I am encountering with an AWS DMS task configured for full load plus Change Data Capture (CDC). Currently, I am using AWS DMS to migrate...

In AWS Aurora im being chagred for I/O requests ($0.20 per 1 million I/O requests) From cloudwatch metrices how can i get the exact count of IO which is represented in billing Which metrices and...

Hi, I have attempted to upgrade an RDS PostgreSQL cluster with only one writer and no AZ or read replica in any other regions. So pretty simple setup. While attempting upgrade based on the table here...

Hello AWS Community, I am currently storing event logs in an RDS Postgres database and am looking for an efficient way to manage the growing size of our tables. Here's what I am aiming to...

after setting the rds.logical_replication to 1, wal_level is not setting to logical

We did premigration test on our Data Migration Task, it shows 2 errors as below 1. Validate if wal_level is set to logical on the source database I searched for the help on this, and got info like if...