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

Jose Martinez <jmartinez(at)opencrowd(dot)com> writes:

> Hi,
>
> I made some changes to?postgresql.conf and I want them to take effect without having to restart the server.

Check your server log for any report of a syntax error in your .conf
file.

If there is one, that will prevent the changes being loaded.

pg_reload_conf() will still return 't' and you'll be unaware of the
problem

> 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)
>
> Thanks
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800