Thread: BUG #4861: Incorrect log_line_prefix default value in postgresql.conf

The following bug has been logged online:

Bug reference:      4861
Logged by:          Dmitry Ryabov
Email address:      dmitry-ryabov@mail.ru
PostgreSQL version: 8.4rc1
Operating system:   Windows
Description:        Incorrect log_line_prefix default value in
postgresql.conf
Details:

log_line_prefix = '%%t '
(must be log_line_prefix = '%t ')

Dmitry Ryabov wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4861
> Logged by:          Dmitry Ryabov
> Email address:      dmitry-ryabov@mail.ru
> PostgreSQL version: 8.4rc1
> Operating system:   Windows
> Description:        Incorrect log_line_prefix default value in
> postgresql.conf
> Details:
>
> log_line_prefix = '%%t '
> (must be log_line_prefix = '%t ')

The Postgres community ships a log_line_prefix of:

    #log_line_prefix = ''                   # special values:

if you look at share/postgresql.conf.sample you will see that line too.
I think you need to look elsewhere about how that got set to '%%t';  I
have no idea.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

"Dmitry Ryabov" <dmitry-ryabov@mail.ru> writes:
> Description:        Incorrect log_line_prefix default value in
> postgresql.conf

> log_line_prefix = '%%t '
> (must be log_line_prefix = '%t ')

Uh, the default setting is an empty string.  Are you sure this is
not your own error?  If it isn't, perhaps it is a problem in some
packaging of Postgres, but you did not say which package you are
using.

            regards, tom lane

Tom Lane написа:
> "Dmitry Ryabov" <dmitry-ryabov@mail.ru> writes:
>> Description:        Incorrect log_line_prefix default value in
>> postgresql.conf
>
>> log_line_prefix = '%%t '
>> (must be log_line_prefix = '%t ')
>
> Uh, the default setting is an empty string.  Are you sure this is
> not your own error?  If it isn't, perhaps it is a problem in some
> packaging of Postgres, but you did not say which package you are
> using.

The line looks like that after using the One-click installer
available here - http://www.enterprisedb.com/products/pgdownload.do.

Probably should be sorted out by EnterpriseDB.



--
Milen A. Radev

Milen A. Radev wrote:
> Tom Lane ??????:
> > "Dmitry Ryabov" <dmitry-ryabov@mail.ru> writes:
> >> Description:        Incorrect log_line_prefix default value in
> >> postgresql.conf
> >
> >> log_line_prefix = '%%t '
> >> (must be log_line_prefix = '%t ')
> >
> > Uh, the default setting is an empty string.  Are you sure this is
> > not your own error?  If it isn't, perhaps it is a problem in some
> > packaging of Postgres, but you did not say which package you are
> > using.
>
> The line looks like that after using the One-click installer
> available here - http://www.enterprisedb.com/products/pgdownload.do.
>
> Probably should be sorted out by EnterpriseDB.

I just checked the one-click 8.4rc1 installer on Ubuntu and it is fine:

    #log_line_prefix = ''                   # special values:

so I am unclear why Windows would have a different default.  How are you
viewing this default?  From the command line?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Bruce Momjian написа:
> Milen A. Radev wrote:
>> Tom Lane ??????:
>>> "Dmitry Ryabov" <dmitry-ryabov@mail.ru> writes:
>>>> Description:        Incorrect log_line_prefix default value in
>>>> postgresql.conf
>>>> log_line_prefix = '%%t '
>>>> (must be log_line_prefix = '%t ')
>>> Uh, the default setting is an empty string.  Are you sure this is
>>> not your own error?  If it isn't, perhaps it is a problem in some
>>> packaging of Postgres, but you did not say which package you are
>>> using.
>> The line looks like that after using the One-click installer
>> available here - http://www.enterprisedb.com/products/pgdownload.do.
>>
>> Probably should be sorted out by EnterpriseDB.
>
> I just checked the one-click 8.4rc1 installer on Ubuntu and it is fine:
>
>     #log_line_prefix = ''                   # special values:
>
> so I am unclear why Windows would have a different default.  How are you
> viewing this default?  From the command line?
>


I've attached the unmodified "postgresql.conf" just after a
successful installation (it is in "C:\Program
Files\PostgreSQL\8.4\data").

Connecting to the server locally with psql gives:


Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
psql (8.4rc1)
WARNING: Console code page (866) differs from Windows code page (1251)
          8-bit characters might not work correctly. See psql reference
          page "Notes for Windows users" for details.
Type "help" for help.

postgres=# show log_line_prefix;
  log_line_prefix
-----------------
  %%t
(1 row)


postgres=#




--
Milen A. Radev

On Thu, Jun 18, 2009 at 11:44 PM, Milen A. Radev<milen@radev.net> wrote:
> Tom Lane =CE=C1=D0=C9=D3=C1:
>>
>> "Dmitry Ryabov" <dmitry-ryabov@mail.ru> writes:
>>>
>>> Description: =9A =9A =9A =9AIncorrect log_line_prefix default value in
>>> postgresql.conf
>>
>>> log_line_prefix =3D '%%t '
>>> (must be log_line_prefix =3D '%t ')
>>
>> Uh, the default setting is an empty string. =9AAre you sure this is
>> not your own error? =9AIf it isn't, perhaps it is a problem in some
>> packaging of Postgres, but you did not say which package you are
>> using.
>
> The line looks like that after using the One-click installer available he=
re
> - http://www.enterprisedb.com/products/pgdownload.do.
>
> Probably should be sorted out by EnterpriseDB.

Thanks - on it.

--=20
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com