On Wed, Jun 25, 2014 at 7:45 PM, Amit Kapila <amit.kapil...@gmail.com> wrote: > > On Wed, Jun 25, 2014 at 6:47 PM, Christoph Berg <c...@df7cb.de> wrote: > > Re: Amit Kapila 2014-06-25 < caa4ek1log98jvfov9wztqpcdewja+5jr54ttpkiz3xbngjy...@mail.gmail.com> > > > 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. > > The main reason behind such such a behaviour after restart is > that there are duplicate entries, one in postgresql.conf and > another in postgresql.conf.
Sorry, I mean to say one in postgresql.conf and another in postgresql.auto.conf With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com