Re: [GENERAL] log_line_prefix

2013-11-16 Thread hubert depesz lubaczewski
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

Re: [GENERAL] log_line_prefix

2013-11-16 Thread Jayadevan
hubert depesz lubaczewski-2 wrote It looks like you're using csvlog. log_line_prefix is used only for stderr/syslog logging. Yes, that is right. Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/log-line-prefix-tp5778674p5778688.html Sent from the

[GENERAL] log_line_prefix

2013-11-15 Thread Jayadevan M
Hi, 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

Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

2007-12-02 Thread Andrus
That works fine for me... are you sure log_line_prefix is line 482 in your config file? You might have inadvertently put a superfluous % somewhere else. I use the config file below. I have added only some lines to the end of file, all other contents is from windows installer created conf

Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

2007-12-02 Thread Adrian Klaver
On Friday 30 November 2007 2:31 am, Andrus wrote: That works fine for me... are you sure log_line_prefix is line 482 in your config file? You might have inadvertently put a superfluous % somewhere else. I use the config file below. I have added only some lines to the end of file, all

Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

2007-12-02 Thread Tom Lane
Andrus [EMAIL PROTECTED] writes: I use the config file below. I have added only some lines to the end of file, all other contents is from windows installer created conf file. If I remove # sign in front of last line (line 482), and reload configuration, I got syntax error in log file. Is

[GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

2007-11-29 Thread Andrus
I added the following line to postgresql.conf file: log_line_prefix='%t %u %d %h %p %i %l %x ' but got error. 2007-11-29 12:40:41 LOG: syntax error in file D:/Program Files/PostgreSQL/8.2/data/postgresql.conf line 482, near token % I checked and all options are legal. What I'm doing wrong

Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

2007-11-29 Thread Paul Lambert
Andrus wrote: log_line_prefix='%t %u %d %h %p %i %l %x ' I checked and all options are legal. That works fine for me... are you sure log_line_prefix is line 482 in your config file? You might have inadvertently put a superfluous % somewhere else. -- Paul Lambert Database Administrator