Re: Postgresql database terminates abruptly with too many open files error

2025-01-15 Thread Sri Mrudula Attili
quota. Thanks, Sri On 14/01/2025 14:19, Tom Lane wrote: 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

Postgresql database terminates abruptly with too many open files error

2025-01-14 Thread 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 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

Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.

2023-11-29 Thread Sri Mrudula Attili
and it hasnt got any error like this. Thanks, Sri Attili On 27/11/2023 18:58, Laurenz Albe wrote: On Mon, 2023-11-27 at 11:50 +, Sri Mrudula Attili wrote: ERROR:  could not access status of transaction 16087052 DETAIL:  Could not read from file "pg_subtrans/00F5" at off

Re:Could not read from file "pg_subtrans/00F5" at offset 122880: Success.

2023-11-27 Thread Sri Mrudula Attili
Hello, Post refresh of a Delphix VDB , while trying to connect from application users are getting the below error. Could also see these errors in postgresql.log Error Message: < 2023-11-24 12:24:10.031 GMT >ERROR:  could not access status of transaction 16087052 < 2023-11-24 12:24:10.031 GM