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-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: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: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12

2022-10-30 Thread Joe Conway
On 10/28/22 16:24, Peter J. Holzer wrote: On 2022-10-28 17:23:02 +0300, Kristjan Mustkivi wrote: By the way, index rebuild while completing successfully did not fix the indexes - the data in the tables was still missing even after the successful rebuild command. This is surprising. As I unders

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 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 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: Unix users and groups... Was: "peer" authentication...

2022-10-30 Thread Bryn Llewellyn
> hjp-pg...@hjp.at wrote: > >> b...@yugabyte.com: >> >> 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) grou

there is no an example in reloptions.c for string?

2022-10-30 Thread jack...@gmail.com
jack...@gmail.com -- here is the codes for pg16. static relopt_string stringRelOpts[] = { /* list terminator */ {{NULL}} }; And I add my string type arguments here, it can't work well. When I debug, it comes to func allocateReloptStruct, at t

Re: there is no an example in reloptions.c for string?

2022-10-30 Thread David G. Johnston
On Sun, Oct 30, 2022 at 8:24 PM jack...@gmail.com wrote: > t. what else do I need to add? The stuff it mentions in the code comment in that file. You might consider actually showing what you did add. can you give me an example? > > Ah, the beauty of using version control, history as examples.

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