From: | Vucomir Ianculov <vukomir(at)os-ux(dot)com> |
---|---|
To: | Vitalii Tymchyshyn <vit(at)tym(dot)im> |
Cc: | pgsql-performance(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: pgsql connection timeone |
Date: | 2017-02-17 16:52:18 |
Message-ID: | 306197590.922.1487350339971.JavaMail.vukomir@DESKTOP-OI0VS1P |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
sorry for the late replay, i have check but from what i see this is on the application side.
i'm not able to login to postgres from the command line.
dose anyone have any other ideas on this problem.
Br,
vuko
----- Original Message -----
From: "Vitalii Tymchyshyn" <vit(at)tym(dot)im>
To: "Vucomir Ianculov" <vukomir(at)os-ux(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Saturday, February 4, 2017 8:38:34 PM
Subject: Re: [PERFORM] pgsql connection timeone
Well, you can try switching to urandom, see http://stackoverflow.com/questions/137212/how-to-solve-performance-problem-with-java-securerandom , second answer.
сб, 4 лют. 2017 о 11:45 Vucomir Ianculov < vukomir(at)os-ux(dot)com > пише:
Hi Vitalii,
no, hove can i check it? searched but did not find any useful information .
Thanks,
Br,
Vuko
From: "Vitalii Tymchyshyn" < vit(at)tym(dot)im >
To: "Vucomir Ianculov" < vukomir(at)os-ux(dot)com >, "Tom Lane" < tgl(at)sss(dot)pgh(dot)pa(dot)us >
Cc: pgsql-performance(at)postgresql(dot)org
Sent: Wednesday, February 1, 2017 7:11:12 PM
Subject: Re: [PERFORM] pgsql connection timeone
Just a wild guess, but did you check your random source? We had similar problems in Oracle and had to switch to /dev/urandom. It can be done with a system variable setting.
On Wed, Feb 1, 2017, 7:52 AM Vucomir Ianculov < vukomir(at)os-ux(dot)com > wrote:
<blockquote>
can anyone help me with my problem?
i'm really don't know from when the problem can be.
From: "Vucomir Ianculov" < vukomir(at)os-ux(dot)com >
To: "Tom Lane" < tgl(at)sss(dot)pgh(dot)pa(dot)us >
Cc: pgsql-performance(at)postgresql(dot)org
Sent: Saturday, January 28, 2017 12:03:55 PM
Subject: Re: [PERFORM] pgsql connection timeone
Hi Tom,
this is the entry from pg_hba.conf
host all all 0.0.0.0/0 md5
i needed to restart postgres service to be able to accept new connection, witch it strange becouse there was no load on the server and it head a lot of free ram.
From: "Tom Lane" < tgl(at)sss(dot)pgh(dot)pa(dot)us >
To: "Vucomir Ianculov" < vukomir(at)os-ux(dot)com >
Cc: pgsql-performance(at)postgresql(dot)org
Sent: Wednesday, January 25, 2017 3:15:28 PM
Subject: Re: [PERFORM] pgsql connection timeone
Vucomir Ianculov < vukomir(at)os-ux(dot)com > writes:
> i'm seeing a lot of connection time out in postgresql log
> 2017-01-25 11:09:47 EET [6897-1] XXX(at)YYY FATAL: canceling authentication due to timeout
> 2017-01-25 11:10:15 EET [6901-1] XXX(at)YYY FATAL: canceling authentication due to timeout
> 2017-01-25 11:10:17 EET [6902-1] xxx(at)YYY FATAL: canceling authentication due to timeout
So ... what authentication method are you using?
regards, tom lane
</blockquote>
From | Date | Subject | |
---|---|---|---|
Next Message | Hustler DBA | 2017-02-17 22:19:00 | Number of characters in column preventing index usage |
Previous Message | Tom Lane | 2017-02-17 16:39:40 | Re: Correct use of cursors for very large result sets in Postgres |