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 1vpNfp-0071L8-3D for pgsql-novice@arkaria.postgresql.org; Mon, 09 Feb 2026 09:35:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpNfo-009w4o-2V for pgsql-novice@arkaria.postgresql.org; Mon, 09 Feb 2026 09:35:16 +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 1vpNfo-009w4f-1O for pgsql-novice@lists.postgresql.org; Mon, 09 Feb 2026 09:35:16 +0000 Received: from mx2.alte-leipziger.de ([91.217.145.232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vpNfl-00000001nAX-3RFS for pgsql-novice@lists.postgresql.org; Mon, 09 Feb 2026 09:35:15 +0000 X-CSE-ConnectionGUID: dJV9qM+jRJuvqotPSFWNmA== X-CSE-MsgGUID: +ICCiAxmT1KAqHWMXFvqOw== From: "Subramanian,Ramachandran" To: "pgsql-novice@lists.postgresql.org" Subject: 5 Instances in one box -- Postgresql.conf Archive Log command Thread-Topic: 5 Instances in one box -- Postgresql.conf Archive Log command Thread-Index: AdyZpNBrhMItK/I1Q7CsEPp/8zaNiA== Date: Mon, 9 Feb 2026 09:35:06 +0000 Message-ID: <76ab7592d45d47898d1a8e7bf0edd5ad@alte-leipziger.de> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: FWxETXsSM3xYeyKPh6eygbbW4WOZNAUnj5XD/cFEQwaQ+UeH24Dz4Lhu upHpXEmLU2VRnkEujdpjybcuQlsAB7ipA0mFNtPDyGyaQXOvRx4pihtGF1HQYaINgcEzNI9jZFU 1OAyYdMNZjJ97HVOvx69eyMYvo72fqd+JFy8QGHUWd/c/Vdyl4FYSmaIHbAjb4gefAI4RchDFaz jVQn9Pb52/Ne0U3SXyNFs7YV/tEcOJC0yZ/aK3eHJQ4iSW3mrLknrbkTKZciVtHi50HpNI6KsI9 mq7U+4DY/3vW79UefV+WoeMTK4mDEaVkBBw2GtvTrdOFVVqaikYmSsnQ/0sxP/cMgrTjbBkO80P nvMDYjBsEFhlN5oHl2U+lBkL8eY5A6J7qwYXtBJsia8QaseTQgBp3lNjHmGE1E91lXfjblmThHl keYcGbwLLrg8wUk+AC4F2niBR3WVRDXuVukG9L6Ywk+e8S8cc5o4up6otKKyedkkiH5TkMA1hHz 4rhJrkyj835G4U8W9Tdi/c/+ABu4BwVcueFE9Y x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--26.849800-8.000000 x-tm-snts-smtp: E915728940FCA65BE1D1C7D687915C12726B60EE7080D8E711E2CC38040F66A12000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_76ab7592d45d47898d1a8e7bf0edd5adalteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: EHofQTKKgmLjDkEgqCvtNYN5Yx9Zu+LMvsXoo5RBiBVGxpICJzwSrDD5hrFDgf0t X-GBS-PROCJOB: =?utf-8?Q?p+vX9cBj7e7cFNfk4UuQMm9pWRd0zpke2GfM+cggJzbjsHYQXuoDhaR9WRzY?= =?utf-8?Q?LpH0ttMj3gtcOKzevB6OpIsUnbLaTLnjthLGLX2PiQocWXA5S8t3hZWnV1iq?= =?utf-8?Q?q4zFASdlkZNOm/I8LmsLkkp2kiLGOWEx+wByIeTeMvY1RP1BNgg=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_76ab7592d45d47898d1a8e7bf0edd5adalteleipzigerde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, We have 5 instances running under different ports and we have multiple s= ervers with the same structure. i.e. I have multiple servers with the sam= e five instances per server configuration. /var/lib/pgsql/INST1/data - Port number 1234 /var/lib/pgsql/INST2/data - Port number 1235 /var/lib/pgsql/INST3/data - Port number 1236 /var/lib/pgsql/INST4/data - Port number 1237 /var/lib/pgsql/INST5/data - Port number 1238 I try to make changes to postgresql.conf in our sandbox/testing server f= or just one instance and I simply copy over the changes to all the instan= ces and then to all the servers. I want to place the archived WALs in separate directories for each instan= ce. How can I introduce the INST1 INST2 INST3 INST4 names in the archive= command variable /mnt/server/archivedir , without explicitly editing ch= anging each postgresql.conf file=3F It is not absolutely important for me= that the archive log directories bear the exact names INST1 2 3 ..5. how= ever, I want the archive log directories to be resolved to unique names b= ased on which instance the archive is done. Thank you in advance for your time. LG Ram archive_command =3D =27test ! -f /mnt/server/archivedir/%f && cp %p /mnt/= server/archivedir/%f=27 # Unix Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a.G. Hallesche Krankenversicherung a.G. Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Obe= rursel Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Oberursel (Taunus) =B7 Rechtsform VVaG =B7 Amtsgericht Bad Homburg v= . d. H. HRB 1583 =B7 USt.-IdNr. DE 114106814 =20 Hallesche Krankenversicherung a.G., L=F6ffelstra=DFe 34-38, 70597 Stuttg= art Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek Sitz Stuttgart =B7 Rechtsform VVaG =B7 Amtsgericht Stuttgart HRB 2686 = =B7 USt.-IdNr. DE 147802285 Beitr=E4ge zu privaten Kranken- und Pflegekrankenversicherungen unterlieg= en nicht der Versicherungsteuer (=A7 4 Nr. 5 VersStG) =B7 Versicherungsle= istungen sowie Ums=E4tze aus Versicherungsvertreter-/Maklert=E4tigkeiten = sind umsatzsteuerfrei =20 =20 Die Pflichtangaben der ALH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 Akt= G finden Sie hier: https://www.alte-leipziger.de/impressum=20 ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel.: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de --_000_76ab7592d45d47898d1a8e7bf0edd5adalteleipzigerde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

 

We have 5 instances running under  d= ifferent ports and we have multiple servers with the same structure. i.e.= I have multiple servers with the same five instances per server configuration.

 

/var/lib/pgsql/INST1/data – Port nu= mber 1234

/var/lib/pgsql/INST2/data – Port nu= mber 1235

/var/lib/pgsql/INST3/data – Port nu= mber 1236

/var/lib/pgsql/INST4/data – Port nu= mber 1237

/var/lib/pgsql/INST5/data – Port nu= mber 1238

 

I try to make changes to postgresql.conf =  in our sandbox/testing server for just one instance and I simply co= py over the changes to all the instances and then to all the servers.

 

I want to place the archived WALs in sepa= rate directories for each instance.  How can I introduce the INST1 I= NST2 INST3 INST4 names in the archive command  variable /mnt/server/= archivedir , without explicitly editing changing each postgresql.conf file=3F It is= not absolutely important for me that the archive log directories bear th= e exact names INST1 2 3 ..5. however, I want the archive log directories = to be resolved to unique names based on which instance the archive is done.

 

Thank you in advance for your time.

 

LG


Ram

 

archive_command =3D =27test ! -f /mnt/ser= ver/archivedir/%f && cp %p /mnt/server/archivedir/%f=27  # U= nix

 


Freundliche Gr=FC=DFe


i. A. Ramachandran Subrama= nian =20

Zentralbereich Informationst= echnologie

=20

Alte Leipziger Lebensversicherung a. G.<= /SPAN>

Hallesche Krankenversicherung a. G.

=20

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 614= 40 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Alte Leipziger Lebensversich= erung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsra= ts: Dr. Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrg= en Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexand= er Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) =B7 = Rechtsform VVaG =B7 Amtsgericht Bad Homburg v. d. H. HRB 1583 =B7 USt.-Id= Nr. DE 114106814


Hallesche Krankenversicherun= g a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr.= Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bier= baum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Maye= r, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =B7 Rechtsfor= m VVaG =B7 Amtsgericht Stuttgart HRB 2686 =B7 USt.-IdNr. DE 147802285

Beitr=E4ge zu privaten Krank= en- und Pflegekrankenversicherungen unterliegen nicht der Versicherungste= uer (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicherungsleistungen sowie Ums=E4t= ze aus Versicherungsvertreter-/Maklert=E4tigkeiten sind umsatzsteuerfrei<= /SPAN>


= Pflichtangaben der A= LH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 AktG --_000_76ab7592d45d47898d1a8e7bf0edd5adalteleipzigerde_--