Shell script to alert us when specified background process exceeds limit

Hello Everyone, The below script will help us to find number of processes runs in the background and send us alerts based on warning and critical thresholds. Script : # ]$ cat /home/oracle/DBA/bin/

Script execution : Syntax : ./ <PROCESS_NAME> <WARNING> <CRITICAL> Here I… Read More

PostgreSQL Articles

PostgreSQL Articles Dear Readers, Please check the below list of PostgreSQL Articles SNo Description Link 1 Installation of PostgreSQL 11.4 On Windows Platform 2 How to Download and Install the pgAdmin 4 3 Installation of PostgreSQL 11.4 in Linux Platform. 4 Install… Read More

PostgreSQL Interview Q&A Part-3

PostgreSQL Interview Q&A Part-3 Before going into the article, please check our previous article on PostgreSQL Q&A Part-2 1. Can we have different data directories for PostgreSQL Cluster? Under One PostgreSQL installation, you can create multiple Clusters.  Each Cluster will have its own data directory. One… Read More

PostgreSQL Interview Q&A Part-2

PostgreSQL Interview Q&A Part-2 Before going into the article, please check our previous article on PostgreSQL Q&A Part-1 1. What are template0 & template1 databases? As the name suggests, these are template databases that come by default with the Installation. In a fresh installation, both… Read More

PostgreSQL Interview Q&A Part-1

PostgreSQL Interview Q&A Part -1 PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance. The frequently asked questions from PostgreSQL database are given below. 1.Difference between Alert log in Oracle and Error log in PostgreSQL? Error log to PostgreSQL is… Read More