From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Vitaly Belman" <vitalybe(at)yahoo(dot)com>, "PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org> |
Cc: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: Changing postgresql.conf values without restarting the postmaster? |
Date: | 2004-05-15 18:28:52 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE34BA11@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
Ok. I see the problem whit this. I'm not 100% sure on the fix, though.
The problem is that write_nondefault_variables() writes out variables of
type PGC_INTERNAL. I've attached a patch that simply prevents it from
doing this. It does make the problem go away, and I *think* it should be
safe, but I'm not totally sure...
//Magnus
>-----Original Message-----
>From: Vitaly Belman [mailto:vitalybe(at)yahoo(dot)com]
>Sent: den 14 maj 2004 19:34
>To: Magnus Hagander; PgSql-Win32
>Subject: RE: [pgsql-hackers-win32] Changing postgresql.conf
>values without restarting the postmaster?
>
>
>Thanks but it didn't seem to work too well... I
>compiled and sent the SIGHUP, postmaster said:
>
>> LOG: received SIGHUP, reloading configuration files
>
>Which is great but then it started an infinite loop
>of:
>
>> FATAL: parameter "lc_collate" cannot be changed
>
>Anyone know what's it?
>
>--- Magnus Hagander <mha(at)sollentuna(dot)net> wrote:
>> > # This file is read on postmaster startup and when
>> the
>> > postmaster # receives a SIGHUP.
>> >
>> > How do I send a SIGHUP to the postmaster in Win32?
>> Or is
>> > there another way?
>>
>>
>> Use the "pgkill" utility available on
>>
>http://momjian.postgresql.org/main/writings/pgsql/win32.html
>>
>>
>> //Magnus
>>
>
>
>
>
>
>__________________________________
>Do you Yahoo!?
>SBC Yahoo! - Internet access at a great low price.
>http://promo.yahoo.com/sbc/
>
Attachment | Content-Type | Size |
---|---|---|
gucfix.patch | application/octet-stream | 578 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-05-15 21:25:57 | Re: running as a service? |
Previous Message | Andrew Dunstan | 2004-05-15 13:36:55 | Re: running as a service? |