Re: [SQL] Lost my tablespace

On 05/29/2017 12:05 PM, tel medola wrote:
> 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:

https://www.postgresql.org/docs/9.6/static/sql-set.html

or schema.qualify the table name passed to \d+:

\d+ some_schema.table_name


> 
> 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./
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com