Re: [NOVICE] ABRUPT CLOSURE OF POSTGRESQL SOCKET

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Deepa K" <kdeepa(at)midascomm(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [NOVICE] ABRUPT CLOSURE OF POSTGRESQL SOCKET
Date: 2004-10-27 15:27:35
Message-ID: 20511.1098890855@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

"Deepa K" <kdeepa(at)midascomm(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-27 15:29:39 Re: Resource temporarily unavailable
Previous Message Tom Lane 2004-10-27 15:13:13 Re: Comment on timezone and interval types

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel Lerch 2004-10-27 17:57:17 Can't edit pg_hba.conf; and, How do I restart postmaster?
Previous Message Paul Daniels 2004-10-27 14:30:23 using postgreSQL with MS-IIS and eGroupWare