Allow non-interactive postgres authentication

Since postgres will not accept a command line password argument
we can instead set the PGPASSWORD environment variable