backup postgres db with --inserts flag so it is easier to git track (instead of multiple snapshots, track snapshots with git)

pg_backup_git.sh

#!/bin/bash

host="host"
user="pg_user"
port=1000
dbname="dbname"

# the "no-password" flag requires a .pgpass file with a password, to avoid being prompted for a password
pg_dump -h $host -U $user -p $port --no-password --inserts $dbname