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

Greg Sabino Mullane <htamfids@gmail.com>

From: Greg Sabino Mullane <htamfids@gmail.com>
To: "Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Date: 2026-02-09T17:44:02Z
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