Re: Amit Kapila 2014-06-25 <caa4ek1log98jvfov9wztqpcdewja+5jr54ttpkiz3xbngjy...@mail.gmail.com> > On Wed, Jun 25, 2014 at 6:11 PM, Christoph Berg <c...@df7cb.de> wrote: > > > > I've just run into this: > > > > $ psql -p 5433 (that port is configured in postgresql.conf) > > # alter system set port = 5494; > > > > ... restart the server > > > > $ psql -p 5494 > > # select pg_reload_conf(); > > > > 2014-06-25 14:22:07 CEST [11297-4] LOG: received SIGHUP, reloading > configuration files > > 2014-06-25 14:22:07 CEST [11297-5] LOG: parameter "port" cannot be > changed without restarting the server > > 2014-06-25 14:22:07 CEST [11297-6] LOG: configuration file > "/etc/postgresql/9.4/main/postgresql.conf" contains errors; unaffected > changes were applied > > This will happen without Alter System as well, if you change > the value of port in postgresql.conf and try to load conf file with SIGHUP. > You cannot reload PGC_POSTMASTER parameters without server restart.
That's not the issue. I did restart the server, which didn't log any problems, yet reload keeps complaining indefinitely. This makes ALTER SYSTEM not-so-nice-to-use to override parameters already set in postgresql.conf. Christoph -- c...@df7cb.de | http://www.df7cb.de/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
