Re: PostgreSQL unexpectedlly closes the connection

[Michael Fuhr <mike(at)fuhr(dot)org>]

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