Re: Test mail for pgsql-general

2024-09-10 Thread Chris Miller
Hi Adrian, > First match wins loses in this case. The entries are processed top to > bottom the first the one matches in this case: > > local all all peer > > Per This answers my question. Thanks for the help, -- Chris.

Re: Test mail for pgsql-general

2024-09-10 Thread Chris Miller
Hi David, > The second line is pointless, the first three columns are compared against the > incoming connection host/user/dbname to find out how authentication should be > handled. The first match wins. So for every local connection peer, and only > peer, is going to be used since everything mat

Re: Test mail for pgsql-general

2024-09-10 Thread Adrian Klaver
On 9/10/24 16:21, Chris Miller wrote: Hi Folks, I am confused about authentication. I understand that in the local connection case, I have choices of “peer”, and “md5” (password). In pg_hba.conf, I have the lines: local all all peer local all all md5 I have an OS user “postgres”, and I

Re: Test mail for pgsql-general

2024-09-10 Thread David G. Johnston
On Tuesday, September 10, 2024, Chris Miller wrote: > Hi Folks, > > I am confused about authentication. I understand that in the local > connection case, I have choices of “peer”, and “md5” (password). > > > In pg_hba.conf, I have the lines: > > > local all all peer > > local all all md5 > > The

Re: Test mail for pgsql-general

2024-09-10 Thread Chris Miller
Hi Folks, I am confused about authentication. I understand that in the local connection case, I have choices of “peer”, and “md5” (password). In pg_hba.conf, I have the lines: local all all peer local all all md5 I have an OS user “postgres”, and I can “su – postgres”, which brings me to

Re: Test mail for pgsql-general

2021-08-08 Thread Bikal Gurung
Hi, I am running rocky-linux 8.4. I have successfully added the yum repo as specified at https://www.postgresql.org/download/linux/redhat/ . However, whenever I do `yum -q -C list` I always get the following error, Importing GPG key 0x442DF0F8: Userid : "PostgreSQL RPM Building Project " Fi

Re: Test mail for pgsql-general

2019-04-01 Thread preejackie
Hi I'm Praveen Velliengiri, student from India. I'm working on developing a Speculative compilation support in LLVM ORC JIT Infrastructure. As LLVM ORC supports compiling in multiple backend threads, it would be effective if we compile the functions speculatively before they are called by th