Re: [ADMIN] Unable to reload postgresql.conf without restarting

[Matheus de Oliveira <matioli.matheus@xxxxxxxxx>]

On Thu, Jan 3, 2013 at 2:25 PM, Jose Martinez <jmartinez@xxxxxxxxxxxxx> 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