alter system appending to a value

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: alter system appending to a value
Date: 2025-04-30 11:14:29
Message-ID: CAKoxK+7UEeJhk_hbv1_3KwN1SD8O6ByU-cCr55mFDkErRxZcow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
as trivial as it sounds, is there a smart way to use ALTER SYSTEM to
append to a value?
Something like: ALTER SYSTEM shared_preloaded_libraries =
current_setting( 'shared_preloaded_libraries' ) || ',foo';

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.

Thanks,
Luca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Victor Yegorov 2025-04-30 12:19:01 Re: alter system appending to a value
Previous Message Tom Lane 2025-04-29 15:31:44 Re: DROP ROLE as SUPERUSER