Re: unknown postgres ssl error "could not accept SSL connection: Success" and timeout

[Rui DeSousa <rui@xxxxxxxxxxxxx>]

On May 4, 2023, at 4:16 AM, Holger Jakobs <holger@xxxxxxxxxx> wrote:

shared_buffers = 4GB
temp_buffers = 8MB
work_mem = 128MB
maintenance_work_mem = 128MB
dynamic_shared_memory_type = posix

bgwriter_lru_maxpages = 0
effective_io_concurrency = 3

wal_level = hot_standby

checkpoint_completion_target = 0.9

archive_mode = on
archive_command = '/bin/true'
archive_timeout = 300

max_standby_archive_delay = 21600
max_standby_streaming_delay = 21600

I should to update my openssl to see real error? How can i do that if i use ubuntu 18.04?

I am not sure what causes the problem, but some hints anyway:

max_connections = 10000
seems very high to me. In case you really have so many clients, consider using a connection pooler.

I would agree 10k connection seems excessive and the resource allocation doesn’t backup the use of that many connections.  I would assume lots of database stalls and memory contention for the shared buffer pool with only 4GB and anything approaching even a few thousand connections let alone 10k.