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

From: Vitaly Belman <vitalybe(at)yahoo(dot)com>
To: Magnus Hagander <mha(at)sollentuna(dot)net>, PgSql-Win32 <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Changing postgresql.conf values without restarting the postmaster?
Date: 2004-05-14 17:34:04
Message-ID: 20040514173404.12480.qmail@web51002.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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/

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Andrew Dunstan 2004-05-15 00:20:33 running as a service?
Previous Message Magnus Hagander 2004-05-14 16:30:43 Re: Changing postgresql.conf values without restarting the postmaster?