pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Test mail for pgsql-general
7+ messages / 5 participants
[nested] [flat]
* Re: Test mail for pgsql-general
@ 2019-04-01 19:13 preejackie <praveenvelliengiri@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: preejackie @ 2019-04-01 19:13 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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 the executing function. So when we request JIT to compile a
function, JIT will immediately returns the function address for raw
executable bits. This will greatly reduce the JIT latencies in modern
multi-core machines. And also I'm working on designing a ORC in-place
dynamic profiling support, by this JIT will automatically able to
identify the hot functions, and compile it in higher optimization level
to achieve good performance.
I'm proposing this project for GSoC 2019. It would be helpful to know
how this new features are effective to pgsql engine, so that I include
your comments in "View from Clients" proposal section.
Please reply :)
--
Have a great day!
PreeJackie
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Test mail for pgsql-general
@ 2021-08-08 13:33 Bikal Gurung <gbikal@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Bikal Gurung @ 2021-08-08 13:33 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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 <pgsql-pkg-yum@postgresql.org
>"
Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Is this ok [y/N]: y
Error: Cache-only enabled but no cache for 'pgdg-common'
Am I missing something?
B.
On Sun, 8 Aug 2021 at 14:27, pgsql-general Owner <
pgsql-general-owner@lists.postgresql.org> wrote:
> Hello!
>
> This is a test mail for the list
>
> pgsql-general@lists.postgresql.org
>
> as requested. The mail has the same list-id header
> as email delivered to the list, and can be used to
> for example test local mail filters.
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Test mail for pgsql-general
@ 2024-09-10 23:21 Chris Miller <cjm@tryx.org>
2024-09-10 23:26 ` Re: Test mail for pgsql-general David G. Johnston <david.g.johnston@gmail.com>
2024-09-10 23:27 ` Re: Test mail for pgsql-general Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 2 replies; 7+ messages in thread
From: Chris Miller @ 2024-09-10 23:21 UTC (permalink / raw)
To: pgsql-general <pgsql-general@lists.postgresql.org>
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 a shell and I can invoke psql successfully.
I believe that, as root, I should be able to “psql -U postgres -W” and logon with a password. I can’t. When I try, I get:
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "postgres"
Notice I am failing “peer” authentication. Seems to me that if I explicitly ask for a password, “-W”, I should be using “md5” authentication.
Can anybody straighten me out?
Thanks for the help,
--
Chris.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Test mail for pgsql-general
2024-09-10 23:21 Re: Test mail for pgsql-general Chris Miller <cjm@tryx.org>
@ 2024-09-10 23:26 ` David G. Johnston <david.g.johnston@gmail.com>
2024-09-11 01:50 ` Re: Test mail for pgsql-general Chris Miller <cjm@tryx.org>
1 sibling, 1 reply; 7+ messages in thread
From: David G. Johnston @ 2024-09-10 23:26 UTC (permalink / raw)
To: Chris Miller <cjm@tryx.org>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>
On Tuesday, September 10, 2024, Chris Miller <cjm@tryx.org> 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 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 matches all/all.
There is no way to give a user a choice of how to authenticate. There will
be one accepted option for a given set of connection values.
David J.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Test mail for pgsql-general
2024-09-10 23:21 Re: Test mail for pgsql-general Chris Miller <cjm@tryx.org>
2024-09-10 23:26 ` Re: Test mail for pgsql-general David G. Johnston <david.g.johnston@gmail.com>
@ 2024-09-11 01:50 ` Chris Miller <cjm@tryx.org>
0 siblings, 0 replies; 7+ messages in thread
From: Chris Miller @ 2024-09-11 01:50 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>
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 matches all/all.
> There is no way to give a user a choice of how to authenticate. There will be
> one accepted option for a given set of connection values.
This answers my question. Thanks for the help,
--
Chris.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Test mail for pgsql-general
2024-09-10 23:21 Re: Test mail for pgsql-general Chris Miller <cjm@tryx.org>
@ 2024-09-10 23:27 ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-09-11 01:51 ` Re: Test mail for pgsql-general Chris Miller <cjm@tryx.org>
1 sibling, 1 reply; 7+ messages in thread
From: Adrian Klaver @ 2024-09-10 23:27 UTC (permalink / raw)
To: Chris Miller <cjm@tryx.org>; pgsql-general <pgsql-general@lists.postgresql.org>
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 can “su – postgres”, which brings me
> to a shell and I can invoke psql successfully.
>
>
> I believe that, as root, I should be able to “psql -U postgres -W” and
> logon with a password. I can’t. When I try, I get:
>
>
> psql: error: connection to server on socket
> "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication
> failed for user "postgres"
>
>
> Notice I am failing “peer” authentication. Seems to me that if I
> explicitly ask for a password, “-W”, I should be using “md5” authentication.
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
https://www.postgresql.org/docs/16/auth-pg-hba-conf.html
"The first record with a matching connection type, client address,
requested database, and user name is used to perform authentication.
There is no “fall-through” or “backup”: if one record is chosen and the
authentication fails, subsequent records are not considered. If no
record matches, access is denied."
The -W is a no-op per:
https://www.postgresql.org/docs/16/app-psql.html
-W
--password
Force psql to prompt for a password before connecting to a
database, even if the password will not be used.
>
>
> Can anybody straighten me out?
>
>
> Thanks for the help,
> --
> Chris.
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Test mail for pgsql-general
2024-09-10 23:21 Re: Test mail for pgsql-general Chris Miller <cjm@tryx.org>
2024-09-10 23:27 ` Re: Test mail for pgsql-general Adrian Klaver <adrian.klaver@aklaver.com>
@ 2024-09-11 01:51 ` Chris Miller <cjm@tryx.org>
0 siblings, 0 replies; 7+ messages in thread
From: Chris Miller @ 2024-09-11 01:51 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-09-11 01:51 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-04-01 19:13 Re: Test mail for pgsql-general preejackie <praveenvelliengiri@gmail.com>
2021-08-08 13:33 Re: Test mail for pgsql-general Bikal Gurung <gbikal@gmail.com>
2024-09-10 23:21 Re: Test mail for pgsql-general Chris Miller <cjm@tryx.org>
2024-09-10 23:26 ` David G. Johnston <david.g.johnston@gmail.com>
2024-09-11 01:50 ` Chris Miller <cjm@tryx.org>
2024-09-10 23:27 ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-09-11 01:51 ` Chris Miller <cjm@tryx.org>
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