Harald Armin Massa wrote:
> PostgreSQL 8.1.5 and 8.2.1
> both on W2K3, installed from the standard win32 msi installer.
> in postgresql.conf
> but the files server.key etc. are NOT present.
> Result: PostgreSQL service does not start. And no error message in any
> log I could access: nothing in the Windows Event Log, nothing in the
> pg_log (not even starts a file)
> [in this case it was me doing the SSL-setup, missing to copy the key
> files; BUT... they could get deleted / made inaccessible a later time,
> and THEN it get's impossible to diagnose the problem]
> Proposed solution:
> write an error message to pg_log/ or windows event log on missing
I took a quick look at this, and it's certainly correct. If I change the
log_destination to be eventlog, it works and logs the proper error message.
This may show a much bigger problem. When we have set redirect_stderr
(which is what the MSI installer does by default), what happens to
everything that is logged *before* SysLogger_Start()? There are a lot of
startup things that happen then, but where does the output go?
I'm thinking we need a check in elog.c on the:
if ((!Redirect_stderr || am_syslogger) && pgwin32_is_service())
line, that checks if the syslogger process has been started yet. So it'd
be something like
if ((!Redirect_stderr || am_syslogger || syslogger_not_started_yet) &&
Does that seem reasonable? Or am I looking at this the wrong way?
In response to
pgsql-hackers by date
|Next:||From: Magnus Hagander||Date: 2007-01-29 17:49:28|
|Subject: Re: 10 weeks to feature freeze (Pending Work)|
|Previous:||From: Richard Troy||Date: 2007-01-29 17:30:50|
|Subject: Re: Updateable cursors|
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2007-01-30 02:34:53|
|Subject: Re: [HACKERS] [BUGS] BUG #2907: pg_get_serial_sequence
|Previous:||From: Magnus Hagander||Date: 2007-01-29 11:38:36|
|Subject: Re: BUG #2931: Can't capture pg_dump Password prompt|