The problem is postgres was listening on 127.0.0.1...
# puppet
c
The problem is postgres was listening on 127.0.0.1 and I had puppetdb look for the DNS entry.