pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcan you change pg_hba.conf and restart the listener on the fly?
3+ messages / 3 participants
[nested] [flat]
* can you change pg_hba.conf and restart the listener on the fly?
@ 2010-09-15 18:15 Mark Rostron <mrostron@ql2.com>
0 siblings, 2 replies; 3+ messages in thread
From: Mark Rostron @ 2010-09-15 18:15 UTC (permalink / raw)
To: pgsql-admin
Hi
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?
Mr
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: can you change pg_hba.conf and restart the listener on the fly?
@ 2010-09-15 18:22 Tom Lane <tgl@sss.pgh.pa.us>
parent: Mark Rostron <mrostron@ql2.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2010-09-15 18:22 UTC (permalink / raw)
To: Mark Rostron <mrostron@ql2.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: can you change pg_hba.conf and restart the listener on the fly?
@ 2010-09-15 18:26 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Mark Rostron <mrostron@ql2.com>
1 sibling, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2010-09-15 18:26 UTC (permalink / raw)
To: pgsql-admin; Mark Rostron <mrostron@ql2.com>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-09-15 18:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-15 18:15 can you change pg_hba.conf and restart the listener on the fly? Mark Rostron <mrostron@ql2.com>
2010-09-15 18:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-09-15 18:26 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox