Re: [SQL] Lost my tablespace - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: [SQL] Lost my tablespace
Date
Msg-id 0974bb0e-7f20-5da3-1f9a-85f8f1770cad@aklaver.com
Whole thread Raw
In response to Re: [SQL] Lost my tablespace  (tel medola <tel.medola@gmail.com>)
Responses Re: [SQL] Lost my tablespace  (tel medola <tel.medola@gmail.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [SQL] Lost my tablespace
Next
From: tel medola
Date:
Subject: Re: [SQL] Lost my tablespace