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 1lj2ZZ-00028g-TR for pgsql-admin@arkaria.postgresql.org; Tue, 18 May 2021 16:27:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lj2ZY-0008Ir-UD for pgsql-admin@arkaria.postgresql.org; Tue, 18 May 2021 16:27:56 +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 1lj2ZY-0008Fi-J8 for pgsql-admin@lists.postgresql.org; Tue, 18 May 2021 16:27:56 +0000 Received: from mail-ed1-x529.google.com ([2a00:1450:4864:20::529]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lj2ZW-0006JP-57 for pgsql-admin@lists.postgresql.org; Tue, 18 May 2021 16:27:55 +0000 Received: by mail-ed1-x529.google.com with SMTP id r11so11885532edt.13 for ; Tue, 18 May 2021 09:27:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=cybertec; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=EDHGl8eZKDxoKNEByrozQHx+DZz6Kf65jUzIqfpw7jk=; b=nCKY8wE6P5oWBmUhw07RI8r6LDSM+IVCNtfSYuZUNEwpde7a45VtkmuRXqukiCAESv F9s6p94FwjysoIDy8rdRw6elSpsOSTCipcqvUW8Sryo5KTiWcXW3ifJwDBEolvDdVTSD kuNq4D1OuLbNM9M+RvpEVle414pMSuEWf47fWE4tKc/vG45pJ311mWlzHw0AJfosIREq R8NtLvlORUoSsBGSkEWnkhXkildhDyf2VSosQkgjNTknZ82I54FfyRUuYUvjzPYdOLKm svrYlJK/8egSp01cvPgy6wf47g38M8ZfVAd0eArwJ/pSc6I+yVcB/cTbcXT/Wn7G2zQC du1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=EDHGl8eZKDxoKNEByrozQHx+DZz6Kf65jUzIqfpw7jk=; b=ZnT6ijFxWskQbKzHG+z8nT4vUU05bX0DnyAPzuyCLSLMnCqEbsuCknRIVjlmwgTAMa +fcsPcJGQ5JVSVDD81qDgxEh18YkyqXWTlLDOltZHmpxcBaPG5XNvlBP0kvRUnfqmLFY vTfFc4CIeXz+yVR0V7tutQwTEomZkwBDo+/CAW37w91Zsa9v1EX2AzISv072kDKvHB9X ZM2MVtrjcU1qDG9E7DA3vyDb9UmPEqhSR/DZ1VJM+ZPgavCGRwfIY4OL0NB55rkZqKrj 84MoMgYpSze0kePLrWfirGS7ElvCTfxTa73AUWkxNNiWGvsaSeZbyfeHYYMzQzwdcujq ZjJA== X-Gm-Message-State: AOAM533Baxg27iYqApXOIj5Ue2J8AtM58srQTFDkiZDDA16gxLXQW8T8 Aeo0pxBGvcEJY7ezG5zDOHuU+rTEWx3e9A== X-Google-Smtp-Source: ABdhPJyyJc12ve0EPMrJ5iqAIqWz9IpgrcbkAbtsDDCTbbxZO+I+CJBIxxAsy6OllHj115+uhb1VjQ== X-Received: by 2002:a50:f695:: with SMTP id d21mr8054090edn.67.1621355271429; Tue, 18 May 2021 09:27:51 -0700 (PDT) Received: from localhost.localdomain (217-149-174-207.nat.highway.telekom.at. [217.149.174.207]) by smtp.gmail.com with ESMTPSA id c7sm13226724ede.37.2021.05.18.09.27.50 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 18 May 2021 09:27:51 -0700 (PDT) Message-ID: Subject: Re: [EXTERNAL] Re: FDW, connections, master v replica From: Laurenz Albe To: "Godfrin, Philippe E" , pgsql-admin@lists.postgresql.org Date: Tue, 18 May 2021 18:27:50 +0200 In-Reply-To: References: <49ed5b6a7a44f245676db39d8c6c2b1f55035eac.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2021-05-18 at 16:13 +0000, Godfrin, Philippe E wrote: > That seems very promising, though I’m not certain how I’d code that in the create > foreign server syntax. My testbed is not quire ready right now, so I’ll ask instead of testing. > Is this what you mean: > > CREATE SERVER FDW001 FOREIGN DATA WRAPPER POSTGES_FDW > OPTIONS (HOST ‘FOORW, FOORO’, DBNAME ‘FOODB,FOODB’, PORT ‘5432,6432’, > TARGET_SESSION_ATTRS ‘ANY,READ-ONLY’ Pretty much, yes. Except you can only specify a single setting for "target_session_attrs". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com