On Jan 25, 2008 2:23 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Chris Hoover" <[EMAIL PROTECTED]> writes: > > In the noon log, I have this entry: > > 2008-01-25 12:00:00.063 EST,,,3040,,479a01f1.be0,2,,2008-01-25 10:36:17 > > EST,,0,LOG,00000,"system logger process (PID 3041) was terminated by > signal > > 6: Aborted",,,,,,,, > > > In the 1400 log, I have this entry: > > 2008-01-25 14:00:00.898 EST,,,3040,,479a01f1.be0,3,,2008-01-25 10:36:17 > > EST,,0,LOG,00000,"system logger process (PID 3391) was terminated by > signal > > 6: Aborted",,,,,,,, > > System logger, eh? What are all your non-default logging parameter > settings? > > The corefiles are not going to be useful to anyone else with a different > setup. Please use gdb to get a backtrace from them yourself. > > regards, tom lane >
Ok, I have not done much debugging. How do I go about getting the backtrace for you. Here is the config settings for the log settings: #------------------------------------------------------------------------------ # ERROR REPORTING AND LOGGING #------------------------------------------------------------------------------ # - Where to Log - log_destination = 'syslog,csvlog' # Valid values are combinations of logging_collector = on # Enable capturing of stderr and csvlog log_directory = 'pg_log' # directory where log files are written, log_truncate_on_rotation = on # If on, an existing log file of the log_rotation_age = 1h # Automatic rotation of logfiles will log_rotation_size = 0 # Automatic rotation of logfiles will syslog_facility = 'LOCAL0' syslog_ident = 'postgres' log_min_duration_statement = 0 # -1 is disabled, 0 logs all statements log_checkpoints = on log_connections = on log_disconnections = on log_duration = on log_line_prefix = '%d,%p,%u,%r,%p,%m,%c,%l,%s,%v,%x,%i: ' log_lock_waits = on # log lock waits >= deadlock_timeout log_statement = 'all' # none, ddl, mod, all Thanks, Chris -- Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution!