Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a3WM9-0004Oe-1Y for pgsql-admin@arkaria.postgresql.org; Mon, 30 Nov 2015 21:51:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a3WM8-0007DK-DK for pgsql-admin@arkaria.postgresql.org; Mon, 30 Nov 2015 21:51:32 +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) (envelope-from ) id 1a3WM7-0007Bc-GV for pgsql-admin@postgresql.org; Mon, 30 Nov 2015 21:51:31 +0000 Received: from mimolette.dalibo.net ([212.85.157.144]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1a3WM4-0003jp-JU for pgsql-admin@postgresql.org; Mon, 30 Nov 2015 21:51:31 +0000 Received: from [192.168.0.2] (aur75-1-78-192-238-147.fbxo.proxad.net [78.192.238.147]) by mimolette.dalibo.net (Postfix) with ESMTPSA id E6EFF1F103B0; Mon, 30 Nov 2015 22:51:27 +0100 (CET) Subject: Re: alter tablespace move feature postgresql 9.5/9/4 To: Yogi Barot , "'pgsql-admin@postgresql.org'" References: <4002a37ab5b44c5e8e8aca690017fbf6@MX002.symprod.com> From: Julien Rouhaud Message-ID: <565CC4DC.2080206@dalibo.com> Date: Mon, 30 Nov 2015 22:51:24 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: <4002a37ab5b44c5e8e8aca690017fbf6@MX002.symprod.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) 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 On 30/11/2015 18:10, Yogi Barot wrote: > Hi, > Hello, > > Do we have this feature available or will be available in 9.5 or 9.4? > > > > http://www.depesz.com/2014/01/23/waiting-for-9-4-tablespace-changes/ > Yes, this is already available since 9.4, but it has been changed since this blog post to ALTER TABLE ALL IN TABLESPACE and ALTER INDEX ALL IN TABLESPACE. See http://www.postgresql.org/docs/current/static/sql-altertable.html and http://www.postgresql.org/docs/current/static/sql-alterindex.html Regards. > > Thanks, > > Yogi > > > > CONFIDENTIALITY WARNING > This communication, including any attachments, is for the exclusive use > of addressee and may contain proprietary and/or confidential > information. If you are not the intended recipient, any use, copying, > disclosure, dissemination or distribution is strictly prohibited. If you > are not the intended recipient, please notify the sender immediately by > return e-mail, delete this communication and destroy all copies. > > AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ > Ce message, ainsi que les pièces qui y sont jointes, est destiné à > l’usage exclusif de la personne à laquelle il s’adresse et peut contenir > de l’information personnelle ou confidentielle. Si le lecteur de ce > message n’en est pas le destinataire, nous l’avisons par la présente que > toute diffusion, distribution, reproduction ou utilisation de son > contenu est strictement interdite. Veuillez avertir sur-le-champ > l’expéditeur par retour de courrier électronique et supprimez ce message > ainsi que toutes les pièces jointes. > > > > -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin