Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuBov-004p9P-Mw for pgsql-general@arkaria.postgresql.org; Mon, 17 Mar 2025 14:52:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tuBou-00DuZU-8F for pgsql-general@arkaria.postgresql.org; Mon, 17 Mar 2025 14:52:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuBot-00DuZM-Tb for pgsql-general@lists.postgresql.org; Mon, 17 Mar 2025 14:51:59 +0000 Received: from mail-oo1-xc2c.google.com ([2607:f8b0:4864:20::c2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuBoq-003O8l-0a for pgsql-general@postgresql.org; Mon, 17 Mar 2025 14:51:59 +0000 Received: by mail-oo1-xc2c.google.com with SMTP id 006d021491bc7-5fe86c16f5dso2020593eaf.1 for ; Mon, 17 Mar 2025 07:51:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742223115; x=1742827915; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=0RoM3hNH0AqcWyETBFXrVXmFqlmRydMACnQ8Rjvbyr0=; b=mY1GMpysOquhPeEN7KcqsPen+iDVb7VdqGUX6ID6HrhTXh/Ir+r5l/0f2WCIusI3jS 5uaJxbki09+RuVAgvwyAer6ceSFEEFqICIwSMIUNKPgrkDbu+oYJISPTtbbm2vgDQeOR V/TChjobdvD5sQ3cqD9rUWB8pqKTlj1E2RmpBNiwgPVzTw8xlKSlGFmXTKzVQbwFX3Ve xVSq6BEZUYwvbLIQeiCKZfOIB3upLf/atLjK3Jj1qSAA68BPxNp3osTcyzIItJmen3kd HlGrH37R0VTCJwoXwDxQaoW6F/kNi/cZxcffiey/5AmP2T6GnjXEv/bS9dONOY7XVcP0 N14g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742223115; x=1742827915; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=0RoM3hNH0AqcWyETBFXrVXmFqlmRydMACnQ8Rjvbyr0=; b=QYEcrjjzbypQV4/LtruBYKRMwAWSyZYZ4LLvqZNMFt24d7fv5CcVIIVWOUtEh2RyK2 ujonFfOhl3rg6PAbF1FpOeMcl1U2hxmfpHHg0K3SpCNqLTuVStOpqQwG5Zqy4BUNKD9v iuoJzmLwPzVcxXv1xhleFh0CgWmC5zWVHPBekhR8N3I9/b4/1OQouXbZflo5u9GPYSjL jmtceGybq5vsdyZGgdAu1zj/+INjH+PcBSqNgNFRnWXZtutSTjUKaQRU135VUjNV5x8L LyzHUtvvgHjVIrzC9LM5ler3xrxEGrxtO6dVnjrGDAVIk8t9Al0SY0zjQ+ia5IHPgaXn YgtQ== X-Gm-Message-State: AOJu0YxHI7H4igNAIbuTq9qdb1Xl9rBAlAqd6QudrN9VRUAAFNpPOF8E BoAnXDicc/WWVpvjM2QB+fzj2RHWa7FGEEDEnFY3nBng4t5qd3GCX6cmcwblME7k20u9artFAEQ 0Db2FvdzUpRMsV+JhylX2MG9Oy+w= X-Gm-Gg: ASbGncsEf/HTNtChhURrXPFvgSSyJylPZThCzOyBbsthm1YNX0Zj9EizYYNksKQNpJW GEhDF+QSgMLDW6TpEVTu+VuKmaMcVznmMZwxYfzYHFh6jWHSia7LIkCRW+T0zI3TO1RG+vurdn0 tY+YRb/PjnxCNt5tGhILzEkjfa X-Google-Smtp-Source: AGHT+IHpVorJbLj+lp/RA2XdAp7lS92JgQIU7qK2nc6MjXrGmEfDoAeg4oy2sJ4w6aaLczlCy74cZdsQu2tB8gjPB+4= X-Received: by 2002:a05:6870:d201:b0:29d:c85f:bc8c with SMTP id 586e51a60fabf-2c69120b11emr7487788fac.36.1742223115584; Mon, 17 Mar 2025 07:51:55 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Luca Ferrari Date: Mon, 17 Mar 2025 15:51:19 +0100 X-Gm-Features: AQ5f1JowEvatEo-vIBNa34P5xsOQqPMTKeLaiCvngM9c-X2hu3ViuVMnRLV_-CM Message-ID: Subject: Re: Creating a new database on a different file system To: Ian Dauncey Cc: "pgsql-general@postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Mar 17, 2025 at 3:49=E2=80=AFPM Ian Dauncey wrote: > > We have created a few databases on the file system defined in the postgre= sql.conf, but now I would like to create another database within the same c= luster but on a different file system. > > Is this possible and if so, how do we go about it. create a tablespace on the filesystem you want to use, and then create the database adding the `WITH TABLESPACE` clause. See Luca