Postgres Pro
Downloads
Home   >   mailing lists

Re: ABRUPT CLOSURE OF POSTGRESQL SOCKET - Mailing list pgsql-novice

From Tom Lane
Subject Re: ABRUPT CLOSURE OF POSTGRESQL SOCKET
Date
Msg-id 20511.1098890855@sss.pgh.pa.us
Whole thread Raw
In response to ABRUPT CLOSURE OF POSTGRESQL SOCKET  ("Deepa K" <kdeepa@midascomm.com>)
List pgsql-novice
Tree view 
"Deepa K" <kdeepa@midascomm.com> writes:
>         I am running postgresql 7.1.3 in RedHat Linux 7.2.

You do realize that both your database and your OS are ancient versions
with many known bugs?

> NOTICE:  RelationBuildDesc: can't open pg_trigger: Too many open files in
> system

I think this is probably the source of the core dump --- the code
probably isn't prepared to recover from that.  You'll need to increase
the kernel limit on number of open files.  In recent PG versions you
could alternatively decrease max_files_per_process, but I'm pretty sure
7.1 did not have that setting ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Deepa K"
Date:
Subject: ABRUPT CLOSURE OF POSTGRESQL SOCKET
Next
From: Daniel Lerch
Date:
Subject: Can't edit pg_hba.conf; and, How do I restart postmaster?