From: Ian Dauncey <Ian.Dauncey@bankzero.co.za>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Creating a new database on a different file system
Thread-Topic: Creating a new database on a different file system
Thread-Index: AduXS5stYH/XIFysRFeiagoeg1lbKw==
Date: Mon, 17 Mar 2025 14:48:42 +0000
Message-ID:
 <AS8PR08MB829778001E6F10552A6C4CEBC0DF2@AS8PR08MB8297.eurprd08.prod.outlook.com>
Accept-Language: en-ZA, en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?LAQ7xsmAdm22XoyTq3/LMP58NVEIXDTO6mdtOu6tTsNQ/ihk1DDVmrD9BOcy?=
 =?us-ascii?Q?BcUDCwcr4wcwdPUSj386ZHZbaRI6ei4E0GhDUWC98krQO8nNYIsQu4bjWixj?=
 =?us-ascii?Q?Fxbogei4ORPCGOuH+PVnYrt/ssbei1rxPLNFMmzZzX36kdfiy2E00eNn3G+P?=
 =?us-ascii?Q?amGzBwbik53CgLef/BJcYQL6BbU9kdOagavwS0xLhpZYIBjSNX4Qxh0a7w1g?=
 =?us-ascii?Q?SuV97B77TClWVboIFXMsiSbAlTH2jvKcJd0Bm9eoNlkJlWbDUYW7R0sLMnrj?=
 =?us-ascii?Q?nqqQE/79Xa5Hy4GCJ5dpQIIi8J6M/NRBYECPN1oAOHb/TrSSOlV5w+tds5Q4?=
 =?us-ascii?Q?lTcMKOCt8f6YA93jjou9Im64UqHwR2YCCPWUYt1EnjUWNUvbjLTrYq5fSOTx?=
 =?us-ascii?Q?+wtZW+FrtzI56sXNVoIz0+XAByXtStN5zywWxuiHn5DhSyWo2ghDQ8vcwCsd?=
 =?us-ascii?Q?7D9tIf3JT35BkiGUON11116zrruOLBRbqjG6Bk0PhNChB33Z17ix2g7C2dSZ?=
 =?us-ascii?Q?jWR6tATae3Blw9OBShnHuejHsyfJ44wBORn6ewrEPkxGIO4cskvrTWHN+tJW?=
 =?us-ascii?Q?NXVoo63jCcLdBk+nTqDDpGIGAKAMTREI1v7W78/RnxiuA/E5ORDX5nmCEH+G?=
 =?us-ascii?Q?fdL6QaSO724YsA78nWh25AxidTe2DY3AXeeVPakOE7Umcm4CSXUv6EWMrCfd?=
 =?us-ascii?Q?RrG+FnqM3jQhSD953fcqtyRugQ/zuCWHlCopRj7r80WZSsZXEjpupJsO9CTl?=
 =?us-ascii?Q?5aps4AulkDg848o5oN6gthyhZvPo/kuG7KuKAlFVH9fYlFXtQG5ZWxIAHPi8?=
 =?us-ascii?Q?o5Uf70cb/wLo0aAMvU/gnPD+oPg/2MWwOUYMK5m1TKWyiPbFf9j9n59eHgBb?=
 =?us-ascii?Q?t+HGURNjJKjci53W4XcTDXDokW/ElJ/anZPH2NtvuVvPhfL8/C7P5/GZKngR?=
 =?us-ascii?Q?zhvZzzITgtvEhFYLyrz8QlTeo+STb6yx7oIP8h8lKMI1+8uxriBNszqBVcvA?=
 =?us-ascii?Q?cT2yLf2JtrAXVuRiVDRw64ATNkMWxXo4fTj/TrrXveTrwPOzfq0oHDQ8loSt?=
 =?us-ascii?Q?NZXJnaGXkjoj25jV9V4KEg2iw5C98sfI9yjG52GVnYzmN+cJ2GDQeE7UMrbi?=
 =?us-ascii?Q?Y1ZREF1HRZVULm3h8aQPed45gpbPtMaQ187PM9E0Kd6R4mQWMXiw9Xkyr+b0?=
 =?us-ascii?Q?E2nxkDwSDveRVMbvs89RMtSV0RVl5sKo8nMhOt7clsnwJX4w4L19pHzxBeu2?=
 =?us-ascii?Q?euNpLPykm6bRTIKlEC7wD0ol5zF1z/sAZ1cK74D3ph5vCDGACEzQoVZcEvCl?=
 =?us-ascii?Q?YeZi7KoWyszRkZyndxBYN1IZMbaPm5IaN+7qKkfBwebhPzacHQ7C5T1uA5Us?=
 =?us-ascii?Q?I/+Q7uNlI2Ef87GuJH6Pt5vHbLXTDUDpXZLKqwDzcCX3f5IixiuQhSGhSlGr?=
 =?us-ascii?Q?6eNIFYOt4Z9C8lMJmIsDHDlHuVas3v9BhsuO0M3v3rw09riSOk1Pgn9CFy7L?=
 =?us-ascii?Q?eXutUoCozSWGYEz3QnACwNtI3guVCHVWr/wqI/tc46yRMTB9F2TcYYyjo+QX?=
 =?us-ascii?Q?Kc114NpxXgZ94umulA3xEXMjfzngogg3F1QsMF/CQ2hJyHg6NkwvKRgK/kPE?=
 =?us-ascii?Q?pA=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_AS8PR08MB829778001E6F10552A6C4CEBC0DF2AS8PR08MB8297eurp_"
MIME-Version: 1.0
X-OriginatorOrg: bankzero.co.za
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AS8PR08MB8297.eurprd08.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: ad36d87a-2cb0-4502-64c4-08dd6562cfe1
X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Mar 2025 14:48:42.5225
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: bd2d5c14-230b-4af6-acff-ed4bb79a3efc
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: XbSs71JzdWHZdYuU9bYEp6vepJHtOvYZGIjtGYQvYP//MjLQxU6WzECi4AA1dz7a8FPOxosIDgthEhqfgfY3U6bstqKNIJr054spiExPxHo=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB9PR08MB8483
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/AS8PR08MB829778001E6F10552A6C4CEBC0DF2%40AS8PR08MB8297.eurprd08.prod.outlook.com>
Precedence: bulk

--_000_AS8PR08MB829778001E6F10552A6C4CEBC0DF2AS8PR08MB8297eurp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi All

We are running an old version of PostgreSQL on a Linux Server.
We have created a few databases on the file system defined in the postgresq=
l.conf, but now I would like to create another database within the same clu=
ster but on a different file system.
Is this possible and if so, how do we go about it.

In a nutshell:

I have the following statement defined in the postgresql.conf file - data_d=
irectory =3D '/opt/pgdata_postgres'

I have created the following database datadb1, datadb2 (plus all default da=
tabases)

Now I want to create a third database datadb3, but it needs to be created o=
n file system "/opt/pgdata1_postgres"  and not on '/opt/pgdata_postgres'

Is this possible

Regards
Ian


--_000_AS8PR08MB829778001E6F10552A6C4CEBC0DF2AS8PR08MB8297eurp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-fareast-language:EN-US;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;
	mso-ligatures:none;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-ZA" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US">Hi All<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">We are running an old version o=
f PostgreSQL on a Linux Server.
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">We have created a few databases=
 on the file system defined in the postgresql.conf, but now I would like to=
 create another database within the same cluster but on a different file sy=
stem.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Is this possible and if so, how=
 do we go about it.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">In a nutshell:<o:p></o:p></span=
></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">I have the following statement =
defined in the postgresql.conf file - data_directory =3D '/opt/pgdata_postg=
res'<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">I have created the following da=
tabase datadb1, datadb2 (plus all default databases)<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Now I want to create a third da=
tabase datadb3, but it needs to be created on file system &#8220;/opt/pgdat=
a1_postgres&#8221; &nbsp;and not on &#8216;/opt/pgdata_postgres'<o:p></o:p>=
</span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Is this possible<o:p></o:p></sp=
an></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Regards<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Ian<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
</div>
</body>
</html>

--_000_AS8PR08MB829778001E6F10552A6C4CEBC0DF2AS8PR08MB8297eurp_--