Definitions More Info.
Definition ID	928
Title	POSTGRESQL
Category	NOTES
Definition	istenilen schema larin backup i
Definition Description	#!/bin/bash #This backup process starts by postgres system account cron job. #Bu backup islemi postgres sistem kullanicisinin cron job tarafindan calistirilmaktadir #EditDate: 201809281830 #Edited By: Cuneyd Tanriverdi #[email protected] # Backup Start Date Year=$(date +%Y) Month=$(date +%m) Day=$(date +%d) echo "---------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "`date`: REJECT All DB Connections." >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "---------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log /storage/backup/scripts/change_pg_hba_for_backup.sh >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "---------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "`date`: TRUNCATE DSS table process has STARTED" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "---------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log psql -U mgr -d erp < /storage/backup/scripts/truncate-dss-invtrnsmds-and-index.sql >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "---------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "`date`: TRUNCATE DSS table process has ENDED" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "---------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log #yeni yil dosyasi yoksa, olustur if [ ! -d /storage/backup/erpist/`date +%Y` ]; then mkdir /storage/backup/erpist/`date +%Y` #dosyay postgres kullanicisi icin izin ver chown postgres:postgres /storage/backup/erpist/`date +%Y` fi echo "------------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "`date`: CLUSTER SCHEMA-ONLY BACKUP process has STARTED" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "------------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log # Schema verildiginde data yedeklemesi yapmiyor. --schema-only gibi calisiyor. pg_dump -U postgres erp --schema-only -Fc --compress=9 > /storage/backup/erpist/$Year/erpist-$Year$Month$Day'-schema.dmp' echo "---------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "`date`: CLUSTER SCHEMA-ONLY BACKUP process has ENDED" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "---------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "------------------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "`date`:SCHEMAS: BACKUP-CHANGELOG-DBACHECKDB-DBR-ERP-EDI-MTM-OD-PORTAL-POWERBI-SAYIM-TMP backup process has STARTED" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "------------------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log #asagidaki schemalar disindaki tum backuplar alinsin. bir ust satirdaki DATABASELER demektir. pg_dump -U postgres erp -N '"DSS"' -N '"DW"' -Fc --compress=9 > /storage/backup/erpist/$Year/erpist-full-$Year$Month$Day'-data.dmp' #su postgres -c 'pg_dump -U postgres erp -Fc --compress=9 > /storage/backup/erpist/'$Year'/erpist-'$Year$Month$Day'-data.dmp' >> /var/www/log/Full-Backup-$Year-$Month-$Day.log echo "------------------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "`date`: SCHEMAS: ERP-EDI-TMP backup process has ENDED" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log echo "------------------------------------------------------------------" >> /var/www/log/ERP-Full-Dump-Data-Backup-$Year-$Month-$Day.log
RecordBy	cunay
Record Date	08-04-2019 09:30:44
Düzenle
Kopyala
Sil