Re: Question on postgresql.conf

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lu, Dan" <Dan(dot)Lu(at)sig(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "Alvaro Aguayo Garcia-Rada" <aaguayo(at)opensysperu(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question on postgresql.conf
Date: 2018-07-31 13:51:55
Message-ID: 7209.1533045115@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lu, Dan" <Dan(dot)Lu(at)sig(dot)com> writes:
> Say, I want to put the config file on a share drive so all my postgres configuration file can be seen in one location.
> /nfs/global/postgres-<hostname>.cnf

What I'd do is make each data directory's postgresql.conf
contain just this:

include /nfs/global/postgres-<hostname>.cnf

and then just start the postmaster without any weird switches.
In this way you will avoid breaking PG-specific tools that
expect to find the config file at its standard location.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-07-31 13:53:32 Re: Design of a database table
Previous Message Adrian Klaver 2018-07-31 13:40:14 Re: Postgresql 10.4 installation issues on Ubuntu 14.05