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 1rxRRX-008fRx-6R for pgsql-admin@arkaria.postgresql.org; Thu, 18 Apr 2024 13:04:47 +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 1rxRRV-004c2T-QG for pgsql-admin@arkaria.postgresql.org; Thu, 18 Apr 2024 13:04:45 +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 1rxRRV-004c0D-7q for pgsql-admin@lists.postgresql.org; Thu, 18 Apr 2024 13:04:45 +0000 Received: from mail-vi1eur05on20700.outbound.protection.outlook.com ([2a01:111:f403:2613::700] helo=EUR05-VI1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rxRRO-003SEt-H3 for pgsql-admin@lists.postgresql.org; Thu, 18 Apr 2024 13:04:43 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=agpuqLtEk0PhQthMq4kbWQUrWyqBudIrhM1oMIWxKR7gtaQ/0H/7eca28LfCCzZIWiIn+T2Ik3yQdJyi3BKi3rboDsAs6JdH2k/OjVaqMVEbKcWOLQKFJDKEkNKklTyX3l6u00ApFFDCgYvp+fvW00qPyqAQE07MlvLdhYnto8JZVEqG4S0rBGe0JkpHRddWW6h+Zj32DWf64w23S26/6GyqVSnkPfIcQ26IYLuWkCubclclL63L7id22hMjXy/36GVvyZy9C0YMjgJSKLJzDzZGXEUNT9N8t+HsPvlOLm16igqZnOFmdaxGHuPxwWNV10Qxy8xNNXc6XJ8L6o18sA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=K/6n5dZQeQ3GmZuzN/JgrTu8V2MvOvN80agNEZCkxTs=; b=Wj5vUSxvXsg1TK2RN3Ks0XPvsiSOmyhegFY4aBtjIEboeeoEOundlJknxGIBQ/S9vdXJP3WAUSLLNpZsuAxyfkynZVhYpxz+u/ap3eg3TZ+KKXrszQ6qtj/JN5nC1F/80FCfa4pOufmLQEOAZGsvVR1BKvcAQeS3CkcTsXJXgjXoZf/0OZcDWAldLcU40saFRpL8RsCk59QeTd3g5Yf3P9Un8o5DcWQUgJ44/R9WX31765WMNlFcJ/QtDL8lb0yI2b0PJ6G9jplYN6+4CpOSLKZ/eSBSqvM//xnItasPqxnJMhBSkxQjrBBRRYqMujOG9X1h5H3CkGIQHWFCuwN9Lw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=pragmaticplay.com; dmarc=pass action=none header.from=pragmaticplay.com; dkim=pass header.d=pragmaticplay.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pragmaticplay.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=K/6n5dZQeQ3GmZuzN/JgrTu8V2MvOvN80agNEZCkxTs=; b=XnmLTZStjrIrBb4tCLjbB5CwyUxp+HT85yQo+SVFf5JwvPcvemazv7rGLaUiMQm2dyp5sD1QnQDV843xRnogfd7k3JBR47L+ZpdgsrE75873qsJU8VcGCvaospN0XnPknv/n0MSTkVM2Lah664ckj8OSu33Wv+OccvrmOTnEGuM= Received: from AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:20b:4ff::19) by DB8PR10MB3768.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:10:148::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7452.50; Thu, 18 Apr 2024 13:04:33 +0000 Received: from AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM ([fe80::6109:706a:b5f8:c0cc]) by AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM ([fe80::6109:706a:b5f8:c0cc%4]) with mapi id 15.20.7472.037; Thu, 18 Apr 2024 13:04:33 +0000 From: Phani Prathyush Somayajula To: "pgsql-admin@lists.postgresql.org" Subject: Different Data Directories For Different Databases In One Instance Thread-Topic: Different Data Directories For Different Databases In One Instance Thread-Index: AQHakZD0Y/Kjfs60WkSi7HpDVZCBtA== Date: Thu, 18 Apr 2024 13:04:32 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US, en-GB Content-Language: en-US X-Mentions: pgsql-admin@lists.postgresql.org X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=pragmaticplay.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AS4PR10MB5545:EE_|DB8PR10MB3768:EE_ x-ms-office365-filtering-correlation-id: 7e381f5a-9773-4c56-0e3b-08dc5fa81753 x-ms-exchange-atpmessageproperties: SA x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: y98EcQOnK1ueAdMMllUnj6PbJBzpQHRwfulWsr9Q9R3soOIXYH8EeT8hZrOgJMmCQESlk/KK7ZTGL35WNH7HP6+s33JIYlQTceco4qvUqObos80ssRxkhGEfgMjya9PrD48ruCL+dvUmEGQrELDS2vUVrVQE/eORE5j7oB+izdHeJv93hb+O/KMF9LSMPhSBNlml2zHosBiRWnPh+9JFni4gGTx7+eXJhdSgOdSvnDWel51Pxhf2ahdoBjISTVRGeb/aplvYgl52edADr27qPZOV6C+5+HCAE8ufi7oPeLkY2S+Ov8SUMYLg4hcJWxXmoSyJTHpeS2jNC35sfzGtqLzIwTfvjk1BzLGSBNQYfSTvFTt4hA935X9YLnRKQbVnfAj49Me3Gbk1BengQXCUy4kzghHgUWmcU/yyJdzHGih23KB+Y/NbGpoZ6DQUUrVf/oMzQbx0HHP0fJicgnddzFwIUB4OMVV7fAQSZllaPYb+kvfAP6KpcmBaOhv73YtajITPb6+ysJ44guljTG5ie7FdRP5QbEY2R9YUKqJM/PpBZutE2/3BSpzU2lnUObm6g1iAHxNzUErkQq4L1zpHGlcQiuDJWo4hwp0Jhf2MhCRlgp6Nzk1ouYipITbZtbX7hKaIditH8pKo/rwRgM81a8oA4CIT4hvXVZ4ueuJzwICS9RSmMYz+5/HgbC2ZYkTXHFXmhOcSh1A8yHMU1tw3irnpuezkLz6Xke1/6OyEmcE= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230031)(376005)(366007)(1800799015)(38070700009);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?SZdKgRziub93S1M1KQ3GSFuDHp+Sp5IA8GFUmHn66OFjC6cH33y+y7UkLVrM?= =?us-ascii?Q?JpuqfAWEppVN3TybY4oDDQtJzsyeiyAumc+Am3oZHfRTXagAMtb80IqW+DjW?= =?us-ascii?Q?PcUQ37SroiKPELezRChBK7Lbll/tnz0GQw5hZr0CoaTT6tBhGSoa89TxFI2a?= =?us-ascii?Q?HZ+0+NAzrn6aiGvy8ShOxRddlJ19NoIGFfNheFLaO6/kMT1K5HW1QxzHwoP9?= =?us-ascii?Q?Euw7znrcbSBimPej0VSZyfCCyC4hyGQ/I4EpiBk+xEh7Usb/17/FA47QD0J6?= =?us-ascii?Q?40AFtRjH48bou49RMVoSYblI969IR5itkwJerJlmBk5i90dklqY+gTLXcg8K?= =?us-ascii?Q?zt+avaKIeIXBGuzsqtLABmEBN858wAiaHcmTO12gPKY46HQjhr3E85NEfJ6B?= =?us-ascii?Q?iIOeg8uKR0jthlVvC+1fhfvmTnTfTEMSH/ajvZp0SuTzfV8p2B6DE27cmp8D?= =?us-ascii?Q?d/57a8vkGlRD7Bnbpxr1d1hy57NCtLeG3OEXfTRTqq0S52ba6rxZlIc9Nyjc?= =?us-ascii?Q?pnVcmfOcJvg64yFR1ca6w4EwvHEYuSdMUvR3BDzcIH0oK5IzymyVl7B2O2ji?= =?us-ascii?Q?qUcdnrk8ziF1eUTN48ebTAIBAfg1h0wE++ZZ1i5Uk6UrCWnGovUJlk9YL1CS?= =?us-ascii?Q?FMHwgDAVGrdDmZrM49Xw9OLeG3fXA9xA0f8uUM4oKtAStGBfF5dhD8GJZoNc?= =?us-ascii?Q?jtxvQNcGHNl7EdNt/wmWX2zc/nUy55g4t9jqRMJt7VRovl/k0d0cymdaV9JR?= =?us-ascii?Q?JLlOiDpT+hJRHw6Vokng9JuF6adqhCiZXa010IfGDMKBG7aFPWKwo+AAxfAF?= =?us-ascii?Q?n2BRAh5AnCFk5ccCy5be06k8B10RocUJQL+M/9rPsZyBEOm+st197+ilNQmM?= =?us-ascii?Q?Y6GYf6+QjzgHtsdiu3cRKU62ZBPRupyepRjxov/5t2jG3VBUAm2WAuZTIQII?= =?us-ascii?Q?TedHaVeJB0Ks6utWddGgtFtXopFsOaAaCnDIjy/E7tZNtLKQUbECdfJepN6W?= =?us-ascii?Q?BDYhh538Jh1iiwN/JJdulhdtUDXjx+vpmMof2YhrOiBMJkzs8jgjSjxjUu6U?= =?us-ascii?Q?+QAhb8t72BhSL5mSpSUd2xVgdRULmCN0T9hGOgbZ9pfFWNB7xKGDExntKUIz?= =?us-ascii?Q?RWhpEnG/nGyPR2q+FelUyPMVGzudNDZJxaUn5W+apDJFffeNMwil0qPMjlJv?= =?us-ascii?Q?Cma4D+Ghi8ME+eiRj1Gv0NPe1FLkG6INg2pk+nRd9oyH8RvXCnq1UfvtXaq3?= =?us-ascii?Q?1Lhh5XH+b0MAyB/bmKlsqS9nBcSI16oNyff266PgHFzAkxnj7Nq55f8TmilS?= =?us-ascii?Q?i1E++kfehRrCN0SDbmYPbX3gqcCOx8vZW4/pisukecgNce9nr8JDXyAnbaRL?= =?us-ascii?Q?zn2Ak9kfuojCeTvDi6Az3U06xoO1cEQmtaSIrVJZsDpdZhDG5pws0hZh+LNE?= =?us-ascii?Q?lR+Lt5VEOicqoQo50ebXO8pINhA41fU6E7OM7eCf540it53xO855/BESZqHL?= =?us-ascii?Q?3o9O9kct2NMZeMrmNK1B5IdDxjJskyjKVutbbnOPFbP1YO52880DFlwT0ShE?= =?us-ascii?Q?hovKdCryf3wOQ69RF4GdSW5MQQ1jcLIgvOrlNXt5LVJaBEme9DlDSSJ0JSKS?= =?us-ascii?Q?mw=3D=3D?= Content-Type: multipart/alternative; boundary="_000_AS4PR10MB55453EC83E81241722755F8E8D0E2AS4PR10MB5545EURP_" MIME-Version: 1.0 X-OriginatorOrg: pragmaticplay.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 7e381f5a-9773-4c56-0e3b-08dc5fa81753 X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Apr 2024 13:04:33.0106 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 214f6519-cd19-4726-a221-b70378e889f6 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: fPKkFq0wfypEP1hC3OP8aFpgyXkYIX4RNFKJYkDGP/NYmfI58hTaRQwIhhEhn4/YjPQ6YHhVPu5XwHqmOyc7mrDWVMMK8DwKgaBauBPsu//m+4Xv7XhmcqzY8rIab0kS X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB8PR10MB3768 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AS4PR10MB55453EC83E81241722755F8E8D0E2AS4PR10MB5545EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi @pgsql-admin@lists.postgresql.org , I have 2 mounts /data/feed & /data/bets I have postgres-dev server on which I have 6 feed databases (let's say a,b,= c,d,e,f) and 4 bets databases(lets say g,h,i,j) I want to group the data directories based on the databases, and they all s= hould be running from the same instance. Can I achieve this ? Or if not, can you suggest me a work-around to achieve this Regards, Phani --_000_AS4PR10MB55453EC83E81241722755F8E8D0E2AS4PR10MB5545EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi @pgsql-admin@lists.postgresql.org ,

 =

I have 2 mounts /data/fe= ed  & /data/bets

I have postgres-dev server on which I have 6 feed databases (let’s sa= y a,b,c,d,e,f) and 4 bets databases(lets say g,h,i,j)

I want to group the data directories based on the databases, and they all s= hould be running from the same instance. Can I achieve this ?

 =

Or if not, can you sugge= st me a work-around to achieve this

 =

Regards,

Phani

 

--_000_AS4PR10MB55453EC83E81241722755F8E8D0E2AS4PR10MB5545EURP_--