Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oF1aJ-0002nv-WA for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Jul 2022 22:57:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oF1ZK-0001Eb-I6 for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Jul 2022 22:56:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oF1ZK-0001EL-4E for pgsql-hackers@lists.postgresql.org; Fri, 22 Jul 2022 22:56:26 +0000 Received: from mail-pl1-x62f.google.com ([2607:f8b0:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oF1ZD-0008Vm-BB for pgsql-hackers@postgresql.org; Fri, 22 Jul 2022 22:56:24 +0000 Received: by mail-pl1-x62f.google.com with SMTP id y24so5695703plh.7 for ; Fri, 22 Jul 2022 15:56:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=bRtS/UbEtBk8P2xEvdusIex6utFdFVLfOX60hh/NliI=; b=bhzDO4kRiFzb8JWqgczXIJtahYKx67Nh/tac0DQrj5j4el285bBtKS01+rWwFpnvUu BZ8Gv5ygOOPVcJxepFDIyF4vRcANh+fnyKOaVqRuDr4KCH1cIlGB4wE0fO2msxSjV08w V68+IEKNGeFyBtnMycy4hYoZSzOyB0vIjfzDlr830WbhqsmMskDfYs5UI1hhMLgVv23h UVoRvqSMIy9d6rTn6YCwNy+0ySeV7dwXBqRo3iRUjbv/9zzQGcR2DkgD32ONJwVbt/rW hc2cVczQQuqyO6HHCZ7BJAjfSHaxtSTIOCVWrgACEIKGJgiVQHE8BQhlKy2Vj0BEuYeG KWBA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=bRtS/UbEtBk8P2xEvdusIex6utFdFVLfOX60hh/NliI=; b=7q+8eFx870mwE2OSOODXRDhWqWoPm+fuHzgPak+V+XEwkeR08iKMpYnmEJv3WTU0Av Yrk/9qveSOeNZaSwFa5/l2go7JA1b9aLIlKv9dDifpuyGgh+3KJjHCotyIB+Dmn4xSAe c+9bUMzSl2tWuqhMGD09i+ZadnySuL8LRMwtZxabm1pQqzjDJWpfOZeWyhKob0UUVCH2 2WLg5dcvV0NZg4kywKTulyYqpblLiWlW2Q2N/4ZsDiabCaeNBSm1IVqAYA3TX63SyqmV rBm+DjhALgJqXwVmIX42Ng2yjTWFpHvEUGnVdJxifNOLilz/vtNFWUNDU6t7r224/yLz Cz5Q== X-Gm-Message-State: AJIora9x7MuogRW2dqDXlHWmKiMtsN7ZChRaKxtySyjky6Eg3MCkd/zL 9SJWu8b8NtDTL3OiGKBho4M= X-Google-Smtp-Source: AGRyM1sZBqc9uNDRRfOVujpTnji1do9msXOnj9wxRJH3VjQ1qwufIgGZvcDMjB53rUxmJTB2s9Guxg== X-Received: by 2002:a17:90b:17c1:b0:1f0:1f7b:935f with SMTP id me1-20020a17090b17c100b001f01f7b935fmr19509324pjb.63.1658530577906; Fri, 22 Jul 2022 15:56:17 -0700 (PDT) Received: from nathanxps13 ([50.54.155.70]) by smtp.gmail.com with ESMTPSA id k8-20020a170902ce0800b0016c4f96b0aesm4216020plg.297.2022.07.22.15.56.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 22 Jul 2022 15:56:17 -0700 (PDT) Date: Fri, 22 Jul 2022 15:56:15 -0700 From: Nathan Bossart To: Tom Lane Cc: Kyotaro Horiguchi , michael@paquier.xyz, gurjeet@singh.im, pgsql-hackers@postgresql.org Subject: Re: Unprivileged user can induce crash by using an SUSET param in PGOPTIONS Message-ID: <20220722225615.GC3998906@nathanxps13> References: <20220722.151600.1094104349120879204.horikyota.ntt@gmail.com> <729330.1658516182@sss.pgh.pa.us> <20220722223359.GB3998906@nathanxps13> <763512.1658529844@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <763512.1658529844@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 22, 2022 at 06:44:04PM -0400, Tom Lane wrote: > Another idea is to add a "bool interactive" parameter to InitPostgres, > thereby shoving the issue out to the call sites. Still wouldn't > expose the am_walsender angle, but conceivably it'd be more > future-proof anyway? I hesitated to suggest this exactly because of the WAL sender problem, but it does seem slightly more future-proof, so +1 for this approach. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com