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 1sjora-004MMo-VS for pgsql-admin@arkaria.postgresql.org; Thu, 29 Aug 2024 23:47:38 +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 1sjorZ-009nkS-2y for pgsql-admin@arkaria.postgresql.org; Thu, 29 Aug 2024 23:47:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjorY-009neE-N6 for pgsql-admin@lists.postgresql.org; Thu, 29 Aug 2024 23:47:37 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjorW-0025cP-H7 for pgsql-admin@lists.postgresql.org; Thu, 29 Aug 2024 23:47:35 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 6401E62DE4; Thu, 29 Aug 2024 23:47:33 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1724975253; bh=r8pzVdSMKImenSaPxYJniAOodvkAU2+ESdS3H3akBlQ=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=CJ4yHmYbFkjuEaTUFgX779/o5DySWiyBCFZZX8ftbAD8Br5VRUCaZhyB9iMWbGbHR VYDoQkz6xRPOCXVdnwPjJ+LYv5CzBJ9Pbclwt+qUcAL6sExVIXz67n0oUEbSxqOso+ vuIT5Oi4RSc6gQhZyXWEasgc33EhgH9cR5d7Wo0fxvUiP9Qhx1dnz5vsuUSzD0Bl5r B463k4krjCWJErjMW2h21CETpVERQ7MDYEA6451r/ZwPQA714lNq69XDVN7zuPBToT 2xbMabWtvet48Hj5AgviQApF86nYMI2XVg/RVDs7OqUZhqIm6om4p8IylYewYsTYBv bgrQmsVtofDdA== X-Virus-Scanned: Debian amavisd-new at emo07-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo07-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id MrJ2Zjv_Sg7z; Thu, 29 Aug 2024 23:47:33 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id CC97862D9F; Thu, 29 Aug 2024 23:47:32 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1724975252; bh=r8pzVdSMKImenSaPxYJniAOodvkAU2+ESdS3H3akBlQ=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=W3H0FjOeZ4p6IcsRnY4Rm60rspQr7T7j5fNrL2iJi5F6nSiGJUmgabj0Fcu+yM7/9 cQgeO+2eYHJskM46mbzDVkTQQOGyNwTQLz2xiEfuh+GzZVjz+xyEBoxPKEiDCehyVG JGPMOx1vDLgd5AYEm/dy6038/ls4zpuKmU79T8xChTuPEBL8umbpEXQYv14mGZPEXc 2i+K2voyVdEOCOad263jL2Lb9nb4FAkp8y642/UNoOUBhT/fhiB22enby6/YazxKcp qqtZZHLbIjcqVeLf8aq+cWE+28tEBDL8BldqV2LlVxIVJ8Qw4OhEe+uPFQK+c73ec4 KAXQsG6+4p1iA== Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\)) Subject: Re: Alternate Datafile Location From: Scott Ribe In-Reply-To: Date: Thu, 29 Aug 2024 17:47:22 -0600 Cc: Pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: <27AD65D0-857C-440A-B2B3-CACD8BE12BD0@elevated-dev.com> References: To: Sam Stearns X-Mailer: Apple Mail (2.3776.700.51) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk You should take a step back and read the basic documentation on PG = administration. For instance: = https://www.postgresql.org/docs/16/creating-cluster.html We (at least I) have been assuming that you wanted to create a new = database cluster, to run a server against that storage, using initdb. = Using an already running server to put data elsewhere, using createdb is = different, and requires that you create a tablespace first: = https://www.postgresql.org/docs/16/manage-ag-tablespaces.html