Re: PostgreSQL unexpectedlly closes the connection - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: PostgreSQL unexpectedlly closes the connection
Date
Msg-id 20060827201458.GA38002@winnie.fuhr.org
Whole thread Raw
In response to PostgreSQL unexpectedlly closes the connection  (João Miguel Ferreira <jmf@estg.ipvc.pt>)
Responses Re: PostgreSQL unexpectedlly closes the connection  (Julian Hagenauer <chaosbringer@gmx.de>)
List pgsql-novice
On Sun, Aug 27, 2006 at 08:23:37PM +0100, Joo Miguel Ferreira wrote:
> I'm developing a program (daemon) in Perl. This program colects
> system information and stores in Pg via perl-DBI and perl-DBD-Pg.
>
> The performance is totally great... but once in a while I the server
> closes the connection when I try to do an Insert/Update/Delete...
>
> The Perl-DBI error is +/- something like this "... server closed the
> connection unexpectedlly..."...

Have you looked in the PostgreSQL server logs?  The cause might
appear there, especially if the server is crashing.

What version of PostgreSQL are you running and on what platform?
Have you added any third-party modules?

--
Michael Fuhr

pgsql-novice by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: PostgreSQL unexpectedlly closes the connection
Next
From: Julian Hagenauer
Date:
Subject: Re: PostgreSQL unexpectedlly closes the connection