Re: PG-15.6: timeout parameters erroring out

2025-02-09 Thread David G. Johnston
On Sunday, February 9, 2025, Tom Lane wrote: > Mukesh Tanuku writes: > > We unabled the postgres timeout parameters in the postgresql.conf file > > > *idle_in_transaction_session_timeout = '1min'idle_session_timeout = > '5min'* > Did you actually run them together on one line like that? > I th

Re: PG-15.6: timeout parameters erroring out

2025-02-09 Thread Tom Lane
Mukesh Tanuku writes: > We unabled the postgres timeout parameters in the postgresql.conf file > *idle_in_transaction_session_timeout = '1min'idle_session_timeout = '5min'* Did you actually run them together on one line like that? The normal thing is one setting per line. It might be that the

Re: PG-15.6: timeout parameters erroring out

2025-02-09 Thread David Rowley
On Mon, 10 Feb 2025 at 17:34, Mukesh Tanuku wrote: > 2025-02-10 04:22:00.823 GMT [2468337] ERROR: trailing junk after numeric > literal at or near "5m" at character 28 > 2025-02-10 04:22:00.823 GMT [2468337] STATEMENT: SET idle_session_timeout = > 5min > 2025-02-10 04:22:03.487 GMT [2468342] E

Re: PG-15.6: timeout parameters erroring out

2025-02-09 Thread David G. Johnston
On Sunday, February 9, 2025, Mukesh Tanuku wrote: > > > > *idle_in_transaction_session_timeout = '1min'idle_session_timeout = '5min'* > I suspect our docs may need an update. They say you may include white space before the unit; it probably needs to be changed to “must”. I believe we’ve recentl

PG-15.6: timeout parameters erroring out

2025-02-09 Thread Mukesh Tanuku
Hello team, We unabled the postgres timeout parameters in the postgresql.conf file *idle_in_transaction_session_timeout = '1min'idle_session_timeout = '5min'* other way also, like below *idle_in_transaction_session_timeout = 6idle_session_timeout = 30* we see these errors reporting in

Re: Passwordcheck Extension Not Installing

2025-02-09 Thread Adrian Klaver
On 2/8/25 11:28, Cihat Küçükbağrıaçık wrote: Hi Community, I have a PostgreSQL 17.2 database running on Ubuntu 22.04. I'm trying to install the |passwordcheck| extension, but I keep getting a "file not found" error. postgres=# create extension passwordcheck; ERROR:  extension "passwordcheck"

Re: Passwordcheck Extension Not Installing

2025-02-09 Thread Tom Lane
=?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= writes: > I have a PostgreSQL 17.2 database running on Ubuntu 22.04. I'm trying to > install the passwordcheck extension, but I keep getting a "file not found" > error. > postgres=# create extension passwordcheck; > ERROR: extension "passwordchec