Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id C89111338337 for ; Wed, 15 Sep 2010 15:36:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 36135-01-6 for ; Wed, 15 Sep 2010 18:36:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id E330013387EA for ; Wed, 15 Sep 2010 15:22:03 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o8FIM3uc022105; Wed, 15 Sep 2010 14:22:03 -0400 (EDT) To: Mark Rostron cc: "pgsql-admin@postgresql.org" Subject: Re: can you change pg_hba.conf and restart the listener on the fly? In-reply-to: References: Comments: In-reply-to Mark Rostron message dated "Wed, 15 Sep 2010 11:15:47 -0700" Date: Wed, 15 Sep 2010 14:22:03 -0400 Message-ID: <22104.1284574923@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/81 X-Sequence-Number: 35625 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 don't have to restart it for pg_hba.conf changes. regards, tom lane