From: Miroslav Šulc <miroslav.sulc@startnet.cz>
To: David Wagoner <dbwagoner@gmail.com>
Cc: PgSQL Admin <pgsql-admin@postgresql.org>
Subject: Re: Re-initialize pg_hba.conf file?
Date: Wed, 16 Mar 2005 15:40:35 +0100
Message-ID: <42384563.8050905@startnet.cz> (raw)
In-Reply-To: <3085811c0503160628765f6539@mail.gmail.com>
References: <3085811c0503160628765f6539@mail.gmail.com>
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
Attachments:miroslav.sulc.vcf (text/x-vcard, 385B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: miroslav.sulc@startnet.cz, dbwagoner@gmail.com
Subject: Re: Re-initialize pg_hba.conf file?
In-Reply-To: <42384563.8050905@startnet.cz>
References: <3085811c0503160628765f6539@mail.gmail.com> <42384563.8050905@startnet.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox