Collected from the PG bugs email list.
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 16101 Logged by: zeng Email address: (redacted) PostgreSQL version: 10.10 Operating system: suse Description: hi, I have one question about pg_restore tool, tables in the DB is not available after restore. Even if the user is still the owner of table after restore. Steps: 1. Create one database and the owner is user1. And create table and pop the data with user1 2. Use pg_dump tool to backup one database with superuser postgres. 3. Use pg_restore tool to restore the database with the parameter –clean and supper user. 4. Connect the db with user1 and found the user does not select table as below. cdb=> \dt Did not find any relations.
|2019-11-08 07:37:24+00||PG Bug reporting form||BUG #16101: tables in the DB is not available after pg_restore|
|2019-11-08 11:13:39+00||Tomas Vondra||Re: BUG #16101: tables in the DB is not available after pg_restore|