Run repmgr related psql commands as specified user
For peer authentication to work, the user running the command should be same as that running the psql query. This worked so far because the user mentioned in query is gitlab-consul and we are running these queries as gitlab-consul, from recipes.