MIME-Version: 1.0
References: 
 <CANRMYmgu3ddSU62-=a3QCnsbGYuMVJXZ-ydTm7vd_2TQLp-Oqg@mail.gmail.com>
 <CANRMYmhxARYp73boRCfHB5VHDFT+wM5G=kTGrCQcN0Ds=uxLWw@mail.gmail.com>
 <a9063a7d-ac70-abb8-38f4-6ef49bf401f3@aklaver.com>
 <CANRMYmjc7nc0GpxCkxApQTgAr+9YGooUvA8AEU_9SjjBJb+qqg@mail.gmail.com>
 <32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com>
 <CANRMYmgw9+vreD0+43vGK+JYyshMaea=zedwc1ufYS_cBEj5VA@mail.gmail.com>
 <a18d2b5a-255f-e5b5-0c4d-686eb182e88e@aklaver.com>
 <CANRMYmjY9V-rzygyDFrDmf2GDP_-vcsEiP-ZOXd6WvNAFUEnhA@mail.gmail.com>
 <b7598d9a-eef6-1ff3-7d30-19838b3add51@aklaver.com>
 <CANRMYmjXeyEYeEaVV+8k_DZBXuNipCWZ8+wWvYCKGnSKRAAEmQ@mail.gmail.com>
 <100e137f-4510-031c-1fa5-51b2a145f39a@aklaver.com>
 <CANRMYmgKvrGEo5NOQ7ScRBJj-jgae5bS5y6oXVrwQh0csonPbw@mail.gmail.com>
 <c8865858-2ab4-12d2-8b2f-f8ef24396860@aklaver.com>
 <CANRMYmjzn9RcB9W-nCnvt24cKE9hgmXB05gXkVb5PFC4sqCX6Q@mail.gmail.com>
 <88a21207-a3c1-3e5e-88e6-a2403a0ea66b@aklaver.com>
 <CANRMYmhGJAaZEMCevzcrhVVVhEMJzgo+P_Ms_E4UiJB60ozJHg@mail.gmail.com>
 <0974bb0e-7f20-5da3-1f9a-85f8f1770cad@aklaver.com>
In-Reply-To: <0974bb0e-7f20-5da3-1f9a-85f8f1770cad@aklaver.com>
From: tel medola <tel.medola@gmail.com>
Date: Tue, 30 May 2017 23:29:34 +0000
Message-ID: 
 <CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.com>
Subject: Re: Lost my tablespace
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary="001a113c20bebcd8140550c62de8"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

--001a113c20bebcd8140550c62de8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Ok Adrian.
I' will asking pgsql-general list.

Very thanks for all help!

Em ter, 30 de mai de 2017 =C3=A0s 20:25, Adrian Klaver <adrian.klaver@aklav=
er.com>
escreveu:

> On 05/30/2017 01:36 PM, tel medola wrote:
> > EXACT !!!!!
> >
> > When I did the truncate, it erased all the files that referenced the
> > table and created a new one (empty). That's why when I returned the
> > physical files to the drives, it does not find the old reference and it
> > is empty.
> >
> > I'll search how to redo the link for the correct filenode.
> > Thanks very much for your help!!!
> >
>
> Just so you know I am willing to ask how to do this on the pgsql-general
> list if you want.
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>

--001a113c20bebcd8140550c62de8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div>Ok Adrian.</div><div>I&#39; will asking pgsql-general list.</div><div>=
<br></div><div>Very thanks for all help!</div><div><br><div class=3D"gmail_=
quote"><div>Em ter, 30 de mai de 2017 =C3=A0s 20:25, Adrian Klaver &lt;<a h=
ref=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&gt; =
escreveu:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 =
.8ex;border-left:1px #ccc solid;padding-left:1ex">On 05/30/2017 01:36 PM, t=
el medola wrote:<br>
&gt; EXACT !!!!!<br>
&gt;<br>
&gt; When I did the truncate, it erased all the files that referenced the<b=
r>
&gt; table and created a new one (empty). That&#39;s why when I returned th=
e<br>
&gt; physical files to the drives, it does not find the old reference and i=
t<br>
&gt; is empty.<br>
&gt;<br>
&gt; I&#39;ll search how to redo the link for the correct filenode.<br>
&gt; Thanks very much for your help!!!<br>
&gt;<br>
<br>
Just so you know I am willing to ask how to do this on the pgsql-general<br=
>
list if you want.<br>
<br>
<br>
--<br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
</blockquote></div></div>

--001a113c20bebcd8140550c62de8--