On sob, lis 16, 2013 at 08:44:52 +0530, Jayadevan M wrote:
> I was trying different options of log_line_prefix. I am making chnages,
> doing a pg_ctl reload and checking the output in the log files. For some
> reason ,the changes seem to have no impact. What am I doing wrong? Here is
> the output form the log files where you can see the change being accepted
> (reload) and then the output of a select now().
> 2013-11-16 08:24:50.657 IST,,,3186,,5286c0d6.c72,5,,2013-11-16 06:18:22
> IST,,0,LOG,00000,"received SIGHUP, reloading configuration files",,,,,,,,,""
> 2013-11-16 08:24:50.657 IST,,,3186,,5286c0d6.c72,6,,2013-11-16 06:18:22
> IST,,0,LOG,00000,"parameter ""log_line_prefix"" changed to ""%t
> """,,,,,,,,,""
It looks like you're using csvlog. log_line_prefix is used only for
stderr/syslog logging.
Best regards,
depesz