In our development stack, we use Git and Jenkins to automate testing of our pull requests and commits.
I ran into a problem the other day where I was running an ETL job that plays a shell game with tables.
In both MySQL and Postgres there are times when you will want to login to the server in an automated non-interactive fashion.
The ~/.psqlrc file allows you to specify session level settings consistently to be used when you connect to Postgres via the command line.
One of the things I struggled with when I started using Postgres is writing queries on the psql command line utility.
Puppet is a great tool to manage deploying new servers and setting up configuration files to your specification.