Trouble with postgre(maybe)

Looks like a permissions problem.

Did you look at that topic for clues?

Is this data that you moved from another server? Is that server working? Can you take a backup and restore it to the new server?