postgresql database owner can't access database - "No relations found."
Perhaps the schema permissions for the public schema got mangled. What is the output of \dn+ on both sites?
The output should look like this:
List of schemas Name | Owner | Access privileges | Description --------+----------+----------------------+------------------------ public | postgres | postgres=UC/postgres | standard public schema : =UC/postgres (1 row)If the =UC/postgres part is missing, you can restore it with
grant all on schema public to public;