Обсуждение: 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