AWS – DBA Notes

AWS Oracle

Alert Log file and Listener Log file in AWS RDS Oracle

In AWS RDS Oracle we can use Listenerlog and Alertlog data dictionary views to check errors and other related information. in sqlplus you can use…

AWS Postgres postgresql

Migrate PostgreSQL Users To AWS RDS PostgreSQL

Bulent Soylu December 28, 2023 migrate postgresql rds

According to PostgreSQL migration, we can migrate the databases and tables. I was migrating a Postgresql environment from EC2 to RDS Postgresql. I have completed…

AWS MySQL

Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime

Bulent Soylu September 30, 2023 aurora aws mysql serverless upgrade

When Amazon Aurora Serverless v1 came out, it was one of the most exciting new features of 2018. The ability to have a relational database without having…

AWS Postgres postgresql

Upgrade Amazon RDS to major and minor versions of PostgreSQL

Bulent Soylu August 19, 2023 aws-rds postgresql upgrade

Open-source PostgreSQL occasionally releases new minor and major versions that include fixes for frequently encountered bugs, security issues, and data corruption problems. Generally, Amazon RDS aims to support new…

AWS Postgres

Scheduling maintenance with the PostgreSQL pg_cron extension

Bulent Soylu August 18, 2023 aws rds pg_cron postgresql

You can use the PostgreSQL pg_cron extension to schedule maintenance commands within a PostgreSQL database. For more information about the extension, see What is pg_cron? in the pg_cron documentation.…