Re: Lost my tablespace

From: tel medola <tel(dot)medola(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Lost my tablespace
Date: 2017-05-30 23:29:34
Message-ID: CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2017-05-31 14:55:11 Re: Inconsistent/wrong behavior of pg_trigger_depth when used with DEFERRED CONSTRAINTS
Previous Message Adrian Klaver 2017-05-30 23:25:03 Re: Lost my tablespace