MIME-Version: 1.0
References: <CAKoxK+7UEeJhk_hbv1_3KwN1SD8O6ByU-cCr55mFDkErRxZcow@mail.gmail.com>
In-Reply-To: <CAKoxK+7UEeJhk_hbv1_3KwN1SD8O6ByU-cCr55mFDkErRxZcow@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 30 Apr 2025 12:11:37 -0400
Message-ID: <CAKAnmmJPnZHvg-h_Lybm6CJtivH8oi=Qp=W94xBXitW1hftEiw@mail.gmail.com>
Subject: Re: alter system appending to a value
To: Luca Ferrari <fluca1978@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000024f7d30634012e41"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmJPnZHvg-h_Lybm6CJtivH8oi%3DQp%3DW94xBXitW1hftEiw%40mail.gmail.com>
Precedence: bulk

--00000000000024f7d30634012e41
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Apr 30, 2025 at 7:15=E2=80=AFAM Luca Ferrari <fluca1978@gmail.com> =
wrote:

> Rationale: I'm using ansible to configure, thru different steps,
> PostgreSQL instances and I would like to have every part to append its
> configuration on the previous one.
>

Ansible is good for bringing your systems to a known consistent state, so
your best bet would be to maintain the list of libraries inside Ansible and
then simply apply it. If you really don't know what might be in the
database, I would have Ansible read the current value, build the new one if
the desired library is not there, and apply the new value.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--00000000000024f7d30634012e41
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Apr 30, 2025 at 7:15=E2=80=AFAM L=
uca Ferrari &lt;<a href=3D"mailto:fluca1978@gmail.com">fluca1978@gmail.com<=
/a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex">Rationale: I&#39;m using ansibl=
e to configure, thru different steps,<br>
PostgreSQL instances and I would like to have every part to append its<br>
configuration on the previous one.<br></blockquote><div><br></div><div>Ansi=
ble is good for bringing your systems to a known consistent state, so your =
best bet would be to maintain the list of libraries inside Ansible and then=
 simply apply it. If you really don&#39;t know what might be in the databas=
e, I would have Ansible read the current value, build the new one if the de=
sired library is not there, and apply the new value.</div><div><br></div><d=
iv>Cheers,</div></div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=
=3D"ltr"><div>Greg</div><div><br></div><div>--</div><div>Crunchy Data - <a =
href=3D"https://www.crunchydata.com" target=3D"_blank">https://www.crunchyd=
ata.com</a></div><div>Enterprise Postgres Software Products &amp; Tech Supp=
ort</div><div><br></div></div></div></div>

--00000000000024f7d30634012e41--