[corat-coret] mikrotik graph backup

#!/bin/bash

fname="/path/to/folder/graph1-$(date +%Y-%m-%d).gif"
if [ ! -f "$fname" ]
then
 wget http://host1:port1/graphs/iface/ether1/daily.gif -O $fname 
fi

fname="/path/to/folder/graph2-$(date +%Y-%m-%d).gif"
if [ ! -f "$fname" ]
then
 wget http://host2:port2/graphs/iface/ether1/daily.gif -O $fname 
fi

exit 0

[corat-coret] setup postgresql backup server

apt-get install postgresql postgresql-client apache2 php5 php5-postgresql
su postgres
psql

create user [local_user] with password '[local_userpassw]';
create database [local_dbname] owner [local_user];

pg_dump -co -h [remote_address] -U [remote_user] [remote_dbname] | psql -h localhost -U [local_user] [local_dbname]