[GENERAL] PGError: server closed the connection unexpectedly

2006-01-08 Thread Dave Steinberg
mem(kbytes)635424 memory(kbytes) 1905136 nofiles(descriptors) 768 processes532 - postgresql.conf changes: max_connections = 200 syslog_facility = 'LOCAL0' syslog_ident = 'postgres' log_duration = true stats_start_collector = true stats_command_string = fal

Re: [GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Dave Steinberg
s will fix it). This one I should have guessed - I dealt with similar stuff in perl somewhat recently. The pg_dumpall problem... I'll crank the debug level and see if there's anything interesting there, and if so I'll post about it again. Thanks Doug! -- Dave Steinberg htt

Re: [GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Dave Steinberg
"host_id" = 4, "status" = 'in_progress', "output" = NULL WHERE job_member_id = 105 DEBUG: proc_exit(0) DEBUG: shmem_exit(0) LOG: disconnection: session time: 0:00:00.84 user=geekispv2 database=geekisp-v2-test host=192.168.4.38 port=31992 DEBUG: exit(

[GENERAL] PGError: server closed the connection unexpectedly

2006-01-07 Thread Dave Steinberg
vel = false stats_row_level = false Thanks in advance! PS - My apologies if this is a dup! -- Dave Steinberg http://www.geekisp.com/ http://www.steinbergcomputing.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster