Обсуждение: server closed the connection unexpectedly

A psql connection was started from one Linux machine, talking to the Postgres server on another Linux machine (both the postgres client and the Postgres server are 8.2.4). Got the following error:

If this a Postgres disconnection or a disconnection on the OS side?

Thanks!!!

 

server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
 The connection to the server was lost. Attempting reset: Succeeded.
 \copy: server closed the connection unexpectedly
         This probably means the server terminated abnormally
        before or while processing the request.

---

Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.

Jessica Richard <rjessil@yahoo.com> writes:
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.

> If this a Postgres disconnection or a disconnection on the OS side?

Well, you can't tell for certain from the client side.  The postmaster
log would tell.  But unless you have a flaky network, this is probably
the result of a backend crash :-(.  Can you reproduce it, or get a gdb
stack trace?

            regards, tom lane