Skip site navigation (1) Skip section navigation (2)

Re: Changing postgresql.conf values without restarting the postmaster?

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 (view raw or flat)
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: gucfix.patch
Description: application/octet-stream (578 bytes)

Responses

pgsql-hackers-win32 by date

Next:From: Dave PageDate: 2004-05-15 21:25:57
Subject: Re: running as a service?
Previous:From: Andrew DunstanDate: 2004-05-15 13:36:55
Subject: Re: running as a service?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group