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

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

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

2013-01-03 Thread sk baji
> 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: >

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

2013-01-03 Thread Matheus de Oliveira
On Thu, Jan 3, 2013 at 2:25 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 ta

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

2013-01-03 Thread Bruce Momjian
On Thu, Jan 3, 2013 at 11:25:41AM -0500, 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