pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe-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>
2005-03-16 14:40 ` Re: Re-initialize pg_hba.conf file? Miroslav Šulc <miroslav.sulc@startnet.cz>
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: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 ` Re: Re-initialize pg_hba.conf file? 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:28 Re-initialize pg_hba.conf file? David Wagoner <dbwagoner@gmail.com>
2005-03-16 14:40 ` Re: Re-initialize pg_hba.conf file? Miroslav Šulc <miroslav.sulc@startnet.cz>
@ 2005-03-16 14:59 ` David Wagoner <dbwagoner@gmail.com>
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
* 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
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