Postgres Pro
Downloads
Home   >   mailing lists

Re: can you change pg_hba.conf and restart the listener on the fly? - Mailing list pgsql-admin

From Tom Lane
Subject Re: can you change pg_hba.conf and restart the listener on the fly?
Date
Msg-id 22104.1284574923@sss.pgh.pa.us
Whole thread Raw
In response to can you change pg_hba.conf and restart the listener on the fly?  (Mark Rostron <mrostron@ql2.com>)
List pgsql-admin
Tree view 
Mark Rostron <mrostron@ql2.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

pgsql-admin by date:

Previous
From: Mark Rostron
Date:
Subject: can you change pg_hba.conf and restart the listener on the fly?
Next
From: "Kevin Grittner"
Date:
Subject: Re: can you change pg_hba.conf and restart the listener on the fly?