Hello Team,
We have a postgresql VDB(virtual database- Delphix) that keeps
terminating due "to too many open files".
Below are few alerts that we could see from the postgresql.log
< 2025-01-14 11:37:20.724 GMT >LOG: out of file descriptors: Too many
open files in system; release and retry
On Tue, 14 Jan 2025 at 03:45, Eşref Halıcıoğlu
wrote:
> I do not fully understand the logic of this issue. I would be very grateful
> if you can share information on the subject.
>
> The query plan is as follows.
>
> Update on "test_table1" tt1 (cost=0.13..159112.84 rows=0 width=0)
> Update on
> On 13 Jan 2025, at 20:11, Fakarai, Edgar wrote:
> I am encountering a Certification verification error whenever I want to
> install pgAgent from stackbuilder on Windows OS. I have attached the
> screenshot of the error message.
> Thank you. If I take yes it gives me another error check the se
Hello, Okay, thank you very much, Mr. David, for your support and the information, Eşref To: Eşref Halıcıoğlu (esref.halicio...@primeit.com.tr);Cc: pgsql-general@lists.postgresql.org;Subject: About PostgreSQL Query Plan;14.01.2025, 13:09, "David Rowley" :On Tue, 14 Jan 2025 at 03:45
Hello,
Have you checked something like lsof to see open file descriptors to see?
Cheers,
frank
Am 14.01.25 um 13:58 schrieb Sri Mrudula Attili:
Hello Team,
We have a postgresql VDB(virtual database- Delphix) that keeps terminating due "to
too many open files".
Below are few alerts that w
On Tue, Jan 14, 2025 at 7:58 AM Sri Mrudula Attili wrote:
> Hello Team,
>
> We have a postgresql VDB(virtual database- Delphix) that keeps
> terminating due "to too many open files".
>
> Below are few alerts that we could see from the postgresql.log
>
>
> < 2025-01-14 11:37:20.724 GMT >LOG: ou
Sri Mrudula Attili writes:
> We have a postgresql VDB(virtual database- Delphix) that keeps
> terminating due "to too many open files".
What do you have max_connections set to, and how many actually-live
server processes are there typically?
> The number of allowed openfiles at OS level are 6
On 1/13/25 11:56 PM, Enrico Schenone wrote:
Il 13/01/25 18:26, Adrian Klaver ha scritto:
In your OP you stated:
"Production environments can be:
* Distinct application server and DB server on distinct subnets (no
dropped packet detected on firewall, no memory/disk/network failure
Hi, ALL,
This concern both libpq and DBC API.
Hopefully I can get answers on both.
Than yu.
-- Forwarded message -
From: Igor Korot
Date: Tue, Jan 14, 2025 at 12:50 AM
Subject: Lock in postgreSQL
To: pgsql-generallists.postgresql.org
, PostgreSQL ODBC list
Hi, ALL,
https://
On 1/14/25 10:42 AM, Igor Korot wrote:
Hi, ALL,
This concern both libpq and DBC API.
Hopefully I can get answers on both.
Read:
https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS
Than yu.
-- Forwarded message -
From: Igor Korot
Date: Tue, Ja
Il 14/01/25 18:56, Adrian Klaver ha scritto:
On 1/13/25 11:56 PM, Enrico Schenone wrote:
Il 13/01/25 18:26, Adrian Klaver ha scritto:
In your OP you stated:
"Production environments can be:
* Distinct application server and DB server on distinct subnets (no
dropped packet detected
11 matches
Mail list logo
