From: Amit Kapila <amit.kapila@huawei.com>
To: "'Jose Martinez'" <jmartinez@opencrowd.com>,
	<pgsql-general@postgresql.org>, <pgsql-admin@postgresql.org>
References: 
 <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
In-Reply-To: 
 <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
Subject: Re: [GENERAL] Unable to reload postgresql.conf without restarting
Date: Fri, 4 Jan 2013 19:56:15 +0530
Message-ID: <00a101cdea87$74c95ad0$5e5c1070$@kapila@huawei.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: Ac3qKHXT7K0b+s7uTrCmtHlWyOyVDgAXjsbA
Content-Language: en-us
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Thursday, January 03, 2013 9:56 PM Jose Martinez wrote:
>Hi,

>I made some changes to=A0postgresql.conf and I want them to take effect
without having to restart the server.

>I tried=A0

>select pg_reload_conf();
>/usr/pgsql-9.1/bin/pg_ctl reload

>but when I do 'show all', I see no changes take effect.=A0

>There settings I tried to change are:
> -effective_cache_size=A0
> -work_mem

Tried in latest HEAD code(Windows OS) and its working, after select
pg_reload_conf(), the changed value is shown.
Can you try just with SET command and verify the behavior, as these
parameters are USERSET parameters,=20
so no need to change config file and reload or restart.

With Regards,
Amit Kapila.


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin