pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re-initialize pg_hba.conf file?
4+ messages / 3 participants
[nested] [flat]

* Re-initialize pg_hba.conf file?
@ 2005-03-16 14:28  David Wagoner <dbwagoner@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: David Wagoner @ 2005-03-16 14:28 UTC (permalink / raw)
  To: pgsql-admin

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 added a user entry to the pg_hba.conf file and cannot bounce the database.

thanks,

david



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Re-initialize pg_hba.conf file?
@ 2005-03-16 14:38  Jason Minion <jason.minion@sigler.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Jason Minion @ 2005-03-16 14:38 UTC (permalink / raw)
  To: David Wagoner <dbwagoner@gmail.com>; pgsql-admin

pg_ctl reload [ -s ] [ -D datadir ]

You might want to check man page on pg_ctl, it's very useful!

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of David Wagoner
Sent: Wednesday, March 16, 2005 8:28 AM
To: PgSQL Admin
Subject: [ADMIN] Re-initialize pg_hba.conf file?


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 added a user entry to the pg_hba.conf file and cannot bounce the database.

thanks,

david

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Re-initialize pg_hba.conf file?
@ 2005-03-16 14:40  Miroslav Šulc <miroslav.sulc@startnet.cz>
  parent: David Wagoner <dbwagoner@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Miroslav Šulc @ 2005-03-16 14:40 UTC (permalink / raw)
  To: David Wagoner <dbwagoner@gmail.com>; +Cc: pgsql-admin

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
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: Re-initialize pg_hba.conf file?
@ 2005-03-16 14:59  David Wagoner <dbwagoner@gmail.com>
  parent: Miroslav Šulc <miroslav.sulc@startnet.cz>
  0 siblings, 0 replies; 4+ messages in thread

From: David Wagoner @ 2005-03-16 14:59 UTC (permalink / raw)
  To: pgsql-admin

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 Šulc
<miroslav.sulc@startnet.cz> wrote:
> 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
> 
> 
>



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-03-16 14:59 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-16 14:28 Re-initialize pg_hba.conf file? David Wagoner <dbwagoner@gmail.com>
2005-03-16 14:40 ` Miroslav Šulc <miroslav.sulc@startnet.cz>
2005-03-16 14:59   ` David Wagoner <dbwagoner@gmail.com>
2005-03-16 14:38 Re: Re-initialize pg_hba.conf file? Jason Minion <jason.minion@sigler.com>

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