Askdba.org Website Review

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 generate rsa key-pair using ssh-keygen -t rsa on both hosts copy the public keys to postgresql logs contains useful information which can help in troubleshooting performance issues,auditing and performing historical an*lysis. some of items which can be logged are listed below client connection and disconnection messages failed db connection request database sql statement errors database fatal errors auditing information database lock history long running queries and query plan 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 conversion tool(sct) for converting the database schema.aws schema conversion tool takes care of automatically converting schema from one database engine to other. you can get… 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 hat hacker who exploited the content injection vulnerability in 4.7.0 and. how to configure exadata database machine in enterprise manager cloud control 13c (oem13c) configure exadata database machine in oem13c. if you want to configure your exadata in oem13c you have to follow the above mentioned link. in this post i will share the mandatory steps for configuration, and some of the issues which i faced while configuring the exadata… before opting to procure exadata machines, the first thing you need to check is the readiness of your data center to hold these machines. exadata’s dimensions are similar to other normal racks i.e a 42u rack. the complete details for x5-2 physical site requirements can be found here. this is very important step as, for some data… 17 may, 2016