This script is very useful after Issue top command you will get PID which one Process taken More CPU Utilization example for 32696 is the most CPU utilization process means take the PID then run the following script it will …
This script is mostly used for will display what are the postgresql query is running more than one minutes and it will display query with PID using this PID you can kill what query is taken more CPU utilization and …
1.MORE I/O POSTGRESQL KILLING ALL IDLE CONNECTION FOR MONITORING PURPOSES: This following script is used for killing all idle connection and you can use it as a monitoring puposes like how many idle query is running for a hour and …
I.TAKING TABLE STRUCTRE BACKUP WITH THEIR’S OBJECT FILE NAME : In this script helpful to take backup (DDL’s) of procedure, function & table definition with seperate file system (object name) based on postgres schema , this script is mostly used …
In this shell script will help you to take the backup of PostgreSQL table definition with different or individual file name as schema based. # Config: DB=”DBA” U=enterprisedb export PGPASSWORD=”tcs45″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ TABLES=”$(/opt/edb/as9.6/bin/psql -d $DB -U $U -t …
this script will take the postgresql base backup based on daily changes (if you scheduled daily) & it will delete the old backup if backup retention period is reached 2 days. you can call this as postgresql incremental backup Script …
Try following script , This script will take mysql database backup automatically and remove the old backup file which is over 3 days and once backup is completed means it will send mail confirmation If you know the mysql root password you …
This script can be used to check on mariaDB, apache2, or whatever service you want. This is not meant to be a SOLUTION to services that are crashing, but rather a notification and a temporary restart until you can solve …
Login with Google