#!/bin/sh

#set log directory
log="/var/log/postgres_backup.log"
 
#set and log start date
today=`date +%Y\/%m\/%d\ %H:%M:%S`
echo "${today}: Start of creation consistent state" >> ${log}

#stop postgres service
/etc/init.d/postgresql-* stop  >> ${log}

#force immediate execution of pending reads and writes in memory to disk
sync  >> ${log}

#set and log end date
today=`date +%Y\/%m\/%d\ %H:%M:%S`
echo "${today}: Finished freeze script" >> ${log}