From: | Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com> |
---|---|
To: | Jose Martinez <jmartinez(at)opencrowd(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Unable to reload postgresql.conf without restarting |
Date: | 2013-01-03 17:30:18 |
Message-ID: | CAJghg4+oTszoJdQYUPnLFvN+0=7BDiriuj70n26UodJv5t0=xQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Thu, Jan 3, 2013 at 2:25 PM, Jose Martinez <jmartinez(at)opencrowd(dot)com>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
>
>
They should have been reloaded. Have you set them by role, database or
tablespace?
Or even, has them been set, by mistake, twice at postgresql.conf? If so,
the last one
will be used.
Regards,
--
Matheus de Oliveira
Analista de Banco de Dados PostgreSQL
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
From | Date | Subject | |
---|---|---|---|
Next Message | sk baji | 2013-01-03 17:36:02 | Re: [GENERAL] Unable to reload postgresql.conf without restarting |
Previous Message | Bruce Momjian | 2013-01-03 17:17:28 | Re: [ADMIN] Unable to reload postgresql.conf without restarting |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2013-01-03 17:30:52 | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
Previous Message | Fabrízio de Royes Mello | 2013-01-03 17:27:42 | Re: Database Design: Maintain Audit Trail of Changes |