Re: Question on postgresql.conf

From: Matt Zagrabelny <mzagrabe(at)d(dot)umn(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Lu, Dan" <Dan(dot)Lu(at)sig(dot)com>, "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 14:36:30
Message-ID: CAOLfK3WSPAG4CA+nut5jHQ+27mrSaOvG3mzt6FuNFB+aBWjLtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 31, 2018 at 9:21 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Lu, Dan" <Dan(dot)Lu(at)sig(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2018-07-31 14:47:51 Re: Restore relhaspkey in PostgreSQL Version 11 Beta
Previous Message Tom Lane 2018-07-31 14:21:33 Re: Question on postgresql.conf