To keep this simple, for both MySQL and Postgres I will assume that you have already setup your master to have a user that can access everything that is needed for replication and that there is nothing in the network that would prevent your hosts from talking to each other.
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.