Vijaya Reddy PR’s Post

Small win today - managed to deploy my #rust #axum API to #aws using #cloudformation with #rds #postgres database! Now to dig deeper into AWS CloudFormation and set up a proper VPC

We recently worked for upgrading AWS RDS Postgresql instances from PSQL version 13 to 15 and on completion of this major version upgrade we ran across an issue with the log messge "no pg_hba.conf entry for host "x.x.x.x", user "<<username>>", database <<db_name>>, no encryption. Applications failed to connect to databases. Upon troubleshooting this issue further , We came to know that rds.force_ssl parameter value is set to 1 by default starting AWS RDS Postgresql 15 which forces the connections to be encrypted by default. For internal reasons, we did not want to enable this (the value remained 0 by default in previous versions of psql) and setting this value to 0 helped resolve the issue. If you are planning to perform major upgrades and want to get rid of these issues in future, It is advised to perform a quick comparison between the old and new parameter groups with the compare parameter group option provided under Actions tab in parameter groups to get drifts between current and future version parameters of parameter group. #awsrds #majorversionupgrade #psql15 #dba #awscloud Repost to share with fellow cloud engineers.

🚀 ☁!! - Exciting News - !! ☁🚀 Are you currently grappling with the challenges of database migration? Are you looking to break free from the complexities of the AWS Schema Conversion Tool (SCT) Extension Pack and transition to a truly open PostgreSQL-compatible solution on AWS? At DataCloudGaze Consulting, we understand the importance of seamless database migration and the need to avoid lock-in and hidden dependencies. That's why we're thrilled to announce our latest solution: "Breaking Free: Transitioning Your Database Away from AWS SCT Extension Pack to Truly Open." #DatabaseMigration #AWS #PostgreSQL #OpenSource #CloudDatabaseFreedom☁☁ #BreakingFree #TechInnovation

Master the basics of #AWS RDS with our step-by-step tutorial! Learn how to: ✅ Set up MySQL RDS ✅ Connect it to MySQL Workbench ✅ Explore snapshots, backups, and restores Perfect for beginners or a quick refresher. Watch now & level up! 👇 🎥 https://lnkd.in/eYzAN77X #AmazonRDS #CloudComputing #AWSBeginner

Don't miss out! Whether you're assisting a customer or collaborating with a partner to convert code to PostgreSQL using the AWS Schema Conversion Tool, this demo is a must-see. Join us to discover how you can unlock truly open PostgreSQL code and avoid hidden lock-ins with Extension Packs. Demo - https://lnkd.in/dSpe6sbr App - https://lnkd.in/dmfqpR3j #PostgreSQL #AWSSCT #Migration #Conversion #RDS #AmazonAurora #PLSQL #PLpgsql #ExtensionPack #aws_oracle_ext

Ready to break free from vendor lock-in and achieve a truly open-source PostgreSQL migration on AWS? Leveraging our experience migrating dozens of customers and our innovative sct-migrator tool, we'll help you ditch AWS SCT extension packs and migrate to a performant, future-proof PostgreSQL compatible code. #PostgreSQL #AWSSCT #ExtensionPack #TrulyOpen #Oracle #aws_oracle_ext Explore our blog for more details. https://lnkd.in/dFgrPRuE

How to Move a Database with Users from One MariaDB RDS Instance to Another on AWS

Today, I earned my "Configure and migrate to Azure Database for PostgreSQL" trophy! I’m proud to celebrate this achievement and hope this inspires you to start your own @MicrosoftLearn journey! 🏆🚀 #Azure #MicrosoftLearn

Launching a PostgreSQL database on AWS and connecting to it using pgAdmin is a process that can be completed in a few steps. This setup allows you to manage your database efficiently, taking advantage of AWS's infrastructure and pgAdmin's powerful features.

🚀 ☁!! - Exciting News - !! ☁🚀 Are you currently grappling with the challenges of database migration? Are you looking to break free from the complexities of the AWS Schema Conversion Tool (SCT) Extension Pack and transition to a truly open PostgreSQL-compatible solution on AWS? At DataCloudGaze Consulting, we understand the importance of seamless database migration and the need to avoid lock-in and hidden dependencies. That's why we're thrilled to announce our latest solution: "Breaking Free: Transitioning Your Database Away from AWS SCT Extension Pack to Truly Open." https://lnkd.in/dykMd22T #DatabaseMigration #AWS #PostgreSQL #OpenSource #CloudDatabaseFreedom☁☁ #BreakingFree #TechInnovation