Postgresql

#!/bin/bash
logfile="/home/user/pgsql.log"
backup_dir="/home/user/backup"
touch $logfile
databases=`psql -h localhost -U postgres -q -c "\l" | sed -n 4,/\eof/p | grep -v rows\) | grep -v template0 | grep -v template1 | awk {'print $1'}`

echo "Starting backup of databases " >> $logfile
for i in $databases; do
        dateinfo=`date '+%Y-%m-%d %H:%M:%S'`
        timeslot=`date '+%Y%m%d%H%M'`
        /usr/bin/vacuumdb -z -h localhost -U postgres $i >/dev/null 2>&1
        /usr/bin/pg_dump -U postgres  -F c -b $i -h 127.0.0.1 -f $backup_dir/$i-database-$timeslot.backup
        echo "Backup and Vacuum complete on $dateinfo for database: $i " >> $logfile
done
echo "Done backup of databases " >> $logfile

tail -15 /home/user/pgsql.log

psql -U username -d database -a -f file.psql

shp2pgsql -d -s srid -W 'UTF-8' path/to/shapefile  database_table  | psql -h 127.0.0.1 -d  database -U  database_user

psql databasename -c "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public to username;"
psql databasename -c "GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public to username;"
psql databasename -c "GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public to username;"

CREATE USER username WITH ENCRYPTED PASSWORD 'some pass';