Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings
Date
Msg-id 20200109124855.GD4192@msg.df7cb.de
Whole thread Raw
In response to Re: Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings  (Christoph Berg <myon@debian.org>)
List pgsql-hackers
Re: To Andrew Dunstan 2020-01-09 <20200109103014.GA4192@msg.df7cb.de>
> I believe the options are still used in that case
> for creating connections, even when that means the remote server isn't
> set up for cert auth, which needs password_required=false to succeed.

They are indeed:

stat("/var/lib/postgresql/.postgresql/root.crt", 0x7ffcff3e2bb0) = -1 ENOENT (Datei oder Verzeichnis nicht gefunden)
stat("/foo", 0x7ffcff3e2bb0)            = -1 ENOENT (Datei oder Verzeichnis nicht gefunden)
      ^^^^ sslcert

I'm not sure if that could be exploited in any way, but let's just
forbid it.

Christoph



pgsql-hackers by date:

Previous
From: MBeena Emerson
Date:
Subject: Re: Error message inconsistency
Next
From: Julien Rouhaud
Date:
Subject: Re: Add pg_file_sync() to adminpack