Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bFIQZ-00075t-34 for pgsql-admin@arkaria.postgresql.org; Tue, 21 Jun 2016 09:57:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bFIQY-0000yD-Iw for pgsql-admin@arkaria.postgresql.org; Tue, 21 Jun 2016 09:57:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bFIQX-0000y4-00 for pgsql-admin@postgresql.org; Tue, 21 Jun 2016 09:57:01 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bFIQO-0005vn-GJ for pgsql-admin@postgresql.org; Tue, 21 Jun 2016 09:57:00 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 625F021C1FFA; Tue, 21 Jun 2016 12:56:45 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 5yVFJDfIa02Z; Tue, 21 Jun 2016 12:56:40 +0300 (MSK) Received: from [192.168.27.30] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 5EF1921C1FF8; Tue, 21 Jun 2016 12:56:40 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1466503000; bh=7y8trKzla1peDVT0ym9Dw8Ly6hseLnlq61QejwNHdWA=; h=Subject:To:References:Cc:From:Date:In-Reply-To; b=O8hHQ44VsEXAsK/Ax/Y1x4PTesY1aSwKBRWUZOGRADQv16lHw1903V3RAQlJr0v+H 045tyi7oGLoBqksZZBO3LhujmNTG4hmHXdhmCrvBs+7hN6J3Fy0JQrN7lTY5Pt/ET9 iTxgI36EQXhYj0gkOkRN2i3MFxD211vwhEC2JPDY= Subject: Re: reuse tablespace from crashed PSQL instance To: Artem Tomyuk References: <19518802B8BEC076.F3B8DC25-B5D7-4BA3-9B38-05D6137F201D@mail.outlook.com> Cc: pgsql-admin@postgresql.org From: Alex Ignatov Message-ID: Date: Tue, 21 Jun 2016 12:56:41 +0300 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------04D0DDBA51B5B3C6D89CC210" X-Pg-Spam-Score: -3.4 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------04D0DDBA51B5B3C6D89CC210 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Please describe more your problem. Say A happend and I need B Alex Ignatov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company On 21.06.2016 11:40, Artem Tomyuk wrote: > So what are my steps to reconnect it? > > I should run create tablespace command again or just add path and name > to the postgresql.conf? > > 2016-06-21 11:38 GMT+03:00 Alex Ignatov >: > > There is nothing in relation data files that prevent you to do it > (no headers etc in files) except xmin and xmax info from tuple %). > So the short answer is yes you can do it but may be you will not > see any data from it if for example current txid is less than > xmin's from data files. > PS There is no transportable tablespaces as they are in Oracle. So > you can only try it at home ;) > > Alex Ignatov > Postgres Professional: http://www.postgrespro.com > Russian Postgres Company > > > > > On Tue, Jun 21, 2016 at 11:26 AM +0300, "Artem Tomyuk" > > wrote: > > Hi. > > Is it possible to reconnect tablespace from old setup to the > new one with the same version of PGSQL? > > Thanks. > > --------------04D0DDBA51B5B3C6D89CC210 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Please describe more  your problem. Say A happend and I need B
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 21.06.2016 11:40, Artem Tomyuk wrote:
So what are my steps to reconnect it? 

I should run create tablespace command again or just add path and name to the postgresql.conf?

2016-06-21 11:38 GMT+03:00 Alex Ignatov <a.ignatov@postgrespro.ru>:
There is nothing in relation data files that prevent you to do it (no headers etc in files) except xmin and xmax info from tuple %). 
So the short answer is yes you can do it but may be you will not see any data from it if for example current txid is less than xmin's from data files.
PS There is no transportable tablespaces as they are in Oracle. So you can only try it  at home ;)

Alex Ignatov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company




On Tue, Jun 21, 2016 at 11:26 AM +0300, "Artem Tomyuk" <admin@leboutique.com> wrote:

Hi. 

Is it possible to reconnect tablespace from old setup to the new one with the same version of PGSQL?

Thanks.


--------------04D0DDBA51B5B3C6D89CC210--