I have a working command to fetch manual snapshots info. How can I use the query option to filter out only snapshots older than 30 days? aws rds describe-db-cluster-snapshots --query "DBClusterSnapshots[*].[DBClusterSnapshotIdentifier, DBClusterIdentifier, SnapshotCreateTime, Status, Engine]" --output table Thanks very much
This is not a question but more of a public service announcement for anyone who is running MySQL 8.0.37 and has experienced an unstoppable memory leak. We are on Amazon MySQL for RDS and upgraded from 8.0.28 to 8.0.37. After…
My team and I are attempting to upgrade our multi-tenancy AWS RDS/MySQL instance from MySQL 5.7 to 8. After trying the upgrade, we received a report showing a large number of errors for the customers, and lineitems tables. Example Errors…
I've setup AWS RDS SQL Server database (2022) and am trying to access it through SSMS 20.2. It keeps throwing this error: Cannot connect to database-2.abcdfghi.us-east-1.rds.amazonaws.com. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The…
I am currently working on a project, which involves a Lambda (Master-)function to manage different other things. It has an S3 trigger calls another Lambda function (SubLambda1) which makes a AWS Textract call calls another Lambda function (SubLambda2) which makes…
Is it possible to get aws rds version? I know for Aws rds Aurora version select aurora_version(); aurora_version ---------------- 16.3.0 (1 row) select version(); version ------------------------------------------------------------------------------------------------------------- PostgreSQL 16.3 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit (1 row) SHOW server_version…
I am currently upgrading my SonarQube setup and migrating its database. Here’s my current configuration: Current SonarQube Version: 7.9 (Community Edition) Current Database: Internal PostgreSQL 12 Target Database: AWS RDS PostgreSQL 13 New SonarQube Instance: 9.9 (Community Edition) Objective: I…
Can someone help me with best solution to stop an RDS instance beyond 7 days . I can see that the common approach is to use lambda + cloudwatch event . I came across Resource scheduler which is managed by…
I'm attempting to set up a basic free tier AWS RDS postgres database. I have done this before, today. For some reason, I am suddenly unable to connect to any new databases I set up. I get this error when…
I am facing a problem where my AWS Elastic Beanstalk environment's health has been degraded automatically. I received the following error messages in the Environment Events log:Failed to deploy configuration. August 15, 2024 13:07:33 (UTC+5) ERROR Rollback of environment Univexch-env…