Search Postgresql Archives

Re: Issue with configuration parameter "require_auth"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I think Tom is right.

 

I am using v5.6 of https://github.com/jackc/pgx

 

I quick read of the code reveals no awareness of require_auth, so I have filed an issue with the project.

 

From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wednesday, July 17, 2024 at 1:11
PM
To: Gaisford, Phillip <phillip.gaisford@xxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Issue with configuration parameter "require_auth"

"Gaisford, Phillip" <phillip.gaisford@xxxxxxx> writes:
> So what would a connection URI using require_auth properly look like? Here’s what I have been trying:

> url: "postgres://postgres:postgres@localhost:5432/aioli?require_auth=password&application_name=aioli-controller&sslmode=disable&sslrootcert=",

Hm, that looks right (and behaves as-expected here).

What version of what client-side stack are you using?  For me, libpq 16
and up recognize this parameter, while older versions fail with

psql: error: invalid URI query parameter: "require_auth"

If you're using some other client driver, maybe it doesn't know this
parameter and guesses that it should be passed to the server.

                        regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux