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 Kevin Grittner
Subject Re: can you change pg_hba.conf and restart the listener on the fly?
Date
Msg-id 4C90C9790200002500035791@gw.wicourts.gov
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> wrote:

> 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?

pg_ctl reload

That will also pick up changes to postgresql.conf, but it won't
interrupt execution of the postmaster.

-Kevin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: can you change pg_hba.conf and restart the listener on the fly?
Next
From: Greg Smith
Date:
Subject: Re: How To: LARGE html text or csv file COPY FROM?