|From:||PG Bug reporting form <noreply(at)postgresql(dot)org>|
|Subject:||BUG #16101: tables in the DB is not available after pg_restore|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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
Did not find any relations.
|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|