Set the Postgres application name when connecting

This should improve the logging and help identify queries and connections coming from this app.