Re: Max size per relation for partitioned tables

On Tue, 29 Oct 2024 at 22:01, Reftel, Bengt Erik Magnus wrote: > Thank you! I´ll try to make a change to the documentation to clarify that. Perhaps a new row after the "relation size" row with "partitioned table" and upper limit of "32TB * number of partitions" with a comment "individual partitio

Re: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

> On 29 Oct 2024, at 04:25, 馬　騰飛 wrote: > > Thank you very much for your reply. > However, after installing PostgreSQL 16.4, our server still encounters the > following error when connecting to the database, just like with version 16.3: > “Only AuthenticationClearTextPassword and Authentication

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

> 1) host=xx.xx.xx.100 = localhost? No, it is not > 2) In postgresql.conf what is listen_addresses set to? * > 3) What are the settings in /etc/hosts? Standard Ubuntu settings: 127.0.0.1 localhost 127.0.1.1 abc cde # The following lines are desirable for IPv6 capable hosts

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On Wed, 30 Oct 2024 at 00:04, Alan Hodgson wrote: > On Tue, 2024-10-29 at 16:30 +, Daniel Westermann (DWE) wrote: > > Delays between "connection received" and "connection authenticated" > because of localhost entries in hba > > > Maybe check that "files" is the first mechanism for hosts looku

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

>It might be worth searching our mailing list archives. I did that, but was not able to find anything useful related to this. Regards Daniel

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

>>Maybe check that "files" is the first mechanism for hosts lookups in >>nsswitch.conf. >afaik dig doesn't follow the same name resolution path as glibc. I don't know. Is there a way to test the glibc way easily? > a connection received should mean resolution was done, right ? am i missing > s

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On Wed, 2024-10-30 at 00:15 +0530, Vijaykumar Jain wrote: > > > On Wed, 30 Oct 2024 at 00:04, Alan Hodgson > wrote: > > On Tue, 2024-10-29 at 16:30 +, Daniel Westermann (DWE) wrote: > > > Delays between "connection received" and "connection > > > authenticated" because of localhost entries i

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On Tue, 2024-10-29 at 16:30 +, Daniel Westermann (DWE) wrote: > Delays between "connection received" and "connection authenticated" > because of localhost entries in hba Maybe check that "files" is the first mechanism for hosts lookups in nsswitch.conf. afaik dig doesn't follow the same name

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

"Daniel Westermann (DWE)" writes: > we're facing a strange issue with delays between "connection received" and > "connection authenticated". > Has anyone experienced such a behavior? It seems clear that this is somehow > related to name resolution but we couldn't reproduce something like this o

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On 10/29/24 10:42 AM, Daniel Westermann (DWE) wrote: 1) host=xx.xx.xx.100 = localhost? No, it is not Is the localhost machine on the same network? Is the client connection string using IPV4 address or host name? 2) In postgresql.conf what is listen_addresses set to? * 3) What are

Delays between "connection received" and "connection authenticated" because of localhost entries in hba

Delays between "connection received" and "connection authenticated" because of localhost entries in hba Hi, we're facing a strange issue with delays between "connection received" and "connection authenticated". # select version(); v

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On 10/29/24 09:30, Daniel Westermann (DWE) wrote: Delays between "connection received" and "connection authenticated" because of localhost entries in hba Hi, we're facing a strange issue with delays between "connection received" and "connection authenticated". # select version();

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On Wed, 30 Oct 2024 at 00:40, Alan Hodgson wrote: > Well, I'm just throwing out something to check, but I meant on the server, > not the client. It's trying to resolve "localhost" to check the auth. If > there's a delay, that's probably where it is. > > I guess I just assumed that's where you wer

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On 10/29/24 11:20 AM, Vijaykumar Jain wrote: missed the mailing list. Can you provide a more complete explanation for above? -- Adrian Klaver adrian.kla...@aklaver.com

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

missed the mailing list.

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On Tue, 29 Oct 2024 at 23:43, Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > > > On Tue, 29 Oct 2024 at 22:00, Daniel Westermann (DWE) < > daniel.westerm...@dbi-services.com> wrote: > >> Delays between "connection received" and "connection authenticated" >> because of localhost entrie

Re: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

On 10/29/24 04:01, Daniel Gustafsson wrote: On 29 Oct 2024, at 04:25, 馬　騰飛 wrote: Thank you very much for your reply. However, after installing PostgreSQL 16.4, our server still encounters the following error when connecting to the database, just like with version 16.3: “Only AuthenticationCle

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

>Maybe check that "files" is the first mechanism for hosts lookups in >nsswitch.conf. It is

Re: Delays between "connection received" and "connection authenticated" because of localhost entries in hba

On Tue, 2024-10-29 at 16:30 +, Daniel Westermann (DWE) wrote: > we're facing a strange issue with delays between "connection received" and > "connection authenticated". > > # select version(); >   version > --

Re: Max size per relation for partitioned tables

Wednesday, 23 October 2024 at 23:48, David G. Johnston wrote: > On Wednesday, October 23, 2024, Reftel, Bengt Erik Magnus > wrote: >> Appendix K of the documentation, >> https://www.postgresql.org/docs/current/limits.html, lists 32TB as the >> maximum >>

RE: Compatibility Issues with Npgsql and .NET Framework 3.5 after Upgrading to PostgreSQL 16.3

Thank you very much for your reply. However, after installing PostgreSQL 16.4, our server still encounters the following error when connecting to the database, just like with version 16.3: “Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10”. Could