agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Thomas Kellerer <shammat@gmx.net>
To: pgsql-sql@lists.postgresql.org
Subject: Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
Date: Fri, 17 Dec 2021 18:07:29 +0100
Message-ID: <b1c37523-c7ec-1643-4958-e7c8f400e3a8@gmx.net> (raw)
In-Reply-To: <1355149.1639758450@sss.pgh.pa.us>
References: <CAN0SRDEGsXnULFzB+X7FNzwO4iT27G=rDhe9GgvMnhsj98KKPw@mail.gmail.com>
<A0E82030-D418-4596-A6E5-87016B0CCCE7@excoventures.com>
<1355149.1639758450@sss.pgh.pa.us>
Tom Lane schrieb am 17.12.2021 um 17:27:
> No, that won't help. Like postgres_fdw, dblink will only let you use
> non-password auth methods if you're superuser [1][2]. The problem is
> that making use of any credentials stored in the server's filesystem
> amounts to impersonating the OS user that's running the server. It'd
> be nice to find a less confining solution, but I'm not sure what one
> would look like.
>
> Maybe "use server's FDW credentials" could be associated with a
> grantable role? That's still an awfully coarse-grained approach
> though. I thought for a moment about putting an SSL cert right
> into the connection string; but you'd have to put the SSL private
> key in there too, making it just as much of a security problem as
> putting a password there (but about 100 times more verbose :-().
What about using a .pgpass file?
We use that to hide the password for FDW connections on the SQL level.
Regards
Thomas
view thread (8+ messages) latest in thread
Message-ID: <b1c37523-c7ec-1643-4958-e7c8f400e3a8@gmx.net>
Permalink: ../b1c37523-c7ec-1643-4958-e7c8f400e3a8@gmx.net/
Also on: postgresql.org/message-id/b1c37523-c7ec-1643-4958-e7c8f400e3a8@gmx.net
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shammat@gmx.net, pgsql-sql@lists.postgresql.org
Subject: Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
In-Reply-To: <b1c37523-c7ec-1643-4958-e7c8f400e3a8@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox