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 79F675696B for ; Wed, 16 Mar 2005 14:40:34 +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 93599-10 for ; Wed, 16 Mar 2005 14:40:33 +0000 (GMT) Received: from sranda.klamovka.kosire.czf (unknown [82.113.63.66]) by svr1.postgresql.org (Postfix) with ESMTP id 4ED6E5695B for ; Wed, 16 Mar 2005 14:40:31 +0000 (GMT) Received: (qmail 5463 invoked from network); 16 Mar 2005 15:40:35 +0100 Received: from startnet.klamovka.kosire.czf (HELO ?192.168.11.101?) (10.15.6.17) by sranda.klamovka.kosire.czf with AES256-SHA encrypted SMTP; 16 Mar 2005 15:40:35 +0100 Message-ID: <42384563.8050905@startnet.cz> Date: Wed, 16 Mar 2005 15:40:35 +0100 From: =?windows-1252?Q?Miroslav_=8Aulc?= Organization: StartNet s.r.o. User-Agent: Mozilla Thunderbird 1.0 (X11/20041208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: David Wagoner Cc: PgSQL Admin Subject: Re: Re-initialize pg_hba.conf file? References: <3085811c0503160628765f6539@mail.gmail.com> In-Reply-To: <3085811c0503160628765f6539@mail.gmail.com> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------060602060300000807090704" X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/243 X-Sequence-Number: 16741 This is a multi-part message in MIME format. --------------060602060300000807090704 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit David Wagoner wrote: >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" >I added a user entry to the pg_hba.conf file and cannot bounce the database. > >thanks, > >david > Miroslav --------------060602060300000807090704 Content-Type: text/x-vcard; charset=utf-8; name="miroslav.sulc.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="miroslav.sulc.vcf" begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:miroslav.sulc@startnet.cz title:CEO tel;work:+420 257 225 602 tel;cell:+420 603 711 413 x-mozilla-html:TRUE url:http://www.startnet.cz version:2.1 end:vcard --------------060602060300000807090704--