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.96) (envelope-from ) id 1vpVJT-009yip-2Y for pgsql-novice@arkaria.postgresql.org; Mon, 09 Feb 2026 17:44:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpVJS-00BtdV-2u for pgsql-novice@arkaria.postgresql.org; Mon, 09 Feb 2026 17:44:42 +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.96) (envelope-from ) id 1vpVJS-00BtdK-22 for pgsql-novice@lists.postgresql.org; Mon, 09 Feb 2026 17:44:42 +0000 Received: from mail-oa1-x35.google.com ([2001:4860:4864:20::35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vpVJQ-00000001qvF-2Sfc for pgsql-novice@lists.postgresql.org; Mon, 09 Feb 2026 17:44:42 +0000 Received: by mail-oa1-x35.google.com with SMTP id 586e51a60fabf-40974bf7781so3322365fac.0 for ; Mon, 09 Feb 2026 09:44:40 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770659079; cv=none; d=google.com; s=arc-20240605; b=ZF21SZ7KVE/KknTgbawzVHpIZkwqXd5PHL6Zx+JjsWXU5MMybzzF7J0MvDuXYPw38m 0bEebtg0bRPJUaTlBaTguV4mJCzikgxFIJfDL2PlJ634A/KvSVYHamhoe0Sa9kSOgJ6W u3/clGEjJAdZonorfau61uVvAO4kEbq1yUCVj/PKMqs2eRIvu75dQ2Lfb4c9iyPDgdxQ WmyQBlfk6WC2QyYoES882iB/jU56PbZLkKCTlE83NsoOz0VtuHUKWWDvrMnzfdZWjiGx KiISujTdfdntGwLsootnLlxd8M6HWwrM5a3WkfjXlt/IFfedRCayRTJ9pCc9dMjpPGQJ /QtA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=tvqj6uWoZktYn0a/AvKZOzUjrXiryxO3AK/YEglM4Kg=; fh=4YP8/ObuFdNE7FLzoa2GUFMCmfYVDd3/chevNTaOUVE=; b=j1diQLYKi2CgnHAgPgmqEx4xksIcunyy1tOPHfY7FymPbPsg93g8bjOsKAZ7569t7x zhRM3hPcLncFTDzL3myAzDyvwxCEC/1RI1tD99N4KS5jnZMDVgKZ0vp8vBbHsGDbEQax vMEijcEHYSxIKld2SeAE87IXd5h0okZYsquddxoXPc+5oa6CQazi0IRavhCWaoB8jO4n jVwvUCoWK9bMLhXhZ0VNsgoc1Qyc0ugGq2QcSQNQzRJlNKCUwnbRW/I0fi+naPjuece3 Cf6weiWmacV/9hU4OVIsao+u9N5Oi5PeF7ZC4UquQ0cY5fw8+C+eIDPzCR8g0SWX9+r3 MVhw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1770659079; x=1771263879; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=tvqj6uWoZktYn0a/AvKZOzUjrXiryxO3AK/YEglM4Kg=; b=TsUBKeIqi8Syp2YIIHkpDxQBTC5KB+9uH8DXi7jj9YtNzm93oJz1A7A3TXYnOBhLE4 5jAaRjAb7hsmgASamEOdKqNK1VsADicTrzpbW85FBWR7RwYQw1fNItv0DCe7iJwdnDVp /VGisGvZq8Zp0jEAowyMVEq/sJXjmc17+CeP822Kg0oJf6vSDu6D0cWQ+erPoItM1RZ1 Q1b7nDW+t4AE5s+T/FwGKUCccNf5e4Ud64HYylPBSCb38KdWCIZEJF0WjE5yARTp4WYo p/H0BXMztismnjz5AeX9jcJ8Y0UWjyr+xN+Z4L8X00LfrvJMOkSnWmeJzkMw7Y9zKbll zBZw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770659079; x=1771263879; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=tvqj6uWoZktYn0a/AvKZOzUjrXiryxO3AK/YEglM4Kg=; b=qOPTB2FXoZg+KsNNLKiWmVuQPCQb8n5ncEkStBDqkYOKF70NFgHosTQIYI3QcexxRR +eqPLbfNm7a3DEhrm3MlLOgS0z/ofpxMt+6wDbvRbuMbFHFyNNLzFJWzLMS2TRfnAfIa 2r+4DEK3ww+ppuCVwQ5r+pCGes6tc0aqiFUSdVXHVcX/5K0TsyPFJC+CT49JQPhjeiNG eNKiJQo1ua92cm2s6fFKG+3bJwtE1WtG4thl7AI1wQ0hWOBa8/ZnpSEXFDAVwDfh5nn8 Sd+GXmVVXWn83M19q152oDTw425aeQDmm84wiIlLMor2zC5gmGX2lJMLrep6DKfgOAeW gBGw== X-Gm-Message-State: AOJu0Yw6JcHwqi6P7UuEweNdfSE/42o6cZ+JW82/TEKvREr7XGKsRwrb i2ceU4dbaqhGFiZ9gy7ALUlkmmLzAl/l3o1Qhqs7pJdUxPRkJNoA/87zAY6x2zePAI7V2/Q+fkh F3tt9zW33CnmK6zsQhdKkGpkeIVAiZz8= X-Gm-Gg: AZuq6aLvYFbLzJ93L8m1Q8PJDk7rhALIzNnrVxxxoVPMdNPUY5DvhJ5Zr2XAZAamKMp sfNiIovhilKIzcglxQrKhcwrAFBrZVLSE8hbtHUMYmYWHVDWCPYm3xvmxcrivt3hmY3oCanpVm6 cmoR8GuS4spH/ZcBPOR2e4d1Q50eHOPJ/TepLeczwrT0QbHDHUPJidVjUZcTWaycbVa5FXzyoM5 fZs/Ii7PgScU59qlKGb8Jro4e3ua1+JLtHD57ec5l8zFAUXqgNDcWd2wmzf5rBSHSltxFlj/NQ8 BGslOEHbMDOYr9Do3NjQ5jt5pLdRAg== X-Received: by 2002:a05:6820:210b:b0:66a:85f1:4617 with SMTP id 006d021491bc7-672af47afc8mr116170eaf.18.1770659078679; Mon, 09 Feb 2026 09:44:38 -0800 (PST) MIME-Version: 1.0 References: <76ab7592d45d47898d1a8e7bf0edd5ad@alte-leipziger.de> In-Reply-To: <76ab7592d45d47898d1a8e7bf0edd5ad@alte-leipziger.de> From: Greg Sabino Mullane Date: Mon, 9 Feb 2026 12:44:02 -0500 X-Gm-Features: AZwV_Qih6baaIUPK3NGIW_GjXpq6fwhlfCwZ6wU9tYMWcRj4GMYEpjo4gYIUQIY Message-ID: Subject: Re: 5 Instances in one box -- Postgresql.conf Archive Log command To: "Subramanian,Ramachandran" Cc: "pgsql-novice@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000067311e064a67b132" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000067311e064a67b132 Content-Type: text/plain; charset="UTF-8" You cannot do that natively with Postgres. However, one solution would be to make the archive_command into a separate file, that the main postgresql.conf includes. Then you can keep copying the postgresql.conf but keep the archive_command separate and unique. The syntax is include = 'myserver.conf' And then the myserver.conf would contain things specific to each server, e.g. archive_command = 'test ! -f /archives/INST3/%f && cp %p /archives/INST3/%f' cluster_name = 'inst3' Cheers, Greg --00000000000067311e064a67b132 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
You cannot do that natively with Postgres. However, one so= lution would be to make the archive_command into a separate file, that the = main postgresql.conf includes. Then you can keep copying the postgresql.con= f but keep the archive_command separate and unique. The syntax is

i= nclude =3D 'myserver.conf'

And then the myserver.conf would = contain things specific to each server, e.g.

archive_command =3D = 9;test ! -f /archives/INST3/%f && cp %p /archives/INST3/%f'cluster_name =3D 'inst3'


Cheers,
Greg
--00000000000067311e064a67b132--