Questions tagged with PostgreSQL

Looking for a solution to create an alert for blocking locks in Aurora Postgres or RDS postgres. Has anyone done this and how did you accomplish this? Thanks! Jeremy

Morning all, So I have a single instance RDS (multi-az) postgres database. We want to migrate over to Aurora for several reasons, and so this is where I am at. Since it's a mult-az, from the...

I am trying to use AWS DMS to migrate our PostgreSQL to MySQL which are hosted in AWS RDS. PostgreSQL version = 14.0 MySQL version = 8.0 Below are the steps I followed: - created a replication...

Hello there, Our company is currently migrating PostgreSQL databases from EC2 instances to the AWS RDS service. We migrated over 24 databases, and everything was okay till Monday. Since yesterday,...

We have approx. 20-30 EC2 machines which users use on regular basis; however, from last 30 minutes, no user is able to connect to any of the EC2 machines and also to RDS. Not sure what happened. Error...

using pgcrypto externsion in psotgres sql, following is the output for below queryies Query 1: ``` explain analyze (select * from table_name); ``` above query taking time around 900...

Hi there. I noticed that my Aurora PSQL reader DBs are still getting calls even tho they are getting removed. AFAIK The RDS DB should cut off the reader dbs if they are in a removal state, and...

I have posted a clear bug here: https://repost.aws/en/questions/QUXKt7jDIvTMi4SyW2jTKgbg I even created a narrated youtube video showing and explaining the bug. I got two answers, but both are...

My databases in RDS was working normally but suddenly empty. The database was still there but all data inside is deleted. I check the DB instance monitoring, event log and CloudTrail but still cannot...

We have a problem with the performance of PostgreSQL RDS instance running on gp3 storage. As you can see from the attached diagrams, in an recent incident it exhausted EBSIOBalance% while the number...

I've reserved RDS(Postgres: db.t4g.micro) for 3 years and created same RDS instance. Current billing period is still going on but I see below line item: $ 0.016 per RDS db.t4g.micro Single-AZ instance...

When Postgres 11.x deprecation for Amazon RDS is ?