"Deepa K" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly