From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Jose Martinez <jmartinez(at)opencrowd(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] Unable to reload postgresql.conf without restarting |
Date: | 2013-01-03 17:17:28 |
Message-ID: | 20130103171728.GB32290@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Thu, Jan 3, 2013 at 11:25:41AM -0500, 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
>
> Im using posgres 9.1 on Centos Linux (amazon ec2)
That is quite odd. Can you show us the commands and the postgresql.conf
line you are changing?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Matheus de Oliveira | 2013-01-03 17:30:18 | Re: Unable to reload postgresql.conf without restarting |
Previous Message | Jose Martinez | 2013-01-03 16:25:41 | Unable to reload postgresql.conf without restarting |
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2013-01-03 17:18:59 | Re: Database Design: Maintain Audit Trail of Changes |
Previous Message | Bèrto ëd Sèra | 2013-01-03 17:01:40 | Re: Database Design: Maintain Audit Trail of Changes |