all: add tests.

Fair point, but using postgres user is handy for using with CircleCI, because such user exists by default.