BUG #16101: tables in the DB is not available after pg_restore

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 270246512(at)qq(dot)com
Subject: BUG #16101: tables in the DB is not available after pg_restore
Date: 2019-11-08 07:37:24
Message-ID: 16101-5a569e5aac6aa84e@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16101
Logged by: zeng
Email address: 270246512(at)qq(dot)com
PostgreSQL version: 10.10
Operating system: suse

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.
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
cdb=> \dt
Did not find any relations.


Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-11-08 09:28:55 BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10
Previous Message nemo 2019-11-08 06:59:24 pg_dump: error: schema with OID 7956828 does not exist