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 18:45:13 |
Message-ID: | 32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | tel medola | 2017-05-29 19:05:17 | Re: Lost my tablespace |
Previous Message | tel medola | 2017-05-29 18:21:29 | Re: Lost my tablespace |