Jose Martinez <jmartinez@xxxxxxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
