X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EA1B656968 for ; Wed, 16 Mar 2005 14:59:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 00623-06 for ; Wed, 16 Mar 2005 14:59:20 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.207]) by svr1.postgresql.org (Postfix) with ESMTP id B8E2F56963 for ; Wed, 16 Mar 2005 14:59:19 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 37so5106wra for ; Wed, 16 Mar 2005 06:59:23 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=DSkSv/mjsdjijsHHvY4aZE+NwIV1JfkdOqFLXjHL56zCdY6GgFZpZndJK6pnXOcPvwhosNy0JqUmZPTm9quphW3/ToRxw/hAaYCUcBkepbQmDrRN0ou2KYOigR1REwGRUBvxzI1hnN3/fCWKXe6tpjRf/FPJ8oGHHg4kpScanxU= Received: by 10.54.29.61 with SMTP id c61mr1017923wrc; Wed, 16 Mar 2005 06:59:22 -0800 (PST) Received: by 10.54.39.5 with HTTP; Wed, 16 Mar 2005 06:59:22 -0800 (PST) Message-ID: <3085811c05031606597f0dd20d@mail.gmail.com> Date: Wed, 16 Mar 2005 09:59:22 -0500 From: David Wagoner Reply-To: David Wagoner To: PgSQL Admin Subject: Re: Re-initialize pg_hba.conf file? In-Reply-To: <42384563.8050905@startnet.cz> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable References: <3085811c0503160628765f6539@mail.gmail.com> <42384563.8050905@startnet.cz> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.286 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/244 X-Sequence-Number: 16742 Ah, my Sys. Admin. tells me this is the easiest way and it won't restart the database instance: kill -HUP postmaster_pid -david On Wed, 16 Mar 2005 15:40:35 +0100, Miroslav =C5=A0ulc wrote: > David Wagoner wrote: >=20 > >Is there a way to have Postgres re-read the pg_hba.conf file while the > >database is up and running (i.e., no restarting)? Perhaps using > >SIGHUP? > > > > > I think you're right with the SIGHUP. In my init script from Gentoo > there is option to reload (which I think is the same): > su - $PGUSER -c "/usr/bin/pg_ctl reload -D '$PGDATA' -s" >=20 > >I added a user entry to the pg_hba.conf file and cannot bounce the datab= ase. > > > >thanks, > > > >david > > > Miroslav >=20 >=20 >