Re: Question on postgresql.conf - Mailing list pgsql-general

From Matt Zagrabelny
Subject Re: Question on postgresql.conf
Date
Msg-id CAOLfK3WSPAG4CA+nut5jHQ+27mrSaOvG3mzt6FuNFB+aBWjLtQ@mail.gmail.com
Whole thread Raw
In response to Re: Question on postgresql.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Question on postgresql.conf  (Dimitri Maziuk <dmaziuk@bmrb.wisc.edu>)
List pgsql-general


On Tue, Jul 31, 2018 at 9:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Lu, Dan" <Dan.Lu@sig.com> writes:
> Question:
> Can <hostname> be a variable like `hostname` derived from Unix shell or I have to hardcode the name of the host like " include /nfs/global/postgres-host123.cnf

Nope, you'd have to hard-code it.

Of course, you could have the startup script that you intended to set the
env variable just overwrite $PGDATA/postgresql.conf with the right thing.

Or have puppet/chef/ansible/etc. write the correct config file based on your dynamic data.

-m 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question on postgresql.conf
Next
From: Melvin Davidson
Date:
Subject: Re: Restore relhaspkey in PostgreSQL Version 11 Beta