Linux: ssh equivalence and SELinux
This is quick post summarizing issues encountered while setting up ssh equivalence on EC2 instance. I was setting up RHEL7 EC2 instances and followed below procedure to setup ssh equivalence…
Read Full RecipeAuthor: Amit Bansal
Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions.
Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python
Querying RDS PostgreSQL logs using Amazon Athena
PostgreSQL logs contains useful information which can help in troubleshooting performance issues,auditing and performing historical analysis. Some of items which can be logged are listed below Client connection and disconnection…
Read Full Recipe
Migrating Function based indexes from Oracle to PostgreSQL
In this post, I will share issue faced while working with function based index in PostgreSQL . I was performing database migration from Oracle to PostgreSQL and used AWS Schema…
Read Full Recipe
Update WordPress Installations to >4.7.2
This post is applicable for hosted wordpress installations where auto-updates are disabled. Yesterday, I noticed there was blog post "Hacked by Unknown" on Askdba blog. Post was written by White…
Read Full Recipe
PROCESSED Messages not clearing from Oracle Queue
I was contacted by Dev team to look into Development database where Oracle queue size kept on increasing. As per them messages were not getting cleared.They were running count on…
Read Full Recipe
12.1.0.2 PDB fails to come out of restricted mode
This one is a nasty bug :) I was trying to setup Oracle PDB in a test environment for the first time and got stuck with ORA-01035 error [oracle@oracle11g ~]$ sqlplus hr/hr@//oracle11g:1522/engg…
Read Full Recipe