Thread: SIGHUP the postmaster

SIGHUP the postmaster

From
"Mark Seftel"
Date:
Hi,
 
I need to changes to pg_hba.conf and now need to "SIGHUP the postmaster"
 
Does anyone no how to do this.
 
Thx
 
Mark

Re: SIGHUP the postmaster

From
Rod Kreisler
Date:
The best way is with:
 
pg_ctl restart
 
 
-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Mark Seftel
Sent: Saturday, September 14, 2002 6:06 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] SIGHUP the postmaster

Hi,
 
I need to changes to pg_hba.conf and now need to "SIGHUP the postmaster"
 
Does anyone no how to do this.
 
Thx
 
Mark

Re: SIGHUP the postmaster

From
Tom Lane
Date:
"Mark Seftel" <mark@trustemail.com> writes:
> I need to changes to pg_hba.conf and now need to "SIGHUP the postmaster"
> Does anyone no how to do this.

The hard way is to determine the postmaster's PID (eg, by looking at ps
output) and then do

    kill -HUP postmaster_PID

The easier way is to do "pg_ctl reload" which does this for you.
You need to have $PGDATA set in your environment to make it work
conveniently, though.

            regards, tom lane