pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUnable to reload postgresql.conf without restarting
8+ messages / 7 participants
[nested] [flat]
* Unable to reload postgresql.conf without restarting
@ 2013-01-03 16:25 Jose Martinez <jmartinez@opencrowd.com>
2013-01-03 17:17 ` Re: [ADMIN] Unable to reload postgresql.conf without restarting Bruce Momjian <bruce@momjian.us>
2013-01-03 17:30 ` Re: Unable to reload postgresql.conf without restarting Matheus de Oliveira <matioli.matheus@gmail.com>
2013-01-03 19:15 ` Re: [ADMIN] Unable to reload postgresql.conf without restarting Jerry Sievers <gsievers19@comcast.net>
2013-01-04 14:26 ` Re: [GENERAL] Unable to reload postgresql.conf without restarting Amit Kapila <amit.kapila@huawei.com>
0 siblings, 4 replies; 8+ messages in thread
From: Jose Martinez @ 2013-01-03 16:25 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [ADMIN] Unable to reload postgresql.conf without restarting
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
@ 2013-01-03 17:17 ` Bruce Momjian <bruce@momjian.us>
2013-01-03 17:36 ` Re: [GENERAL] Unable to reload postgresql.conf without restarting sk baji <baji.dba@gmail.com>
3 siblings, 1 reply; 8+ messages in thread
From: Bruce Momjian @ 2013-01-03 17:17 UTC (permalink / raw)
To: Jose Martinez <jmartinez@opencrowd.com>; +Cc: pgsql-general@postgresql.org; pgsql-admin
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 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)
That is quite odd. Can you show us the commands and the postgresql.conf
line you are changing?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [GENERAL] Unable to reload postgresql.conf without restarting
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
2013-01-03 17:17 ` Re: [ADMIN] Unable to reload postgresql.conf without restarting Bruce Momjian <bruce@momjian.us>
@ 2013-01-03 17:36 ` sk baji <baji.dba@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: sk baji @ 2013-01-03 17:36 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Jose Martinez <jmartinez@opencrowd.com>; pgsql-general@postgresql.org; pgsql-admin
> 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)
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.
On Thu, Jan 3, 2013 at 5:17 PM, Bruce Momjian <bruce@momjian.us> wrote:
> 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 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)
>
> That is quite odd. Can you show us the commands and the postgresql.conf
> line you are changing?
>
> --
> Bruce Momjian <bruce@momjian.us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Unable to reload postgresql.conf without restarting
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
@ 2013-01-03 17:30 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2013-01-03 18:02 ` Re: Unable to reload postgresql.conf without restarting Scott Ribe <scott_ribe@elevated-dev.com>
3 siblings, 1 reply; 8+ messages in thread
From: Matheus de Oliveira @ 2013-01-03 17:30 UTC (permalink / raw)
To: Jose Martinez <jmartinez@opencrowd.com>; +Cc: pgsql-general@postgresql.org; pgsql-admin
On Thu, Jan 3, 2013 at 2:25 PM, Jose Martinez <jmartinez@opencrowd.com>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.
>
> There settings I tried to change are:
> -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,
--
Matheus de Oliveira
Analista de Banco de Dados PostgreSQL
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Unable to reload postgresql.conf without restarting
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
2013-01-03 17:30 ` Re: Unable to reload postgresql.conf without restarting Matheus de Oliveira <matioli.matheus@gmail.com>
@ 2013-01-03 18:02 ` Scott Ribe <scott_ribe@elevated-dev.com>
2013-01-03 18:34 ` Re: Unable to reload postgresql.conf without restarting Matheus de Oliveira <matioli.matheus@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Scott Ribe @ 2013-01-03 18:02 UTC (permalink / raw)
To: Jose Martinez <jmartinez@opencrowd.com>; +Cc: pgsql-admin
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 postgresql.conf, that the server wasn't started with a different one than you think.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Unable to reload postgresql.conf without restarting
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
2013-01-03 17:30 ` Re: Unable to reload postgresql.conf without restarting Matheus de Oliveira <matioli.matheus@gmail.com>
2013-01-03 18:02 ` Re: Unable to reload postgresql.conf without restarting Scott Ribe <scott_ribe@elevated-dev.com>
@ 2013-01-03 18:34 ` Matheus de Oliveira <matioli.matheus@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Matheus de Oliveira @ 2013-01-03 18:34 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Jose Martinez <jmartinez@opencrowd.com>; pgsql-admin
On Thu, Jan 3, 2013 at 4:02 PM, Scott Ribe <scott_ribe@elevated-dev.com>wrote:
> 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 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,
--
Matheus de Oliveira
Analista de Banco de Dados PostgreSQL
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [ADMIN] Unable to reload postgresql.conf without restarting
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
@ 2013-01-03 19:15 ` Jerry Sievers <gsievers19@comcast.net>
3 siblings, 0 replies; 8+ messages in thread
From: Jerry Sievers @ 2013-01-03 19:15 UTC (permalink / raw)
To: Jose Martinez <jmartinez@opencrowd.com>; +Cc: pgsql-general@postgresql.org; pgsql-admin
Jose Martinez <jmartinez@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 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@comcast.net
p: 312.241.7800
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [GENERAL] Unable to reload postgresql.conf without restarting
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
@ 2013-01-04 14:26 ` Amit Kapila <amit.kapila@huawei.com>
3 siblings, 0 replies; 8+ messages in thread
From: Amit Kapila @ 2013-01-04 14:26 UTC (permalink / raw)
To: 'Jose Martinez' <jmartinez@opencrowd.com>; pgsql-general@postgresql.org; pgsql-admin
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.
>There settings I tried to change are:
> -effective_cache_size
> -work_mem
Tried in latest HEAD code(Windows OS) and its working, after select
pg_reload_conf(), the changed value is shown.
Can you try just with SET command and verify the behavior, as these
parameters are USERSET parameters,
so no need to change config file and reload or restart.
With Regards,
Amit Kapila.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2013-01-04 14:26 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-01-03 16:25 Unable to reload postgresql.conf without restarting Jose Martinez <jmartinez@opencrowd.com>
2013-01-03 17:17 ` Bruce Momjian <bruce@momjian.us>
2013-01-03 17:36 ` sk baji <baji.dba@gmail.com>
2013-01-03 17:30 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2013-01-03 18:02 ` Scott Ribe <scott_ribe@elevated-dev.com>
2013-01-03 18:34 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2013-01-03 19:15 ` Jerry Sievers <gsievers19@comcast.net>
2013-01-04 14:26 ` Amit Kapila <amit.kapila@huawei.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox