Re: [SQL] Lost my tablespace - Mailing list pgsql-sql
From | tel medola |
---|---|
Subject | Re: [SQL] Lost my tablespace |
Date | |
Msg-id | CANRMYmgw9+vreD0+43vGK+JYyshMaea=zedwc1ufYS_cBEj5VA@mail.gmail.com Whole thread Raw |
In response to | Re: [SQL] Lost my tablespace (Adrian Klaver <adrian.klaver@aklaver.com>) |
Responses |
Re: [SQL] Lost my tablespace
|
List | pgsql-sql |
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 done before. But it's only "new" that I can get with the SELECT, the others, not.
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)
2) Why the INHERIT/NO INHERIT/INHERIT sequence?
/Because if I do not undo the inheritance, it will copy from it, to itself. After the copy is finished and I make sure everything is in place, I delete the original table and redo the links. With this, all my data is a new drive and with the link redone, my SQL's will function normally as if it were just a table./
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.
2017-05-29 15:45 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 05/29/2017 11:21 AM, tel medola wrote:As to below:
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?
Also can you show in psql:
\d+ (The tables involved)
2) Why the INHERIT/NO INHERIT/INHERIT sequence?
/Because if I do not undo the inheritance, it will copy from it, to itself. After the copy is finished and I make sure everything is in place, I delete the original table and redo the links. With this, all my data is a new drive and with the link redone, my SQL's will function normally as if it were just a table./
But none of this was actually done when you tried to recover the tables.
3) If 1) is correct did the COPY actually do anything?
/I only do this when I move my data to a new drive./
--
Adrian Klaver
adrian.klaver@aklaver.com