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

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 (view raw or flat)
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

pgsql-hackers-win32 by date

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

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