Re: Changing access permissions without re-starting the database

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Carlos <Carlos(at)pbsinet(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Changing access permissions without re-starting the database
Date: 2004-10-27 13:27:27
Message-ID: F2177F3A-281B-11D9-A3CC-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 27, 2004, at 9:23 PM, Carlos wrote:

> PostgreSQL?  I often want to preclude all IP address but one from
> accessing the database.  Currently, I change the pg_hba.conf file and
> re-start the database but I would like to be able to do the same thing
> without having to re-start.

Try pg_ctl reload instead of pg_ctl restart

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-10-27 13:55:34 Re: primary key and existing unique fields
Previous Message Ben-Nes Michael 2004-10-27 13:24:19 Resource temporarily unavailable