pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
13+ messages / 5 participants
[nested] [flat]
Commits from this thread:
2020-05-26 ac5852fb30 a286d470c9 gss: add missing references to hostgssenc and hostnogssenc
* BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-19 18:29 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 2 replies; 13+ messages in thread
From: PG Bug reporting form @ 2020-04-19 18:29 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: tureba@gmail.com
The following bug has been logged on the website:
Bug reference: 16380
Logged by: Arthur Nascimento
Email address: tureba@gmail.com
PostgreSQL version: 12.2
Operating system: Documentation
Description:
Hi,
I see a couple of inconsistencies in the documentation of the pg_hba.conf
file in v12+:
https://www.postgresql.org/docs/12/auth-pg-hba-conf.html (and /current/)
1. Near the top, there's a line saying "A record can have one of the seven
formats", then the followup list shows 9 formats. The ones on host[no]gssenc
were added to the IP-address/IP-mask section, but not to the address
section. I believe the intention was to have 11 lines there, with a
corresponding count at the top.
2. In the address and IP-address/IP-mask descriptions, there's "This field
only applies to host, hostssl, and hostnossl records." and "These fields
only apply to host, hostssl, and hostnossl records.". But those lists should
probably be updated as well to add host[no]gssenc (or to negate the logic,
saying they are not applied to local connections).
Thanks,
Arthur
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-21 18:27 Bruce Momjian <bruce@momjian.us>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2020-04-21 18:27 UTC (permalink / raw)
To: tureba@gmail.com; pgsql-bugs@lists.postgresql.org
On Sun, Apr 19, 2020 at 06:29:31PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16380
> Logged by: Arthur Nascimento
> Email address: tureba@gmail.com
> PostgreSQL version: 12.2
> Operating system: Documentation
> Description:
>
> Hi,
>
> I see a couple of inconsistencies in the documentation of the pg_hba.conf
> file in v12+:
> https://www.postgresql.org/docs/12/auth-pg-hba-conf.html (and /current/)
>
> 1. Near the top, there's a line saying "A record can have one of the seven
> formats", then the followup list shows 9 formats. The ones on host[no]gssenc
> were added to the IP-address/IP-mask section, but not to the address
> section. I believe the intention was to have 11 lines there, with a
> corresponding count at the top.
>
> 2. In the address and IP-address/IP-mask descriptions, there's "This field
> only applies to host, hostssl, and hostnossl records." and "These fields
> only apply to host, hostssl, and hostnossl records.". But those lists should
> probably be updated as well to add host[no]gssenc (or to negate the logic,
> saying they are not applied to local connections).
I agree with your suggestions. I also noticed that pg_hba.conf is
missing gssapi entries too, so I added them to the attached patch. too.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Attachments:
hba.diff (text/x-diff, 2.6K) download
diff --git a/doc/src/sgml/client-auth.sgml b/doc/src/sgml/client-auth.sgml
index 5f1eec78fb..d086d32c49 100644
--- a/doc/src/sgml/client-auth.sgml
+++ b/doc/src/sgml/client-auth.sgml
@@ -99,7 +99,7 @@
</para>
<para>
- A record can have one of the seven formats
+ A record can have one of the nine formats
<synopsis>
local <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
@@ -409,8 +409,7 @@ hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable
</para>
<para>
- These fields only apply to <literal>host</literal>,
- <literal>hostssl</literal>, and <literal>hostnossl</literal> records.
+ These fields do not apply to <literal>local</literal> records.
</para>
</listitem>
</varlistentry>
diff --git a/src/backend/libpq/pg_hba.conf.sample b/src/backend/libpq/pg_hba.conf.sample
index c853e36232..2d76992886 100644
--- a/src/backend/libpq/pg_hba.conf.sample
+++ b/src/backend/libpq/pg_hba.conf.sample
@@ -9,17 +9,21 @@
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access. Records take one of these forms:
#
-# local DATABASE USER METHOD [OPTIONS]
-# host DATABASE USER ADDRESS METHOD [OPTIONS]
-# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
-# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
+# local DATABASE USER METHOD [OPTIONS]
+# host DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostgssenc DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostnogssenc DATABASE USER ADDRESS METHOD [OPTIONS]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain
# socket, "host" is either a plain or SSL-encrypted TCP/IP socket,
# "hostssl" is an SSL-encrypted TCP/IP socket, and "hostnossl" is a
-# plain TCP/IP socket.
+# non-SSL TCP/IP socket. Similarly, "hostgssenc" uses a
+# GSSAPI-encrypted TCP/IP socket, while "hostnogssenc" uses a
+# non-GSSAPI socket.
#
# DATABASE can be "all", "sameuser", "samerole", "replication", a
# database name, or a comma-separated list thereof. The "all"
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-21 18:45 Arthur Nascimento <tureba@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 13+ messages in thread
From: Arthur Nascimento @ 2020-04-21 18:45 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-bugs@lists.postgresql.org
Hi Bruce,
On Tue, 21 Apr 2020 at 15:27, Bruce Momjian <bruce@momjian.us> wrote:
> > 1. Near the top, there's a line saying "A record can have one of the seven
> > formats", then the followup list shows 9 formats. The ones on host[no]gssenc
> > were added to the IP-address/IP-mask section, but not to the address
> > section. I believe the intention was to have 11 lines there, with a
> > corresponding count at the top.
...
> I agree with your suggestions. I also noticed that pg_hba.conf is
> missing gssapi entries too, so I added them to the attached patch. too.
I thought the list would jump to 11 lines there, meaning 1 local plus
5 on address plus 5 on IP-address/IP-mask.
As it stands now with 9 lines, it's 1 local plus 3 on address (it's
missing the two on host[no]gssenc) plus 5 on IP-address/IP-mask.
Tureba - Arthur Nascimento
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-21 19:08 Bruce Momjian <bruce@momjian.us>
parent: Arthur Nascimento <tureba@gmail.com>
0 siblings, 2 replies; 13+ messages in thread
From: Bruce Momjian @ 2020-04-21 19:08 UTC (permalink / raw)
To: Arthur Nascimento <tureba@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
On Tue, Apr 21, 2020 at 03:45:47PM -0300, Arthur Nascimento wrote:
> Hi Bruce,
>
> On Tue, 21 Apr 2020 at 15:27, Bruce Momjian <bruce@momjian.us> wrote:
> > > 1. Near the top, there's a line saying "A record can have one of the seven
> > > formats", then the followup list shows 9 formats. The ones on host[no]gssenc
> > > were added to the IP-address/IP-mask section, but not to the address
> > > section. I believe the intention was to have 11 lines there, with a
> > > corresponding count at the top.
> ...
> > I agree with your suggestions. I also noticed that pg_hba.conf is
> > missing gssapi entries too, so I added them to the attached patch. too.
>
> I thought the list would jump to 11 lines there, meaning 1 local plus
> 5 on address plus 5 on IP-address/IP-mask.
> As it stands now with 9 lines, it's 1 local plus 3 on address (it's
> missing the two on host[no]gssenc) plus 5 on IP-address/IP-mask.
Ah, I see. Updated patch attached.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Attachments:
hba.diff (text/x-diff, 6.9K) download
diff --git a/doc/src/sgml/client-auth.sgml b/doc/src/sgml/client-auth.sgml
index 5f1eec78fb..21a7906751 100644
--- a/doc/src/sgml/client-auth.sgml
+++ b/doc/src/sgml/client-auth.sgml
@@ -99,17 +99,19 @@
</para>
<para>
- A record can have one of the seven formats
+ A record can have one of the 11 formats
<synopsis>
-local <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostgssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+local <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostgssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostgssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
</synopsis>
The meaning of the fields is as follows:
@@ -409,8 +411,7 @@ hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable
</para>
<para>
- These fields only apply to <literal>host</literal>,
- <literal>hostssl</literal>, and <literal>hostnossl</literal> records.
+ These fields do not apply to <literal>local</literal> records.
</para>
</listitem>
</varlistentry>
diff --git a/src/backend/libpq/pg_hba.conf.sample b/src/backend/libpq/pg_hba.conf.sample
index c853e36232..2d76992886 100644
--- a/src/backend/libpq/pg_hba.conf.sample
+++ b/src/backend/libpq/pg_hba.conf.sample
@@ -9,17 +9,21 @@
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access. Records take one of these forms:
#
-# local DATABASE USER METHOD [OPTIONS]
-# host DATABASE USER ADDRESS METHOD [OPTIONS]
-# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
-# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
+# local DATABASE USER METHOD [OPTIONS]
+# host DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostgssenc DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostnogssenc DATABASE USER ADDRESS METHOD [OPTIONS]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain
# socket, "host" is either a plain or SSL-encrypted TCP/IP socket,
# "hostssl" is an SSL-encrypted TCP/IP socket, and "hostnossl" is a
-# plain TCP/IP socket.
+# non-SSL TCP/IP socket. Similarly, "hostgssenc" uses a
+# GSSAPI-encrypted TCP/IP socket, while "hostnogssenc" uses a
+# non-GSSAPI socket.
#
# DATABASE can be "all", "sameuser", "samerole", "replication", a
# database name, or a comma-separated list thereof. The "all"
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-21 19:30 Arthur Nascimento <tureba@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 1 reply; 13+ messages in thread
From: Arthur Nascimento @ 2020-04-21 19:30 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-bugs@lists.postgresql.org
Hi Bruce,
On Tue, 21 Apr 2020 at 16:08, Bruce Momjian <bruce@momjian.us> wrote:
> Ah, I see. Updated patch attached.
That looks perfect. Thank you!
Tureba - Arthur Nascimento
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-21 19:43 Arthur Nascimento <tureba@gmail.com>
parent: Arthur Nascimento <tureba@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Arthur Nascimento @ 2020-04-21 19:43 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-bugs@lists.postgresql.org
> On Tue, 21 Apr 2020 at 16:08, Bruce Momjian <bruce@momjian.us> wrote:
> > Ah, I see. Updated patch attached.
>
> That looks perfect. Thank you!
Oh, there might be another line to change in the 'address' column.
I see you changed the one under 'IP-address/IP-mask' that starts with
"These fields...".
But there is a similar one under 'address', that starts with "This field...".
Tureba - Arthur Nascimento
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-22 01:17 Bruce Momjian <bruce@momjian.us>
parent: Arthur Nascimento <tureba@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2020-04-22 01:17 UTC (permalink / raw)
To: Arthur Nascimento <tureba@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
On Tue, Apr 21, 2020 at 04:43:19PM -0300, Arthur Nascimento wrote:
> > On Tue, 21 Apr 2020 at 16:08, Bruce Momjian <bruce@momjian.us> wrote:
> > > Ah, I see. Updated patch attached.
> >
> > That looks perfect. Thank you!
>
> Oh, there might be another line to change in the 'address' column.
> I see you changed the one under 'IP-address/IP-mask' that starts with
> "These fields...".
> But there is a similar one under 'address', that starts with "This field...".
Agreed, fixed.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Attachments:
hba.diff (text/x-diff, 7.2K) download
diff --git a/doc/src/sgml/client-auth.sgml b/doc/src/sgml/client-auth.sgml
index 5f1eec78fb..eb0e6a8873 100644
--- a/doc/src/sgml/client-auth.sgml
+++ b/doc/src/sgml/client-auth.sgml
@@ -99,17 +99,19 @@
</para>
<para>
- A record can have one of the seven formats
+ A record can have one of the 11 formats
<synopsis>
-local <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostgssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
-hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+local <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostgssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>address</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+host <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostssl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnossl <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostgssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
+hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable> <replaceable>IP-address</replaceable> <replaceable>IP-mask</replaceable> <replaceable>auth-method</replaceable> <optional><replaceable>auth-options</replaceable></optional>
</synopsis>
The meaning of the fields is as follows:
@@ -356,8 +358,7 @@ hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable
</para>
<para>
- This field only applies to <literal>host</literal>,
- <literal>hostssl</literal>, and <literal>hostnossl</literal> records.
+ These fields do not apply to <literal>local</literal> records.
</para>
<note>
@@ -409,8 +410,7 @@ hostnogssenc <replaceable>database</replaceable> <replaceable>user</replaceable
</para>
<para>
- These fields only apply to <literal>host</literal>,
- <literal>hostssl</literal>, and <literal>hostnossl</literal> records.
+ These fields do not apply to <literal>local</literal> records.
</para>
</listitem>
</varlistentry>
diff --git a/src/backend/libpq/pg_hba.conf.sample b/src/backend/libpq/pg_hba.conf.sample
index c853e36232..2d76992886 100644
--- a/src/backend/libpq/pg_hba.conf.sample
+++ b/src/backend/libpq/pg_hba.conf.sample
@@ -9,17 +9,21 @@
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access. Records take one of these forms:
#
-# local DATABASE USER METHOD [OPTIONS]
-# host DATABASE USER ADDRESS METHOD [OPTIONS]
-# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
-# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
+# local DATABASE USER METHOD [OPTIONS]
+# host DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostgssenc DATABASE USER ADDRESS METHOD [OPTIONS]
+# hostnogssenc DATABASE USER ADDRESS METHOD [OPTIONS]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain
# socket, "host" is either a plain or SSL-encrypted TCP/IP socket,
# "hostssl" is an SSL-encrypted TCP/IP socket, and "hostnossl" is a
-# plain TCP/IP socket.
+# non-SSL TCP/IP socket. Similarly, "hostgssenc" uses a
+# GSSAPI-encrypted TCP/IP socket, while "hostnogssenc" uses a
+# non-GSSAPI socket.
#
# DATABASE can be "all", "sameuser", "samerole", "replication", a
# database name, or a comma-separated list thereof. The "all"
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-22 12:15 Arthur Nascimento <tureba@gmail.com>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 13+ messages in thread
From: Arthur Nascimento @ 2020-04-22 12:15 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-bugs@lists.postgresql.org
Hi,
On Tue, 21 Apr 2020 at 22:17, Bruce Momjian <bruce@momjian.us> wrote:
> Agreed, fixed.
Looks good to me.
Cheers,
Tureba - Arthur Nascimento
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-28 14:14 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: Bruce Momjian <bruce@momjian.us>
1 sibling, 1 reply; 13+ messages in thread
From: Peter Eisentraut @ 2020-04-28 14:14 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; Arthur Nascimento <tureba@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
On 2020-04-21 21:08, Bruce Momjian wrote:
> <para>
> - A record can have one of the seven formats
> + A record can have one of the 11 formats
I think this sort of thing is a sign that the number should be replaced
by "several".
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-04-28 17:45 Bruce Momjian <bruce@momjian.us>
parent: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2020-04-28 17:45 UTC (permalink / raw)
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; +Cc: Arthur Nascimento <tureba@gmail.com>; pgsql-bugs@lists.postgresql.org
On Tue, Apr 28, 2020 at 04:14:06PM +0200, Peter Eisentraut wrote:
> On 2020-04-21 21:08, Bruce Momjian wrote:
> > <para>
> > - A record can have one of the seven formats
> > + A record can have one of the 11 formats
>
> I think this sort of thing is a sign that the number should be replaced by
> "several".
Agreed:
- A record can have one of the 11 formats
+ A record can have several formats:
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-05-26 00:19 Bruce Momjian <bruce@momjian.us>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 13+ messages in thread
From: Bruce Momjian @ 2020-05-26 00:19 UTC (permalink / raw)
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; +Cc: Arthur Nascimento <tureba@gmail.com>; pgsql-bugs@lists.postgresql.org
On Tue, Apr 28, 2020 at 01:45:57PM -0400, Bruce Momjian wrote:
> On Tue, Apr 28, 2020 at 04:14:06PM +0200, Peter Eisentraut wrote:
> > On 2020-04-21 21:08, Bruce Momjian wrote:
> > > <para>
> > > - A record can have one of the seven formats
> > > + A record can have one of the 11 formats
> >
> > I think this sort of thing is a sign that the number should be replaced by
> > "several".
>
> Agreed:
>
> - A record can have one of the 11 formats
> + A record can have several formats:
Patch applied through PG 12.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-05-26 01:26 Justin Pryzby <pryzby@telsasoft.com>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 1 reply; 13+ messages in thread
From: Justin Pryzby @ 2020-05-26 01:26 UTC (permalink / raw)
To: tureba@gmail.com; pgsql-bugs@lists.postgresql.org
On Sun, Apr 19, 2020 at 06:29:31PM +0000, PG Bug reporting form wrote:
> 1. Near the top, there's a line saying "A record can have one of the seven
> formats", then the followup list shows 9 formats.
Thanks for pointing it out; it was also mentioned here:
https://www.postgresql.org/message-id/20200505104507.GA32455%40gate.oper.dinoex.org
So I'd included it it in my "docs" patch to resend someday.
--
Justin
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields
@ 2020-05-26 02:07 Bruce Momjian <bruce@momjian.us>
parent: Justin Pryzby <pryzby@telsasoft.com>
0 siblings, 0 replies; 13+ messages in thread
From: Bruce Momjian @ 2020-05-26 02:07 UTC (permalink / raw)
To: Justin Pryzby <pryzby@telsasoft.com>; +Cc: tureba@gmail.com; pgsql-bugs@lists.postgresql.org
On Mon, May 25, 2020 at 08:26:47PM -0500, Justin Pryzby wrote:
> On Sun, Apr 19, 2020 at 06:29:31PM +0000, PG Bug reporting form wrote:
> > 1. Near the top, there's a line saying "A record can have one of the seven
> > formats", then the followup list shows 9 formats.
>
> Thanks for pointing it out; it was also mentioned here:
> https://www.postgresql.org/message-id/20200505104507.GA32455%40gate.oper.dinoex.org
> So I'd included it it in my "docs" patch to resend someday.
Yes, that was fixed in my patch.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2020-05-26 02:07 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-04-19 18:29 BUG #16380: documentation: host[no]gssenc vs. address/IP-address/IP-mask fields PG Bug reporting form <noreply@postgresql.org>
2020-04-21 18:27 ` Bruce Momjian <bruce@momjian.us>
2020-04-21 18:45 ` Arthur Nascimento <tureba@gmail.com>
2020-04-21 19:08 ` Bruce Momjian <bruce@momjian.us>
2020-04-21 19:30 ` Arthur Nascimento <tureba@gmail.com>
2020-04-21 19:43 ` Arthur Nascimento <tureba@gmail.com>
2020-04-22 01:17 ` Bruce Momjian <bruce@momjian.us>
2020-04-22 12:15 ` Arthur Nascimento <tureba@gmail.com>
2020-04-28 14:14 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2020-04-28 17:45 ` Bruce Momjian <bruce@momjian.us>
2020-05-26 00:19 ` Bruce Momjian <bruce@momjian.us>
2020-05-26 01:26 ` Justin Pryzby <pryzby@telsasoft.com>
2020-05-26 02:07 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox