Simon_Kelly@xxxxxxxxxxx writes:
This may sound a bit weird, but have you tried logging in as user1 and then granting the permission's to the superuser?
Found that superuser could not see them because I had the tables in two schemas which the superuser did not have path to.
Doing \dt <schema>.* I was able to see them. Backup still freezing though.