To: Jose Martinez <jmartinez@opencrowd.com>
Cc: pgsql-general@postgresql.org,  pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Unable to reload postgresql.conf without restarting
References: 
 <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
From: Jerry Sievers <gsievers19@comcast.net>
Date: Thu, 03 Jan 2013 13:15:19 -0600
In-Reply-To: 
 <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
	(Jose Martinez's message of "Thu\, 3 Jan 2013 11\:25\:41 -0500")
Message-ID: <87d2xm5b94.fsf@comcast.net>
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.2 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

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