Re: why my postgresql auto crashed???

Hi

When creating a new thread (asking a new question, etc) on a mailing
list please create a new message rather than replying to an existing
one. It helps people reading the mailing list keep track.

> so, I check the pg_log
> ------------
> TRAP: FailedAssertion("!(file->curFile >= 0)", File: "buffile.c", Line:
> 317)
> LOG: server process (PID 4121) was terminated by signal 6: Aborted

This `postgres' backend detected a problem and terminated its self by
calling abort().

This forced the postmaster to terminate all other backends and restart
the whole server.

You omitted some very important information from your post, including:

- Your PostgreSQL version
- Your operating system
- The version of your operating system
- How you installed PostgreSQL and where you got it from
- Whether the problem is repeatable, ie does the server crash every time
you issue the problem command? Sometimes? Only ever happened once?

--
Craig Ringer