From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | tel medola <tel(dot)medola(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Lost my tablespace |
Date: | 2017-05-29 19:32:20 |
Message-ID: | a18d2b5a-255f-e5b5-0c4d-686eb182e88e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Feike Steenbergen | 2017-05-30 06:00:06 | Re: about LEFT and INNER JOIN |
Previous Message | tel medola | 2017-05-29 19:05:17 | Re: Lost my tablespace |