Re: Connection Taking time to authentication of database

From: Samed YILDIRIM <samed(at)reddoc(dot)net>
To: Vivek Gadge <vvkgadge56(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Connection Taking time to authentication of database
Date: 2023-01-18 08:48:13
Message-ID: CAAo1mbnxy8ftkq3jCFV2o9uFQ3ErOxdUyQc2or9SKFLX+iwRKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Vivek,

- Have you checked logs? What do logs say?
- What is the programming language you use?
- Is there any pooling on application side or between application and
database?
- Do you use ssl? Have you checked entropy on both sides?
- Are you sure that authentication takes long time? Would it be a network
issue, such as running out of free port?
- what are operating systems on which application and postgresql run?

Best regards.
Samed YILDIRIM

On Wed, 18 Jan 2023, 10:42 Vivek Gadge, <vvkgadge56(at)gmail(dot)com> wrote:

> Hi All,
>
> From few days I am facing an issue while connecting to PostgreSQL
> database. It took 20sec to make a connection from application Currently I
> am using PostgreSQL v13.5. Could you please provide me some input on this.
>
> Thanks and regards
>
> Vivek Gadge.
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-01-18 09:49:57 Re: Connection Taking time to authentication of database
Previous Message Vivek Gadge 2023-01-17 17:32:26 Connection Taking time to authentication of database