agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: tel medola <tel.medola@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Lost my tablespace
Date: Tue, 30 May 2017 23:29:34 +0000
Message-ID: <CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.com> (raw)
In-Reply-To: <0974bb0e-7f20-5da3-1f9a-85f8f1770cad@aklaver.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Ok Adrian.
I' will asking pgsql-general list.
Very thanks for all help!
Em ter, 30 de mai de 2017 às 20:25, Adrian Klaver <adrian.klaver@aklaver.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
>
view thread (25+ messages)
Message-ID: <CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.com>
Permalink: ../CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.com/
Also on: postgresql.org/message-id/CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.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: tel.medola@gmail.com, adrian.klaver@aklaver.com
Subject: Re: Lost my tablespace
In-Reply-To: <CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.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