postgresql: a test

Closes #27805.

Signed-off-by: Adam Vandenberg <flangy@gmail.com>