Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> This is what I see. I have Ubuntu 20.04 LTS VM using Parallels Desktop >> Version 18. >> >> # adduser 'dog$house' >> adduser: To avoid problems, the username should consist only of >> letters, digits, underscores, periods,

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread David G. Johnston
On Mon, Oct 31, 2022 at 8:19 PM Bryn Llewellyn wrote: > > This is what I see. I have Ubuntu 20.04 LTS VM using Parallels Desktop > Version 18. > > # adduser 'dog$house' > adduser: To avoid problems, the username should consist only of > letters, digits, underscores, periods, at signs and dashes,

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Bryn Llewellyn
hjp-pg...@hjp.at wrote: > >> b...@yugabyte.com wrote: >> >> However, Linux (at least) simply disallows O/S users that have a dollar sign >> in the name. > > This is getting quite off-topic, but that isn't true: > > trintignant:~ 22:46 :-) 1015# useradd -m -s /bin/bash 'mac$crooge' > trintignan

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >>> adrian.kla...@aklaver.com wrote: >>> b...@yugabyte.com wrote: This, on the other hand: psql -d postgres -U 'clstr$mgr' calls for "local", "peer" authen

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Peter J. Holzer
On 2022-10-30 21:01:25 -0700, Bryn Llewellyn wrote: > However, Linux (at least) simply disallows O/S users that have a > dollar sign in the name. This is getting quite off-topic, but that isn't true: trintignant:~ 22:46 :-) 1015# useradd -m -s /bin/bash 'mac$crooge' trintignant:~ 22:46 :-) 1016#

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Adrian Klaver
On 10/31/22 10:31 AM, Bryn Llewellyn wrote: adrian.kla...@aklaver.com wrote: b...@yugabyte.com wrote: This, on the other hand: psql -d postgres -U 'clstr$mgr' calls for "local", "peer" authentication as so it does NOT require a p

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> This, on the other hand: >> >> psql -d postgres -U 'clstr$mgr' >> >> calls for "local", "peer" authentication as so it does NOT require a >> password. That would be enough for me. But, naturally, and now that it's >> worki

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-31 Thread Adrian Klaver
On 10/30/22 21:01, Bryn Llewellyn wrote: See comments inline. *INTRODUCTION *Thanks to all who've helped me on this topic. Forgive me if I left out anybody on the "To" list. I suppose that I should have explained my use case more carefully. I did sketch it earlier on. But, not surprisingly

CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Bryn Llewellyn
INTRODUCTION Thanks to all who've helped me on this topic. Forgive me if I left out anybody on the "To" list. I suppose that I should have explained my use case more carefully. I did sketch it earlier on. But, not surprisingly, this got lost in the noise. I was afraid of being accused of writi

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Adrian Klaver
On 10/30/22 09:16, Karsten Hilbert wrote: Am Sat, Oct 29, 2022 at 09:15:08PM -0700 schrieb Adrian Klaver: *# MAPNAME    SYSTEM-USERNAME   PG-USERNAME* *# ---    ---   ---   bllewell   mary              mary * As has been said numerous times, it is utte

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Karsten Hilbert
Am Sat, Oct 29, 2022 at 09:15:08PM -0700 schrieb Adrian Klaver: > >*# MAPNAME    SYSTEM-USERNAME   PG-USERNAME* > >*# ---    ---   --- > >   bllewell   mary              mary > >* > > > > > >As has been said numerous times, it is utterly pointless to define

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Karsten Hilbert
Am Sat, Oct 29, 2022 at 08:20:50PM -0700 schrieb Bryn Llewellyn: > For the purpose of the tests that follow, I set up the O/S users "bob" and > "mary" so that "id bob mary postgres" shows this: > > id=1002(bob) gid=1001(postgres) groups=1001(postgres) > uid=1003(mary) gid=1001(postgres)

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Peter J. Holzer
On 2022-10-29 20:20:50 -0700, Bryn Llewellyn wrote: > For the purpose of the tests that follow, I set up the O/S users "bob" and > "mary" so that "id bob mary postgres" shows this: > > id=1002(bob) gid=1001(postgres) groups=1001(postgres) > uid=1003(mary) gid=1001(postgres) groups=1001(p

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Peter J. Holzer
On 2022-10-29 20:20:50 -0700, Bryn Llewellyn wrote: > My problem stems from the fact that the goal statement that my inner > voice expresses seems so simple to state. This is what I want: > > 1. I want to do this at the O/S prompt on the machine where my PG cluster has > been started: "su mary". >

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-30 Thread Peter J. Holzer
On 2022-10-29 20:38:07 -0700, David G. Johnston wrote: > Next, I put an identity mapping in for "mary" in "pg_ident.conf" thus: > > # MAPNAME    SYSTEM-USERNAME   PG-USERNAME > # ---    ---   --- >   bllewell   mary              mary > > > As has been said

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-29 Thread Adrian Klaver
On 10/29/22 20:38, David G. Johnston wrote: On Sat, Oct 29, 2022 at 8:20 PM Bryn Llewellyn > wrote:This is what I want: 1. I want to do this at the O/S prompt on the machine where my PG cluster has been started: *"su mary"*. 2. Then I want to start a sessi

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-29 Thread David G. Johnston
On Sat, Oct 29, 2022 at 8:20 PM Bryn Llewellyn wrote:This is what I want: > > 1. I want to do this at the O/S prompt on the machine where my PG cluster > has been started: *"su mary"*. > > 2. Then I want to start a session (I use "psql" here an an example) like > this: *"psql -d postgres"*. > > 3

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-29 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> ...What am I doing wrong? > > You skipped over this part of my post and the documentation (Section 21.2): > https://www.postgresql.org/docs/current/auth-pg-hba-con

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-29 Thread Adrian Klaver
On 10/28/22 17:23, Bryn Llewellyn wrote: Adrian, thank you for your reply to my « Seeking the correct term of art for the (unique) role that is usually called "postgres"... » thread here: It got me in without error. (And, as hoped for, there was no password challenge.) But "select current_ro

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-28 Thread David G. Johnston
On Fri, Oct 28, 2022 at 5:26 PM Bryn Llewellyn wrote: > > And I simply decided to follow its spirit with "bob" mapping to "alice", > thus: > > *# MAPNAME SYSTEM-USERNAME PG-USERNAME* > > > *...bllewellbob alice* > Here's my "pg_hba.conf": > > > *...* > >

Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-28 Thread Jeremy Smith
> > > > *sudo systemctl stop postgresql**sudo * > *systemctl start postgresql**pg_ctl reload -D /etc/postgresql/11/main/* > > (I know that I could've used "systemctl restart ".) Like I said elsewhere, > the "reload" seems to be superfluous. But it costs nothing to do it. > > Actually, you only n

"peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

2022-10-28 Thread Bryn Llewellyn
Adrian, thank you for your reply to my « Seeking the correct term of art for the (unique) role that is usually called "postgres"... » thread here: https://www.postgresql.org/message-id/e75abfa8-72af-701c-cf6f-5336a1a35...@aklaver.com