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 1qtsRc-00ENeq-Ho for pgsql-general@arkaria.postgresql.org; Fri, 20 Oct 2023 16:33:52 +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 1qtsRa-004GV3-DU for pgsql-general@arkaria.postgresql.org; Fri, 20 Oct 2023 16:33:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtsRa-004GUt-1x for pgsql-general@lists.postgresql.org; Fri, 20 Oct 2023 16:33:50 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qtsRY-001SFm-AW for pgsql-general@lists.postgresql.org; Fri, 20 Oct 2023 16:33:49 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-d9ca471cf3aso1072063276.2 for ; Fri, 20 Oct 2023 09:33:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697819627; x=1698424427; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=gGFfN2jp6Jr+acnFMn2hIbqmdThOLvvOX+leyCEci+o=; b=HQw8nzOFsPx0VpRfeDppWnozzRxPPtMnNdHxRxUJtn66lpI5MziyoGmpFMoFCI2Ks+ SlVfhn3hSkyEXQ5dqDRKQ/rQY3jd0IJYA4//KCI9x59jj67BRgHVZrzWuIIiY9PSpK8b l6/haVwC8qJPIiAKjs4OjQykyJX6Pr0nXo1zg3EHWzpSooBdRLmpimV8crIs7n9/1W6C 9h6W1NA+Qqmm/aTJ2xe/3UCs+c2SCDFN8PMC7cS4q+TWCz6Qbsc4/UAE8zrg7c6uOXZ6 zgAVVwwiCBj5olOaGDyoQSyDBsVjySti1hUf++UWdjcAzHMYW2SpAU56Agfyi5l+Eeke kEYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697819627; x=1698424427; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=gGFfN2jp6Jr+acnFMn2hIbqmdThOLvvOX+leyCEci+o=; b=WgvNZ0NwIUKm/XWzZbHrlRZgdOvTap+Kws4aqpihWXlIO2jY1iRGvJVJ0orMmC2yUl Gp7S20vcOlKgBO8vbhQS72r8NmKGG24ZpncYFOZtXrYSmRB8BbZaSXEZlOagEJd7r2Y8 vkcPOI/s3ooBvvm7GUashDBmvaoXa7lL0Sdw8AV14oLq6YElFvSox/QNN40VWPskOQZi 3Xv4YRsJlsU5HwiOVZiLXtODtafeDUrCwRLbgfHW85VVTccEqMawB9pFbjNmrhl8Qd/j 6HWJfZy1sW3qikcp6w+05wsuYpQJGJGYwC1pbjPK5D3T2oKUEa8dRu1rxtZP99HMQm+n INiA== X-Gm-Message-State: AOJu0Yw0hC7XQN8gVUj1zoAFQjB/xaKC9jeG/IucZJw5fOlagoRwQKS7 fqEqntGWkv9m39+1fge+z8/Kb78QOVw= X-Google-Smtp-Source: AGHT+IFSPhMIhjvC6gv3cVW7vtkw2Qj+QljRZP6zvCuiInsjXatgLmDl0UDYCtCy21lZ3S6jsD5bXQ== X-Received: by 2002:a05:6902:1141:b0:d9b:d61e:2370 with SMTP id p1-20020a056902114100b00d9bd61e2370mr2775512ybu.12.1697819627254; Fri, 20 Oct 2023 09:33:47 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:f1bd:a9fc:1661:b015? ([2600:1700:bd2c:b810:f1bd:a9fc:1661:b015]) by smtp.googlemail.com with ESMTPSA id u1-20020a25ab01000000b00d9cc49edae9sm663549ybi.63.2023.10.20.09.33.46 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Oct 2023 09:33:46 -0700 (PDT) Message-ID: Date: Fri, 20 Oct 2023 11:33:46 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Is postgres_fdw "safe"? Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <87zg0d1yu2.fsf@mbork.pl> From: Ron In-Reply-To: <87zg0d1yu2.fsf@mbork.pl> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/20/23 03:29, Marcin Borkowski wrote: > Hello, > > I noticed that the docs for postgres_fdw lack the clause about it being > "trusted". Does that mean that `create extension postgres_fdw` poses > any known security risks? If so, what should I do to minimize them? I think a better question to ask is if extensions are implicitly trusted unless explicitly marked untrusted. -- Born in Arizona, moved to Babylonia.