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…
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…
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…
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…
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…
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 [or[email protected] ~]$ sqlplus hr/hr@//oracle11g:1522/engg…