Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFqW5-0001lH-0T for pgsql-sql@arkaria.postgresql.org; Tue, 30 May 2017 23:25:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dFqW3-0006af-Bi for pgsql-sql@arkaria.postgresql.org; Tue, 30 May 2017 23:25:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFqW0-0006Pn-6P for pgsql-sql@postgresql.org; Tue, 30 May 2017 23:25:28 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFqVd-0006fu-T9 for pgsql-sql@postgresql.org; Tue, 30 May 2017 23:25:26 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id CEB4520F3A; Tue, 30 May 2017 19:25:04 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute6.internal (MEProxy); Tue, 30 May 2017 19:25:04 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=fm1; bh=1LWjcrSRW62rCRyE8v JowJyluZMCCBdffzwyjU7gSdM=; b=H0kKcAjgsAR83qNJvBj+99Qoz2/q2y2JYl NJhYhlNqfLKPm2j4j1lQDWhEgUA9NH76jZG1pGGUfiz2SVb+vytX4fW0XKdCfuNX Jcku7Vjb4rLe2oRVrzrL+GQwGcF7GbmcArIAjCcJl+gy0fli9uSMtEE6DsDbndaR qcFSQwrlrFPrbaiK9oerIqcO9AiwDyJPqy0EVLI+SEWkTg++2558VIksbYnQO96j TL3szTxecgJqRwWMH22E/eqRkpKH7U9yUTT5iMxf5FLtlV8nbXh/qYTgbvgyoHd6 vEBUO2octoMSem20Oa1QgGUkSsoBVxZavPdHwBEdOlmitD6QXbUw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= fm1; bh=1LWjcrSRW62rCRyE8vJowJyluZMCCBdffzwyjU7gSdM=; b=sAq8UYci UpIzN/PNNQ0CLKkXrtyMo0qSmtWs+FQYtSqa2SMC36NIca9RzX10hNS6yq3XKp41 mLczoYcE5u0HgWJzTorBn0ARju/jkyTpOQmiJohAWGE3xwDpGxoFdCILhASkKjIM Dvq4NQiuEMOJwPibY4MtkbQcdWTx6wDYus4KmfPogWbUTdz593mXVI3r6pe/lZZC mY3GNmgvWYFqspIHuDaBeV0qZ9k2tTtk6P/jY99KrnADAk72Am3Ds2nVWQ9smC74 O+8B8W28ENgFlGsNRx03kfj9WnS1zdvysVwsipVYMLgIqDKYyxzg0ks1rxKFCjxJ p1AtR6DVV/NJOg== X-ME-Sender: X-Sasl-enc: DkDdSuUSFa+3QIPPZpgYj43U4zUqEwXYRh9zy+/GxWoA 1496186704 Received: from [192.168.1.2] (75-172-126-41.tukw.qwest.net [75.172.126.41]) by mail.messagingengine.com (Postfix) with ESMTPA id 52D132444C; Tue, 30 May 2017 19:25:04 -0400 (EDT) Subject: Re: Lost my tablespace To: tel medola Cc: pgsql-sql@postgresql.org References: <32bb9df2-3b4d-95cb-1f82-8da675536a9b@aklaver.com> <100e137f-4510-031c-1fa5-51b2a145f39a@aklaver.com> <88a21207-a3c1-3e5e-88e6-a2403a0ea66b@aklaver.com> From: Adrian Klaver Message-ID: <0974bb0e-7f20-5da3-1f9a-85f8f1770cad@aklaver.com> Date: Tue, 30 May 2017 16:25:03 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql