Re: BUG #1466: #maintenace_work_mem = 16384

From: Joe Brown <joebrown(at)rclooke(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, mha(at)sollentuna(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1466: #maintenace_work_mem = 16384
Date: 2005-02-08 19:42:14
Message-ID: 42091616.8050509@rclooke.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

w/egg on face, DOH

I did try to make sure I didn't submit a bogus report, but didn't try
hard enough.

I checked all logs I could think of (event and pg_logs) and found no
information. I suppose if I tried starting postmaster by hand I would
have spotted the issue.

This didn't help me diagnose the issue:
runas /user:postgres "p:\PostgreSQL\8.0\bin\pg_ctl.exe start -D
p:\PostgreSQL\8.0\data"

Ok, now I ask for the world... Can we force postgres to log startup
failure? I figured that was what was going on, but I didn't think to
login as postgres and start it by hand to see the output.

Tom Lane wrote:

>"Joe Brown" <joebrown(at)rclooke(dot)com> writes:
>
>
>>Uncommenting
>>maintenace_work_mem = 16384
>>caused the server immediately stop after start.
>>
>>
>
>You apparently managed to change the spelling while uncommenting;
>the actual line in the sample file is
>
>#maintenance_work_mem = 16384 # min 1024, size in KB
> ^
>
>
>
>>No errors reported, no logs generated.
>>
>>
>
>The error is reported. For instance, when I try this I get
>$ postmaster
>FATAL: unrecognized configuration parameter "maintenace_work_mem"
>$
>
> regards, tom lane
>
>
>
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-02-08 19:52:39 Re: BUG #1466: #maintenace_work_mem = 16384
Previous Message Tom Lane 2005-02-08 17:04:10 Re: SELECT returning too many rows (?)