| From: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
|---|---|
| To: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pg_hosts: Add pg_hosts_file_rules() |
| Date: | 2026-07-14 15:32:37 |
| Message-ID: | CAN4CZFMzC+L-8MsjCg3AkUkM7TV5Q4i=WZHiyPU9OrXoqHVK1w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> I think it's a good idea to add this. One thing I have been puzzling over is
> what to do with LibreSSL builds which don't support ssl_sni. One could argue
> that parsing the file doesn't require ssl_sni actually function, so the view
> could still work, but on the other hand it might be confusing to users to learn
> that their file doesn't generate any errors yet ssl_sni doesn't work. I think
> I prefer if the view is blank and the file isn't parsed in clusters which
> doesn't support ssl_sni. What are your thoughts on that?
I agree, I was already thinking about this in more general ways as
part of the config rework (what else could be in pg_hosts), but for
the context of this patch it's better to limit it similarly to the
main feature.
Should I also try to add a liressl specific test to it?
I also addressed the other comments, except:
> This test doesn't need the ->reload command here does it, since the view parses
> whats on the filesystem and not what's running. Also, since we know the view
> shall have a single row with an error we should test for == 1 instead of >= 1.
> Similarily, the previous test doesn't need to restart the cluster?
The first is needed, or we need at least start, as postgres is stopped
before it (previous test fails the restart).
Attached v2.
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Add-pg_hosts_file_rules-to-inspect-the-hosts-conf.patch | application/octet-stream | 18.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2026-07-14 15:44:27 | Re: SQL/JSON json_table plan clause |
| Previous Message | Robert Haas | 2026-07-14 15:20:51 | Re: Make pg_prewarm, autoprewarm yield for waiting DDL |