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

2013-01-04 Thread Amit Kapila
On Thursday, January 03, 2013 9:56 PM 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. 

[GENERAL] Unable to reload postgresql.conf without restarting

2013-01-03 Thread Jose Martinez
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