On Wed, Jul 27, 2005 at 06:48:35PM +0400, Vladimir D Belousov wrote:
> test=# select * from myint(5);
> 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: Failed.
Did you get a core dump? In released versions of PostgreSQL core
dumps are usually under $PGDATA/base/<database oid>, although some
systems can be configured to put them elsewhere (e.g., by using
FreeBSD's kern.corefile sysctl setting). If you got a core dump
then it might be useful to see a stack trace. If you didn't get a
core dump then you might need to change the coredumpsize resource
setting so you do get one.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/