Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uA5PF-00ARzu-B9 for pgsql-general@arkaria.postgresql.org; Wed, 30 Apr 2025 11:15:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uA5PD-00DJwy-45 for pgsql-general@arkaria.postgresql.org; Wed, 30 Apr 2025 11:15:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uA5PC-00DJwp-Q3 for pgsql-general@lists.postgresql.org; Wed, 30 Apr 2025 11:15:11 +0000 Received: from mail-oa1-x2e.google.com ([2001:4860:4864:20::2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uA5PB-000Lke-1m for pgsql-general@lists.postgresql.org; Wed, 30 Apr 2025 11:15:11 +0000 Received: by mail-oa1-x2e.google.com with SMTP id 586e51a60fabf-2c769da02b0so6045792fac.3 for ; Wed, 30 Apr 2025 04:15:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1746011706; x=1746616506; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=vrU+7G4QQEBnIYIjMgwK60N+MA0V/fB87OMNPjD9ZRM=; b=Cg0YRoVKLiWdXWsQ86XnIvsUEC4HpX8d3yUpDklzZkg1R4CMCvcXZW8GQCdP+XXvTz clzq6nPXhe8Dk//OCwJWTt3zBxyikpKXETY70BHxGHdIUllJShrTp9E6JoG6pRi3wp5B Cs588crRd7r+F3Wx8GbsIickA+ySMHZ3wx9b8C3LaOcE8t8YDKPX/CaHHjWfPsFXTzZy pQjC0KJH5zvee8A4pJvS48uDP/bsKVayyjaEpXLjsuIkALdUivjeo7tmZr6jouKIrjRU wATvyCI3RSYhZcTOuE4OKftaM80tx7Oa4LLzNHtPvVU47zSjdmUTOArWzTNAgciavhYE TAbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746011706; x=1746616506; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=vrU+7G4QQEBnIYIjMgwK60N+MA0V/fB87OMNPjD9ZRM=; b=ecQs9SsZ9yr2ksbjJAgFq4BRr4X8SKFlHDaoLQ2In4Qk0txQQlL2QNVVr/ko1ev9gt wSzpzJArZOEhvoD5Ca5UTbW+jc/DRMR0marfwXks73Cq0Tq9VVDYm8HOzPB/+RSibSoM Sdig0TRfwLdGg0/7cRyzW6mojr8E15iV/fw0YmrTiTW7129feTLLS1AnsQRmGdfuGw7R MK9lhtu/yUGM6Br39ptLeLGC7jKnQXNuOyVGDmjfstHSEGg2qqM/7hhOFQQ0gzyuHmtk w4q8/u8UjzToiBct2L/ZwThzexl66sxfmjk8bqxzVniNlor/r/yLieOUt9COaQ4Mxi4h dyQw== X-Gm-Message-State: AOJu0YxSnc7r8R+x++2jgutuS/fssgCmnaWpG5RgJ8YdjUjiOvi50x+R YJEHRzgn26NoTPZscGSs1pgWMvT6+t6i8torHoQ9epu10TVuZozSYI09NJ2tlKN1f6WCZbku01A KDuZ8XluqOjHxZouzMWdKHaNV1gbpgA== X-Gm-Gg: ASbGncscp5I61N9RbPrNApOD7PI3KI2buV4qb6hZaOFvPjHJSayPAAkV3GSSK1Npfgm QJY9KFVJsANQGnYQ4UUSC5VKvCgPJBpij7hBWLy5D07TfSp+DXs6TSzjjb2NG1fGO2Xtl3JVdZ1 wiL4TRMmtiicX+ZwZ9s7lI X-Google-Smtp-Source: AGHT+IHSLBcXXpMTCVYvXBQSOsll5FLOxM62M2kTeSAN2vB5ptUHYd1J7JyRfyYKvocKYptlBcXDk5cqNYowAXHEP2A= X-Received: by 2002:a05:6870:c6a7:b0:2b8:f595:2374 with SMTP id 586e51a60fabf-2da6a3ad048mr1501017fac.36.1746011706493; Wed, 30 Apr 2025 04:15:06 -0700 (PDT) MIME-Version: 1.0 From: Luca Ferrari Date: Wed, 30 Apr 2025 13:14:29 +0200 X-Gm-Features: ATxdqUGxuFzLDgwB52Zd1fMpr4Jdr_TzpXk5qga8OUUS2IFAiuuHrdEJjnqwrx0 Message-ID: Subject: alter system appending to a value To: pgsql-general Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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