Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group