We're using Debezium as a change data capture connector for PostgreSQL (actually RDS). If for any reason the debezium connector has a terminal failure, the WAL will continue to grow until either debezium is fixed, or the server runs out…
I would like to retrieve the DB Option Group (OptionGroupName) for an RDS by using the aws rds describe-db-instances --query and --filters. Just FYI I can not use jq to filter the json response from aws rds describe-db-instances.
I have 2 AWS RDS MySQL instances that are not publicly accessible. And I have a bastion server that is created using an EC2 instance. This bastion server has several users in it. And they can use their own ssh…
I am upgrading my RDS postgresql from 10.21 to 14.4 by creating a new family group as well , my idea is to create new family group and upgrade the rds with new family group and then delete the old…
Currently, we are mainly using DMS, RDS & IAM AWS services. Now, if we want to use those services in different region / account then how to take only configuration backup? Like - DMS - Replication instances, Endpoint, Event subscriptions.…
I tried to connect my wordpress that have elb+ssl with amazon , to rds on aws. but i cant see all the information , color templates that in the webs only black and white i think that somting with mysql.…
I'm trying to deploy a web app to a shared hosting provider (Strato), but I have problems establishing a SSL-connection to the Amazon-RDS instance that I'm using. While testing the web app locally (using XAMPP) it works fine, but on…
Most of the time, our PostgreSQL (version 13.8, AWS Aurora, PostgreSQL compatible) database's buffer cache hit ratio has been somewhere around 95~98%. However, we have been observing an occasional dip in the buffer cache hit ratio to 70%-80%. I managed…
My goal is to stream the Postgres WAL inside a system that runs on the JVM. I am using Aurora RDS Postgres. If I try to run the following: PGReplicationStream stream = pgConnection.getReplicationAPI() .replicationStream() .logical() .withSlotName("test_slot") .withStartPosition(lsn) .start(); I get…
I'm using AWS RDS Postgres v13.7 I have a table, foo, of ~1m rows. I run a query that's a select distinct on 2 columns in a CTE, a self join after, and finally a select count(*). I clone the…