The copy being the file system drive backups of each tablespace?
Yes
Then the below from your original post means?
That despite recovering the backup, I can not access my data. So I posted that I lost my tablespaces.
When I run the \ d + command the involved tables are not shown. Not even the one I can access via Select (only those that are in the public schema are shown)
Esquema | Nome | Tipo | Dono | Tamanho | Descrição
1) In the below you are saying that you used that template to try to recreate the original tables, correct?
/No.I have not done anything yet to try to retrieve the information, even though they are there. I just can not redo the links, even with the inherit command already executed./
It seems you are doing something, that is what I am trying figure out. What INHERIT command?
/I did it, I'm not doing it./ /After I returned the copy, I did nothing else. That "new" I said, I had
The copy being the file system drive backups of each tablespace?
done before. But it's only "new" that I can get with the SELECT, the others, not./
Then the below from your original post means?:
"Is there any way Postgres redo the link with the child tables ?? I already ran the command to rewrite inheritance, but the size of the tables continues with 8192."
/ / /When I run the \ d + command the involved tables are not shown. Not even the one I can access via Select (only those that are in the public schema are shown) /
You will either need to set the search_path to all the schemas involved, see example at bottom of page below:
But none of this was actually done when you tried to recover the tables.
/When I returned the backup (drive copy, not pg_dump), I realized that the information was not being found. I did not change anything else at the database and sent the email to the community./