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
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 no
On Thu, Jan 3, 2013 at 2:25 PM, Jose Martinez jmarti...@opencrowd.comwrote:
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
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:
On Jan 3, 2013, at 10:30 AM, Matheus de Oliveira wrote:
They should have been reloaded. Have you set them by role, database or
tablespace?
Or even, has them been set, by mistake, twice at postgresql.conf? If so, the
last one
will be used.
Also make sure you're changing the right
On Thu, Jan 3, 2013 at 4:02 PM, Scott Ribe scott_r...@elevated-dev.comwrote:
On Jan 3, 2013, at 10:30 AM, Matheus de Oliveira wrote:
They should have been reloaded. Have you set them by role, database or
tablespace?
Or even, has them been set, by mistake, twice at postgresql.conf? If so,
Jose Martinez jmarti...@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