agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: tel medola <tel.medola@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Lost my tablespace
Date: Mon, 29 May 2017 11:45:13 -0700
Message-ID: <32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com> (raw)
In-Reply-To: <CANRMYmjc7nc0GpxCkxApQTgAr+9YGooUvA8AEU_9SjjBJb+qqg@mail.gmail.com>
References: <CANRMYmgu3ddSU62-=a3QCnsbGYuMVJXZ-ydTm7vd_2TQLp-Oqg@mail.gmail.com>
<2a418dab-d17f-9d3a-0ac4-53678c1ce16f@aklaver.com>
<CANRMYmjbg6MFhB=3wo6tcueUL8mqmqRfysSYrgRFHUu04Mxrwg@mail.gmail.com>
<97bd2743-46c3-32c4-7b3f-62def38aea65@aklaver.com>
<CANRMYmhxARYp73boRCfHB5VHDFT+wM5G=kTGrCQcN0Ds=uxLWw@mail.gmail.com>
<a9063a7d-ac70-abb8-38f4-6ef49bf401f3@aklaver.com>
<CANRMYmjc7nc0GpxCkxApQTgAr+9YGooUvA8AEU_9SjjBJb+qqg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.klaver@aklaver.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (25+ messages) latest in thread
Message-ID: <32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com>
Permalink: ../32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com/
Also on: postgresql.org/message-id/32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, tel.medola@gmail.com
Subject: Re: Lost my tablespace
In-Reply-To: <32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox