pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
server closed the connection unexpectedly
3+ messages / 3 participants
[nested] [flat]

* server closed the connection unexpectedly
@ 2003-03-11 09:23 shreedhar <shreedhar@lucidindia.net>
  0 siblings, 0 replies; 3+ messages in thread

From: shreedhar @ 2003-03-11 09:23 UTC (permalink / raw)
  To: pgsql-admin; Postgre General <pgsql-general@postgresql.org>

Hi All,

If I tried to do any transaction with database i am getting following error. Server is restarting automatically very frequently.

server closed the connection unexpectedly

This probably means the server terminated abnormally

before or while processing the request.

connection to server was lost

Can any body tell what's the reason.

Regards,

Sreedhar

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* server closed the connection unexpectedly
@ 2007-08-20 20:03 Jessica Richard <rjessil@yahoo.com>
  2007-08-21 03:40 ` Re: server closed the connection unexpectedly Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Jessica Richard @ 2007-08-20 20:03 UTC (permalink / raw)
  To: pgsql-admin

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. 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: server closed the connection unexpectedly
  2007-08-20 20:03 server closed the connection unexpectedly Jessica Richard <rjessil@yahoo.com>
@ 2007-08-21 03:40 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2007-08-21 03:40 UTC (permalink / raw)
  To: Jessica Richard <rjessil@yahoo.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-08-21 03:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-11 09:23 server closed the connection unexpectedly shreedhar <shreedhar@lucidindia.net>
2007-08-20 20:03 server closed the connection unexpectedly Jessica Richard <rjessil@yahoo.com>
2007-08-21 03:40 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox