Re: Max connections reached without max connections reached

2021-12-05 Thread James Sewell
+1, I too like the idea. The patch doesn't seem to be doing any heavy > lifting, I think that much overhead should be acceptable. > I'm guessing this won't be back-patched? Is it possible to somehow read this information from a C function? - James -- The contents of this email are confidential

Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11

2021-12-05 Thread Kyotaro Horiguchi
At Fri, 3 Dec 2021 15:41:51 +0800, Yi Sun wrote in > Hi Kyotaro, > > Thank you for your explanation, after putting the crl file to client, it > works now, thanks. Good to hear that. That portion of the documentation has been fixed on the repository, and it will be released in the next minor

Re: Max connections reached without max connections reached

2021-12-05 Thread Amul Sul
On Mon, Dec 6, 2021 at 6:11 AM James Sewell wrote: >> >> Agreed with both points. What about we add, subxid count and overflow >> status in LocalPgBackendStatus and through that, we can show in >> pg_stat_activity. That way we don't have to report it ever and >> whenever the user is running

Re: Max connections reached without max connections reached

2021-12-05 Thread James Sewell
> > Agreed with both points. What about we add, subxid count and overflow > status in LocalPgBackendStatus and through that, we can show in > pg_stat_activity. That way we don't have to report it ever and > whenever the user is running pg_stat_activity they can fetch it > directly from

Re: libpq: Which functions may hang due to network issues?

2021-12-05 Thread Daniel Frey
> On 5. Dec 2021, at 17:01, Tom Lane wrote: > > Daniel Frey writes: >> With all that said, I think that PostgreSQL/libpq should have a clear, >> documented way to get rid of a connection that is guaranteed to not hang. It >> has something similar for almost all other methods like opening

Re: libpq: Which functions may hang due to network issues?

2021-12-05 Thread Tom Lane
Daniel Frey writes: > With all that said, I think that PostgreSQL/libpq should have a clear, > documented way to get rid of a connection that is guaranteed to not hang. It > has something similar for almost all other methods like opening connections, > sending request, retrieving results. Why

Re: Max connections reached without max connections reached

2021-12-05 Thread Dilip Kumar
On Sun, Dec 5, 2021 at 10:55 AM Dilip Kumar wrote: > > On Fri, Dec 3, 2021 at 9:02 PM Tom Lane wrote: > > > > Dilip Kumar writes: > > > On Thu, Dec 2, 2021 at 9:35 AM Dilip Kumar wrote: > > >> I think there is no such view or anything which tells about which > > >> backend or transaction has

Re: libpq: Which functions may hang due to network issues?

2021-12-05 Thread Daniel Frey
> On 4. Dec 2021, at 22:43, Laurenz Albe wrote: > > On Fri, 2021-12-03 at 21:33 +0100, Daniel Frey wrote: >> But the real issue, at least for me, is PQfinish(). Considering that my >> application is not >> allowed to hang (or crash, leak, ...), what should I do in case of a timeout? > > I am