From: Amit Kapila <amit.kapila@huawei.com>
To: 'Jose Martinez' <jmartinez@opencrowd.com>
To: pgsql-general@postgresql.org
To: pgsql-admin@postgresql.org
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> (raw)
In-Reply-To: <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
References: <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Thursday, January 03, 2013 9:56 PM Jose Martinez wrote:
>Hi,
>I made some changes to postgresql.conf and I want them to take effect
without having to restart the server.
>I tried
>select pg_reload_conf();
>/usr/pgsql-9.1/bin/pg_ctl reload
>but when I do 'show all', I see no changes take effect.
>There settings I tried to change are:
> -effective_cache_size
> -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,
so no need to change config file and reload or restart.
With Regards,
Amit Kapila.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: amit.kapila@huawei.com, jmartinez@opencrowd.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to reload postgresql.conf without restarting
In-Reply-To: <00a101cdea87$74c95ad0$5e5c1070$@kapila@huawei.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox