From: Jerry Sievers <gsievers19@comcast.net>
To: Jose Martinez <jmartinez@opencrowd.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Unable to reload postgresql.conf without restarting
Date: Thu, 03 Jan 2013 13:15:19 -0600
Message-ID: <87d2xm5b94.fsf@comcast.net> (raw)
In-Reply-To: <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
References: <CA+ixmX1xh8F5-zcrk0a9DaFfXwgujKm+MVcJab-tXMzoVzFXGQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, jmartinez@opencrowd.com, pgsql-general@postgresql.org
Subject: Re: [ADMIN] Unable to reload postgresql.conf without restarting
In-Reply-To: <87d2xm5b94.fsf@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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