Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mckXs-0007pd-HG for pgsql-admin@arkaria.postgresql.org; Tue, 19 Oct 2021 08:32:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mckXr-00081o-6E for pgsql-admin@arkaria.postgresql.org; Tue, 19 Oct 2021 08:32:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mckXq-00081f-Qi for pgsql-admin@lists.postgresql.org; Tue, 19 Oct 2021 08:32:26 +0000 Received: from mail.pscs.co.uk ([178.159.9.185]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mckXn-0000Lj-R5 for pgsql-admin@lists.postgresql.org; Tue, 19 Oct 2021 08:32:26 +0000 Authentication-Results: mail.pscs.co.uk; spf=none; auth=pass (cram-md5) smtp.auth=pscs Received: from lmail.pscs.co.uk ([192.168.150.1]) by mail.pscs.co.uk ([192.168.150.185] running VPOP3) with ESMTPSA (TLSv1.3 TLS_AES_256_GCM_SHA384) for ; Tue, 19 Oct 2021 09:32:21 +0100 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pscs.co.uk; q=dns/txt; s=lmail; h=Subject:To:References:From:Message-ID:Date:MIME-Version:In-Reply-To :Content-Type:Content-Transfer-Encoding:Cc:Reply-to:Sender; t=1634631989; x=1635236789; bh=64kz2PQh2/NL4jFPdBg3w9yib57YlHEa3zyb/hwtIUE=; b=YU+pn2tfhZj2GKq+5zADIcng+RuynsppZdLscquxpSoOWi3QUt1wJQqiJXvQNpvqHyp3fNuD mdOt9FdP0ujrWyK5u7rhwOcYF/DVceZcALPCtzYkxYNoYj8lBUcHNqNf/JxkebWC7DDirWeS9o BghtCPs29sMQ7cT+YAI4Llf5I= Authentication-Results: lmail.pscs.co.uk; spf=none; auth=pass (cram-md5) smtp.auth=paul Received: from [192.168.6.10] ([192.168.150.1]) by lmail.pscs.co.uk ([192.168.150.70] running VPOP3) with ESMTPSA (TLSv1.3 TLS_AES_256_GCM_SHA384); Tue, 19 Oct 2021 09:26:28 +0100 Subject: Re: database on selected disk To: pgsql-admin@lists.postgresql.org References: <842cebe7-93c9-2ea0-0b64-4d4603348f26@jakobs.com> From: Paul Smith Message-ID: <65ee79c1-1cf2-1de8-0063-95701ef883b9@pscs.co.uk> Date: Tue, 19 Oct 2021 09:26:27 +0100 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0 MIME-Version: 1.0 In-Reply-To: <842cebe7-93c9-2ea0-0b64-4d4603348f26@jakobs.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-GB X-Authenticated-Sender: paul X-Server: VPOP3 Enterprise V8.2 - Registered to: PSCS X-Organisation: Paul Smith Computer Services X-VPOP3Tester: 12 345 X-Authenticated-Sender: pscs List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 19/10/2021 06:51, Holger Jakobs wrote: > > On the other hand, it's not possible to have some databases of a > cluster on one drive and some on another. A database cluster cannot be > distributed among disks. Except by using Tablespaces - https://www.postgresql.org/docs/14/manage-ag-tablespaces.html -- Paul Paul Smith Computer Services support@pscs.co.uk - 01484 855800 -- Paul Smith Computer Services Tel: 01484 855800 Vat No: GB 685 6987 53 Sign up for news & updates at http://www.pscs.co.uk/go/subscribe