Re: Lost my tablespace

Sorry by delay....

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*
*----------+-------------+--------+----------+------------+-----------*
* 01052016 | repositorio | tabela | postgres | 8192 bytes |*
* 05122016 | repositorio | tabela | postgres | 8192 bytes |*
* 13042017 | repositorio | tabela | postgres | 491 GB |*
* 22082016 | repositorio | tabela | postgres | 8192 bytes |*
* 30122015 | repositorio | tabela | postgres | 8192 bytes |*

2017-05-29 16:32 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> 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(dot)klaver(at)aklaver(dot)com
>