Jose Martinez <jmartinez@opencrowd.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.consulting@comcast.net
p: 312.241.7800