check_postgres: New formula

See previous attempt: #27921

I have removed the attempt to run the test suite at build time, because that was too fragile.  As requested, I have included a more substantial test after installation.
I wonder if it's worth requesting this upstream as an install option.