Update pgbouncer conf to work with single postgres instance
Updating pgbouncer config to point directly to postgres when using a single postgres instance. Initially we used Consul to do this, but this isn't correct for a single instance and recently stopped working when we removed the use of patroni/repmgr on a setup with a single postgres node.