Re: Log messages of the server?

Lists: pgsql-hackers-win32
From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Joerg Hessdoerfer" <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>, "PostgreSQL Win32 port list" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Log messages of the server?
Date: 2004-11-08 09:42:08
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE4760DD@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers-win32

> Hi,
>
> just a quick question: I've installed test-drives of the
> PostgreSQL 8.0 beta installers (all versions, up to and
> including beta4), on win2k, XP Pro and XP home, they all
> worked fine starting the postmaster as service under user
> postgres. I just realized, though, that I had a problem
> upgrading one machine from beta2 to beta3, though. The
> service didn't start, because an initdb was required. But I
> didn't see any eventlog messages (that's where a windows user
> would look first, naturally). After more careful scrutiny, I
> did not find
> *ANY* server log messages. Where does the installer set
> logging to? Is logging to eventlog even implemented? How to
> configure it?

There has been a debate about where to log, and the end result was not
to default to eventlog. You can enable eventlogging by editing
postgresql.conf, look for the parameter "log_destination".
Log files by default go into the pg_log subdirectory of the data
directory.

//Magnus


From: Joerg Hessdoerfer <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "PostgreSQL Win32 port list" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Log messages of the server?
Date: 2004-11-08 10:05:08
Message-ID: 200411081105.08468.Joerg.Hessdoerfer@sea-gmbh.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers-win32

Hi,

On Monday 08 November 2004 10:42, you wrote:
[...]
>
> There has been a debate about where to log, and the end result was not
> to default to eventlog. You can enable eventlogging by editing
> postgresql.conf, look for the parameter "log_destination".
> Log files by default go into the pg_log subdirectory of the data
> directory.
>
> //Magnus

Ok, thanks for the info. I'll have a look. Just a suggestion: as this is
fairly non-obvious, couldn't the installer just ask where to set logging to?

Thanks,
Jörg
--
Leading SW developer - S.E.A GmbH
Mail: joerg(dot)hessdoerfer(at)sea-gmbh(dot)com
WWW: http://www.sea-gmbh.com