Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

How To move Postgresql archive log with tar fomat ? script

Ans:
In this shell script will move and compress the  Postgresql archive log to backup location, you can shedule it in crontab and change environment variable as per your firm 
PGDATA=/data/
PGHOME=/opt/PostgreSQL/9.5/bin
HOT=/backup
WAL_LOC=/archive/
LOG=/home/postgres/cron_script_logs
PGDATABASE=postgres
PGUSER=postgres
PGPORT=5432
TODAY=$(date +"%m-%d-%Y-%T")
echo "Archive backup Start Time: `date +%d-%m-%y-%T`" >> $LOG/archiveinfo_$TODAY.log
/opt/PostgreSQL/9.5/bin/psql -U $PGUSER -d $PGDATABASE -p $PGPORT -c "select pg_switch_xlog();" >> $LOG/archiveinfo_$TODAY.log
tar --remove-files -cvzf $HOT/arch_$TODAY.tar.gz $WAL_LOC/* >> $LOG/archiveinfo_$TODAY.log
echo "Archive backup End Time: `date +%d-%m-%y-%T`" >> $LOG/archiveinfo_$TODAY.log
exit 0

Comments

Popular posts from this blog

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

What's is the difference between streaming replication Vs hot standby vs warm standby ?

PostgreSQL Sequence