Обсуждение: 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

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

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

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
>
>
>