Unable to reload postgresql.conf without restarting

[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
-work_mem

Im using posgres 9.1 on Centos Linux (amazon ec2)

Thanks

[Matheus de Oliveira]

Post by 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.
-effective_cache_size
-work_mem

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.

Regards,

[Scott Ribe]

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 postgresql.conf, that the server wasn't started with a different one than you think.
--
Scott Ribe
***@elevated-dev.com
http://www.elevated-dev.com/
[phone] voice

[Matheus de Oliveira]

Post by Matheus de Oliveira

Post by Matheus de Oliveira
They should have been reloaded. Have you set them by role, database or

tablespace?

Post by Matheus de Oliveira
Or even, has them been set, by mistake, twice at postgresql.conf? If so,

the last one

Post by Matheus de Oliveira
will be used.

Also make sure you're changing the right postgresql.conf, that the server
wasn't started with a different one than you think.

Yep. The config_file parameter can be used to check it:

SHOW config_file;

Regards,

[sk baji]

Post by Jose Martinez
Hi,
I made some changes to postgresql.conf and I want them to take effect

without

Post by Jose Martinez
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.
-effective_cache_size
-work_mem
Im using posgres 9.1 on Centos Linux (amazon ec2)

I think, these parameters are duplicated in postgresql.conf file. Can you
check whether the same parameters are exits in bottom of the file. If so,
you need to change at the bottom(or comment them).


Regards,
Baji Shaik.

Post by Jose Martinez

Post by Jose Martinez
Hi,
I made some changes to postgresql.conf and I want them to take effect

without

Post by Jose Martinez
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.
-effective_cache_size
-work_mem
Im using posgres 9.1 on Centos Linux (amazon ec2)

That is quite odd. Can you show us the commands and the postgresql.conf
line you are changing?
--
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
http://www.postgresql.org/mailpref/pgsql-general