Rob Brucks rob.brucks at rackspace.com
Mon Feb 29 12:59:06 PST 2016
Thanks Steve.  Yes, without a config file I get timestamps.

And I spent some time today trying to figure out which parameter is causing this behavior.  It seems to only be happening if "SYSLOG" is set to anything other than zero.

We prefer a SYSLOG setting of 1 because we have a central syslog logging and reporting facility where the messages are sent.  But the DEBUG level messages are important to us too, and they only get sent to the slony log file, but they don't have timestamps (making them far less useful).


Which brings up another problem, why don't DEBUG messages get sent to syslog too?  If they were in syslog then we could set SYSLOG=3 and be done with it.

So, IMHO, two bugs:

1) No timestamp in the slon daemon logs when SYSLOG=1
2) Slon daemon DEBUG messages never get sent to SYSLOG with any setting.


Thanks,
Rob


On 2/29/16, 12:11 PM, "Steve Singer" <ssinger at ca.afilias.info> wrote:

>On 02/26/2016 04:30 PM, Rob Brucks wrote:
>> I have Slony 2.2.4 installed on Centos 6.7 x86_64 from the PGDG 9.3 repo.
>>
>> No matter what settings I set in the slony.conf file, I cannot get the
>> Slon daemon to include timestamps in the slon log output.
>>
>
>What output do you get if you start slon without a config file.
>
>When I start slon  I get
>
>slon  test 'host=localhost port=5432 dbname=test2'
>2016-02-29 09:24:42 EST CONFIG main: slon version 2.3.0 starting up
>2016-02-29 09:24:42 EST INFO   slon: watchdog process started
>2016-02-29 09:24:42 EST CONFIG slon: watchdog ready - pid = 25047
>2016-02-29 09:24:42 EST CONFIG slon: worker process created - pid = 25048
>2016-02-29 09:24:42 EST CONFIG main: Integer option vac_frequency = 3
>2016-02-29 09:24:42 EST CONFIG main: Integer option log_level = 0
>2016-02-29 09:24:42 EST CONFIG main: Integer option sync_interval = 2000
>2016-02-29 09:24:42 EST CONFIG main: Integer option 
>sync_interval_timeout = 10000
>
>
>the timestamps are printed.
>
>
>What if you leave all of
>log_timestamp, log_timestamp_format out of the config file.
>
>
>
>
>
>> I've tried changing both "log_timestamp" and "log_timestamp_format"
>> settings in various combinations ("true","yes","1", etc.; even "no" in
>> the hopes it was mistakenly coded backwards) without any success.
>>
>> I know that the Slon daemon is using this config file because I have the
>> DB connection set in it and if I change it then it fails to connect.
>>
>> The lack of timestamps makes it incredibly difficult to diagnose
>> problems after they occur.
>>
>> I have tried enabling syslog logging, but the syslog logging doesn't
>> include all the output that goes to the slon log.
>>
>> Any suggestions to get timestamps working would be greatly appreciated!
>>
>> Thanks,
>> Rob
>>
>>
>> _______________________________________________
>> Slony1-bugs mailing list
>> Slony1-bugs at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-bugs
>>
>


More information about the Slony1-bugs mailing list