From: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
---|---|
To: | "'Jose Martinez'" <jmartinez(at)opencrowd(dot)com>, <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Unable to reload postgresql.conf without restarting |
Date: | 2013-01-04 14:26:15 |
Message-ID: | 00a101cdea87$74c95ad0$5e5c1070$@kapila@huawei.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-01-04 15:58:14 | Re: my query is so slow,It costs 944,319.072 ms,Can someone Help!! |
Previous Message | robin | 2013-01-04 08:36:41 | Re: my query is so slow,It costs 944,319.072 ms,Can someone Help!! |
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2013-01-04 14:36:58 | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
Previous Message | Florent Mazzone | 2013-01-04 10:53:10 | DbLink connection with SSPI authentication fails |