pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (4+ messages)  latest in thread

Message-ID: <42384563.8050905@startnet.cz>
Permalink:  ../42384563.8050905@startnet.cz/
Also on:    postgresql.org/message-id/42384563.8050905@startnet.cz

 · 

reply

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