Re: 5 Instances in one box -- Postgresql.conf Archive Log command

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: "Subramanian,Ramachandran" <ramachandran(dot)subramanian(at)alte-leipziger(dot)de>
Cc: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: 5 Instances in one box -- Postgresql.conf Archive Log command
Date: 2026-02-09 17:44:02
Message-ID: CAKAnmm+AiZ9Nt7D6LmFnf1+bn33+igSc-xFcj2ZPiHoAt1EdeA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Subramanian,Ramachandran 2026-02-16 11:10:11 pg_verifybackup fails
Previous Message Subramanian,Ramachandran 2026-02-09 09:35:06 5 Instances in one box -- Postgresql.conf Archive Log command