Request a Demo
Home   >   mailing lists

Re: 5 Instances in one box -- Postgresql.conf Archive Log command - Mailing list pgsql-novice

From Greg Sabino Mullane
Subject Re: 5 Instances in one box -- Postgresql.conf Archive Log command
Date
Msg-id CAKAnmm+AiZ9Nt7D6LmFnf1+bn33+igSc-xFcj2ZPiHoAt1EdeA@mail.gmail.com
Whole thread Raw
In response to 5 Instances in one box -- Postgresql.conf Archive Log command  ("Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: "Subramanian,Ramachandran"
Date:
Subject: 5 Instances in one box -- Postgresql.conf Archive Log command
Next
From: "Subramanian,Ramachandran"
Date:
Subject: pg_verifybackup fails