Re: can you change pg_hba.conf and restart the listener on the fly?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Rostron <mrostron(at)ql2(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: can you change pg_hba.conf and restart the listener on the fly?
Date: 2010-09-15 18:22:03
Message-ID: 22104.1284574923@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mark Rostron <mrostron(at)ql2(dot)com> writes:
> We are running an 8.3.10 instance.
> I need to make a change to pg_hba.conf on the fly.
> Is it possible to restart just the listener for the database without cycling the postmaster?

There is no separate "listener". However, it's sufficient to SIGHUP the
postmaster, you don't have to restart it for pg_hba.conf changes.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-09-15 18:26:17 Re: can you change pg_hba.conf and restart the listener on the fly?
Previous Message Mark Rostron 2010-09-15 18:15:47 can you change pg_hba.conf and restart the listener on the fly?