/usr/lib/ghc-doc/hoogle/libghc-text-postgresql-doc.txt is in libghc-text-postgresql-doc 0.0.2.3-1build1.
This file is owned by root:root, with mode 0o777.
It is a symlink to /usr/lib/ghc-doc/hoogle/../../../share/doc/libghc-text-postgresql-doc/html/text-postgresql.txt