tables in the DB is not available after pg_restore.
PG Doc comments form <[email protected]> Fri, 08 Nov 2019 06:43:43 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/app-pgrestore.html Description: Hi, I have one question about pg_restore tool, tables in the DB is not available after pg_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. Thanks Zeng