Re: pl/perl error - Mailing list pgsql-general

From Tom Lane
Subject Re: pl/perl error
Date
Msg-id 14524.1144621360@sss.pgh.pa.us
Whole thread Raw
In response to pl/perl error  (Frank <archon@forbidden.dough.net>)
Responses Re: pl/perl error
List pgsql-general
Frank <archon@forbidden.dough.net> writes:
> I have a perl script running as a daemon.  It's using DBD::Pg (1.43) to
> connect to my Postgres server (8.0.7) running on the same box and talking
> over a socket.  When I start the server, it runs fine for about a day, and
> then at some point I start getting this error repeatedly:

> DBD::Pg::db do failed: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.

Do you see any complaint in the postmaster log when this happens?  If so
what?

I'd personally wonder about a memory leak or something like that in your
trigger functions.

            regards, tom lane

pgsql-general by date:

Previous
From: Tyler MacDonald
Date:
Subject: Re: Debian package for freeradius_postgresql module
Next
From: Michael Glaesemann
Date:
Subject: Re: advice on schema for multilingual text