From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
To: | Jose Martinez <jmartinez(at)opencrowd(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] Unable to reload postgresql.conf without restarting |
Date: | 2013-01-03 19:15:19 |
Message-ID: | 87d2xm5b94.fsf@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Jose Martinez <jmartinez(at)opencrowd(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800
From | Date | Subject | |
---|---|---|---|
Next Message | Jerome | 2013-01-04 05:40:03 | my query is so slow,It costs 944,319.072 ms,Can someone Help!! |
Previous Message | Walter Hurry | 2013-01-03 18:38:13 | Re: Migración |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2013-01-03 19:15:38 | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
Previous Message | Gauthier, Dave | 2013-01-03 19:09:10 | alter default privileges problem |