Content-Type: multipart/alternative;
 boundary="------------CDd5TZ0RTNugZ0PSyu0sBQk4"
Message-ID:
 <SN4P221MB06832A96CD534D5D78BA822AF71A2@SN4P221MB0683.NAMP221.PROD.OUTLOOK.COM>
Date: Tue, 30 Apr 2024 15:59:47 -0700
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
From: Senor Cervesa <frio_cervesa@hotmail.com>
Subject: Linked directory or explicit reference
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: SN4P221MB0683:EE_|SJ0P221MB1027:EE_
X-MS-Office365-Filtering-Correlation-Id: 32a331cd-870a-44c3-6338-08dc69693c2f
X-Microsoft-Antispam:
	BCL:0;ARA:14566002|461199019|3412199016|440099019|3430499023;
X-Microsoft-Antispam-Message-Info:
	SqIXEKlS7uVlgj6rqNhZxzfyQtX6Q7s6K66oLuArabuZjp2kzRBdxnfgnhogOT6NHzIafKbGlJt7bfW2B1G7r0TNj5oeYgItt29Za0WTW36khqBGWrOuWqXa4ZXdJu2J7y0jB9XsFflGblR1sIdT29Xo6jMTOhpoZEzd7IugJxa96hcZCDMOZAlJVwFQ5CtrPWtsDKkCFBOK96vDpGHCANC5QNe5HkGRIRkMJ+0DVIm/8TkFVPBBtTD8pz4ESbtY52GngT+Ym0hKF/ga4TOjFaGRb637RCswkXS+TsTxM8EkhSlH0fMFDSURQ9uFs5pKpWFzc0g1MIlKEjuWBLDgqpfQSESVPAl10804XwEZmd3trp2AiBeMIrDRJxcr13+9aGvH7AlW2F+l8EKIPX06/RWNmhlkkzbdSSQSqoHu8MnVdYN4vnULfNw9S9QvJMfebyd8NMmQ/8PPhxc4cBn6Axb6JbmmUfScZ0FOGMaYquegiH1pTUqME9Y1Vb+FcshdTecgY/lJMb+RHQ2e7KlcL9PxawT7E6PEkSj6T4SE6MHJheJfDx9YBARTQVjZAWrk
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?utf-8?B?ejBhOHNjQk5teElSdHJDN1VXZ21ad044OGNuNXF0akk4L2NraERiVTdFQktq?=
 =?utf-8?B?eW01YlRDUDBINUs3NitQeEI3MEZIZ1ZRRDF3OGJ6VmdxMk15ZXg5dklnbFFj?=
 =?utf-8?B?YjdHYm9UdFpsdHg1ZTc5eWpOWDFvQ2JvcmF1NkFkZWZPcnlQWVlnZnU0cXZX?=
 =?utf-8?B?VldVMngvT1Y1ZjZFdnB5OG5WRnhnN2hnZ1E0bGFDS1FoZWFzUVZJWkxLaUpU?=
 =?utf-8?B?Mi9SY2F2U2Zxd0RLKytjZnBkdzIwNkYyMkVOK1VIWkNlbjFQMU1COUtHbGNi?=
 =?utf-8?B?OUhieTI0ZHR5OE43SUQ3OUhCRlNENWlPa21xYjRQQnorWU4zb2hjMkdDVzNO?=
 =?utf-8?B?WEdsRVhQc3lEL2dSSk80bUgvR0xWdVN0UjNFbW5pTUN5WVBoYjNva0MrK2Jt?=
 =?utf-8?B?RWRTZVkrOUV1MWR0b3N1cGpGRWVMTldub0RvSDF4cFVJdnRqdTdyVGhORGJP?=
 =?utf-8?B?Vm5ES1FtRi9yRVJpM0hnV2cydHBqZ0tIY2wzbXRVelJaenlPb1duZ3JyUjEw?=
 =?utf-8?B?c0FNWlVGRGxoZG5vR2FueXdrR0dDaVFLMXV6M2wweXVwdlJJK2Jmb0lCUHRL?=
 =?utf-8?B?L2xyMDF1cVdTTmxabXpsMXZ5Q3R5SXBVSnhzR2NZY1EwNCtMR0tIakw2aFdw?=
 =?utf-8?B?bjNuSWRIeVQyY09zQXhSWHVxNXpWeXVUcWg2QlZNc0paNkhod0FlRmwwMDlt?=
 =?utf-8?B?NEY1SldySTBmOGgyd3VMalJVMU1YcG1vRzVPcW0yN2xwam04Yk5lNmorQ2ox?=
 =?utf-8?B?U1crc0wxQVRtVmJwbWt3SUpudzkzTnVPcHFkK09td3pDb2dNTTNrMUE1amx5?=
 =?utf-8?B?OXM5SFhma2ZUMlVBdXZ1T2JSR0Y2RTVveGVnZmprd1FDVGtpKzIwU3lQYWFP?=
 =?utf-8?B?UE1SWlpBK1J0SlRmTmpUSG43eTFDQ2NVem03OGFUREJMRitNMmhhY0N3akt6?=
 =?utf-8?B?UDBpakVmTno3STE5WDQvUS9MNy9jNnBGdlJqY1hNbEs4a2t1UWh4RFFCcC91?=
 =?utf-8?B?TlAwelVrMUVEUGwzNmlDUUZ4enJiTnhab1dkUFpxSzZPMjdubnlMUjRON05C?=
 =?utf-8?B?UTEySFJHc3FoV3lORnBYNzJSZjRlalBzS2s5TWdlQlFuMFhOYXZIOWltMldQ?=
 =?utf-8?B?OWRqaSt5NkZ0VjlET3YrdTlmdHpFenRsL2I3UmJyUzQ1cWdoWWZRSWt4ajFD?=
 =?utf-8?B?TGFsR0w2U1ZaenYxOHkvS3oyZkJiTU9NOWwrR2krSFh3aWdZYkFPOTdTN3Q5?=
 =?utf-8?B?NDhlai94RlEzU1E2OFNoWkR6cE9LM3BaNkpGY1Q4RGdoU25CMStVRlhmOHRM?=
 =?utf-8?B?cXlUTythbGQzOE0yZE9SdU81WVdhWGtQTURSODNEc0IycnRBdWdvaUJOVGFw?=
 =?utf-8?B?bG1oa1ZudlY4RGl4Wnk0RnNIWDM4eVJaaFRlbFM4UmNoaEtkZnlOQ2V6WGtG?=
 =?utf-8?B?WGprU2pBTlNQSWRIeTd0QTZqNUM4REZ5dlFoSDJDYXZzcXRpS2lQRkNaMUpG?=
 =?utf-8?B?c1lYNjkvdDJuemlOVXpZaVhvbmpBaXBsdVA1MW54ZnloMXdLVE5iMXlQVlZY?=
 =?utf-8?B?dFBkOTcvYUw2MGVkcDhYK3FrMFBWUk9EWWhTSEgvYks0Z2JNTFJRY3ZJR2hq?=
 =?utf-8?B?dm9rVTlVdE5aVlhrZmZaL3ZHZGRsSlJjOEw2NG9Mb1phZ3BWSzNBSTlqVy8v?=
 =?utf-8?B?SS9vdUd4L0h4alFwVk0vbFM0SzZaZVhUVTJ0WkcvMmdXS0RFQzAxbnBoem0w?=
 =?utf-8?Q?jaReHKOH4D6MaU23GCTkarMyPq5Z30jFFgMxLji?=
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-f5d03.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 32a331cd-870a-44c3-6338-08dc69693c2f
X-MS-Exchange-CrossTenant-AuthSource: SN4P221MB0683.NAMP221.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 30 Apr 2024 22:59:48.4013
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg:
	00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0P221MB1027
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/SN4P221MB06832A96CD534D5D78BA822AF71A2%40SN4P221MB0683.NAMP221.PROD.OUTLOOK.COM>
Precedence: bulk

--------------CDd5TZ0RTNugZ0PSyu0sBQk4
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi All;

When doing an initial install of PostgreSQL on RHEL 7 or 8 derived OS 
via rpm, what are pros, cons and recommendations of these 2 procedures 
for utilizing a second disk?

Secondary SSD or RAID mounted at /disk2.

Option #1

 1. install the rpm which creates basic user and home
 2. Create symlink /var/lib/pgsql/15/data --> /disk2/data
 3. initdb with no special options

Or Option #2

 1. install the rpm which creates basic user and home
 2. initdb with --pgdata=/disk2/data
    Probably using included 'postgresql-12-setup' script

I also link /var/lib/pgsql/data  --> ../15/data so automation can 
reference postgresql.conf without knowing version (legacy stuff).

The install is automated with a bash script which handles several 
options including whether there is a second disk for DB. Scripting the 
install with or without the second disk is straight forward but I'm 
concerned with either scenario causing unforeseen differences.

I don't think there's a benefit to using tablespace here but I have no 
experience with it. The systemd service is configured with a dependency 
on the disk mount so I don't think there are different risks for 
starting postgres with missing data directory.

I've run postgres in both scenarios and not had any issues. I'm 
interested in comments from others on their experience using these or 
other options.

Thanks,

Senor

--------------CDd5TZ0RTNugZ0PSyu0sBQk4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body>
    <p>Hi All;</p>
    <p>When doing an initial install of PostgreSQL on RHEL 7 or 8
      derived OS via rpm, what are pros, cons and recommendations of
      these 2 procedures for utilizing a second disk?</p>
    <p>Secondary SSD or RAID mounted at /disk2.</p>
    <p>Option #1<br>
    </p>
    <ol>
      <li>install the rpm which creates basic user and home</li>
      <li>Create symlink /var/lib/pgsql/15/data --&gt; /disk2/data</li>
      <li>initdb with no special options</li>
    </ol>
    <p>Or Option #2<br>
    </p>
    <ol>
      <li>install the rpm which creates basic user and home</li>
      <li>initdb with --pgdata=/disk2/data<br>
        Probably using included 'postgresql-12-setup' script</li>
    </ol>
    <p>I also link /var/lib/pgsql/data&nbsp; --&gt; ../15/data so automation
      can reference postgresql.conf without knowing version (legacy
      stuff). <br>
    </p>
    <p>The install is automated with a bash script which handles several
      options including whether there is a second disk for DB. Scripting
      the install with or without the second disk is straight forward
      but I'm concerned with either scenario causing unforeseen
      differences.<br>
    </p>
    <p>I don't think there's a benefit to using tablespace here but I
      have no experience with it. The systemd service is configured with
      a dependency on the disk mount so I don't think there are
      different risks for starting postgres with missing data directory.</p>
    <p>I've run postgres in both scenarios and not had any issues. I'm
      interested in comments from others on their experience using these
      or other options. <br>
    </p>
    <p>Thanks,</p>
    <p>Senor<br>
    </p>
  </body>
</html>

--------------CDd5TZ0RTNugZ0PSyu0sBQk4--