[ADMIN] can you change pg_hba.conf and restart the listener on the fly?

2010-09-15 Thread Mark Rostron
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

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

2010-09-15 Thread Tom Lane
Mark Rostron 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

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

2010-09-15 Thread Kevin Grittner
Mark Rostron 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. -Ke