On Jan 25, 2008 2:23 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Chris Hoover" <revoohc@gmail.com> 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!