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.96) (envelope-from ) id 1wI2WB-007jYC-2R for pgsql-admin@arkaria.postgresql.org; Wed, 29 Apr 2026 10:51:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wI2WB-0036jU-04 for pgsql-admin@arkaria.postgresql.org; Wed, 29 Apr 2026 10:51:47 +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.96) (envelope-from ) id 1wI2WA-0036jM-26 for pgsql-admin@lists.postgresql.org; Wed, 29 Apr 2026 10:51:46 +0000 Received: from mail-wr1-x432.google.com ([2a00:1450:4864:20::432]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wI2W8-00000003mmh-1lKw for pgsql-admin@lists.postgresql.org; Wed, 29 Apr 2026 10:51:46 +0000 Received: by mail-wr1-x432.google.com with SMTP id ffacd0b85a97d-43fe62837baso7157501f8f.3 for ; Wed, 29 Apr 2026 03:51:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1777459903; x=1778064703; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Mv66IRv4RDY2tH1d94l2bKnzeG+E85T9C/7DAT3cY8w=; b=eT5YNuBqliSQeq7kDSEXFwCg7hAhPYtu1OdwxxCjsp7O363dK5C9m18aCXh/YfdzX4 EFNsJSgIeqltvMrXz2mEyzU8QSgfzHF4+KUj3Qhnlf6ZiP/29gduztdCmE6AhzImlVIo TRqeRVyWRxnSM006mv8lFWGuIaPzlKn9H7NAtHQGJnY2mgWeWDuXHLGXCwNJKKpi6V7h znZQv7pLzChDJtoKajVe0hwbnI+DOucdZxYNXymptrJjvQg/XJHBloWasK6UjFvzgv2k vbrgSMbB6nKE/3hYPoXMMdOkeTgPx/VecXg2gCWlRiPixsaLkD34G3VczK7fTOOOOvG9 ebkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777459903; x=1778064703; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Mv66IRv4RDY2tH1d94l2bKnzeG+E85T9C/7DAT3cY8w=; b=lM4FIwR8k8GgVH9WL0HcCJs736MK5q3VEK+2KUtIaUI8px7D/YnwhAi56MLvCpBf2D FoARg4+GR60nDtWWriqs3LBMLJTbWXeTgy9ueXhBieMxGMeG3qtEsJMYyMlTf5rotoA0 ClWyT2B5DREX8xIV9kMlW1Yj/u6LWYLmBQkd8MhzFa4/UMgIOEvF79yrf7H6bxxpzhU1 2RALcxbv8SAJd68/SQjks95IlQ4OefwBxtjtpnVQ71Tf6TWO6jOFvROYOr2ZuvAvh1nJ wQEeElKPXZ72CCS1cFHO+t4TIEnb/vCZzKYOceS1FlQaJGu5AvFbqNdGVXb54o7VTFTY N+mA== X-Forwarded-Encrypted: i=1; AFNElJ+RF0ulBuKMO7ir56s36EFDef6flc+tJko50i0LFRyAZo2hNLixj937+TsenIgIuCeAXRyaeG6uaW+MrQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YwBBM6ODxQ2qlJPtto2NjuuMwhwVRStxt4Iyw7q/nt0p6P5NVvf HESC/+FbkfC50x7LjSO9FOHMiBFqkDWw5x9JL0r9GfcigXVj/ZUOEfWwRIiAqlwnZ5c= X-Gm-Gg: AeBDies2GLAh9TC3Bl1hKOOkVAt33dEIgqLg05ls4T9KXRZBj7qCPAhpEsA6qf29+DR wiBvGBrZieNLce0Wjt5NzIkYUUxL51/dBgutr2ttk97aR4Alz/O4saN2GCC0reAwHur80I/xBuX pZ5qdCLsfgw2AWLgTO51dDihKb48RE6/k+cbKhCitqJhq4eW32TR5VtjhShtZJKzc10bVsRD4Nv BYYRPOU+Fwgr/za8kXOCeWGHjydADzQcI11ogeL6avAbkrIs2SjqwNTtiY2dCG6e2/K3DN1fMm3 6JY26Xmrr90hK39ZhhZxMg1pvGzNviPTD9YQnmdWU/cKmfG5Afjf3NYcPgHyQKhyvRJzZnnJnx6 sc2RgsHlszdFTX5OfkPFFFlCFj+Qtvw86yEzMbMr+Bd8pTK2JgV2OBCyUvO1u+dCbZZJjTgK6h5 cGcdI+H5krSCVzfGkV8qVHp3zwQaTGasnBdh3M3zxIiR+RxXoLYcMvxwlHCRfX9IT7XcYIHgX/9 A== X-Received: by 2002:a5d:40c4:0:b0:446:96b1:f5f with SMTP id ffacd0b85a97d-44696b111bamr6116049f8f.8.1777459902824; Wed, 29 Apr 2026 03:51:42 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-447b7217c2asm4638396f8f.19.2026.04.29.03.51.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 29 Apr 2026 03:51:42 -0700 (PDT) Message-ID: <81a87414206a7a1fc6c98da3674b3d3d57f25e12.camel@cybertec.at> Subject: Re: User Mapping? From: Laurenz Albe To: =?ISO-8859-1?Q?P=E4r?= Mattsson , "pgsql-admin@lists.postgresql.org" Date: Wed, 29 Apr 2026 12:51:41 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2026-04-29 at 09:28 +0000, P=C3=A4r Mattsson wrote: > https://www.postgresql.org/docs/16/sql-createusermapping.html >=20 > This document is not the hole truth how to config user mapping? > Do you any guidelines to follow? I think that the documentation is complete. The options are specific for the foreign data wrapper you are using, so if you want documentation about them, look at the FDW's documentation. In the case of postgres_fdw, that would be https://www.postgresql.org/docs/current/postgres-fdw.html#POSTGRES-FDW-OPTI= ONS Yours, Laurenz Albe