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 …
PostgreSQL, the most advanced open source database, offer lots of compensation intended for the industry in excess of other database systems. It too is accessible used for almost every operating system with the latest even release. PostgreSQL support ACID (Atomicity, …
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 …
Crontab file consists of command per line and have six fields actually and separated either of space or tab. The beginning five fields represent time to run tasks and last field is for command. Minute (hold values between 0-59) Hour (hold values …
Currently we want to take the backup what are the schema name having kafi and nijam. PreRequest: checking table rows count of particular table. Check the schema’s size. check the available backup location size. 1.List the schema whoose name start …
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 …
This scripts are using to tar(zip compress) and remove more than 1 month old postgresql log and linux log file 1.This script used for moving and compressing older than 30 days log files: vi /home/postgres/eds/tarlog.sh find /data/emut16_slavedata/pg_log/ -mtime +30 | …
Currently two postgres server is running which are : 10.11.128.81 : 10.11.128.82 : postgres version : 9.6 By using following query you can find which server is master and slave , mster should be false (f) value and slave should …
What to Consider When Choosing a Payroll Processing Service Getting your payroll done should be an efficient and secure process. And you should not need to get bogged down dealing with federal, state, and local tax filings and payments. Whether …
In this ever competitive world, you should always look for improvement in your area of expertise. Taking up a professional course is important to improve your performance in a given career. In order to acquire more advanced and better skills, …
1. What is the difference between a professional course and other courses? There is a lot of difference between professional courses and other courses. Here the other courses simply refer to the most non-professional courses. The main difference that we …
Human Resources It is the people who make an organization. Hence, human resources is one of the areas where the demand shall always be on the higher side. Human resources course is something that can be considered if you think you are …
The most important and obvious question that you face after completing your school is the profession that you want to get in and the professional course that will help you in getting into the career of your choice. Well, in …
5 Tips On Improving The Onboarding Process To Increase Efficiency Of Companies On boarding is the process of integrating a new employee into an organization. According to data obtained from US Bureau of Labor Statistics, 21% of total workforce has …
While some individuals may view HR outsourcing as a necessary chore, many companies are more than willing to offer this service as part of several other benefits for an affordable fee. In fact, this service is one of the most …
Login with Google