| From: | "Carlos Oliva" <carlos(at)pbsinet(dot)com> |
|---|---|
| To: | "'Michael Glaesemann'" <grzm(at)myrealbox(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Changing access permissions without re-starting the database |
| Date: | 2004-10-27 14:05:48 |
| Message-ID: | 200410271406.KAA25684@pbsi.pbsinet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thank you Michael. This should work
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Michael Glaesemann
Sent: Wednesday, October 27, 2004 9:27 AM
To: Carlos
Cc: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] Changing access permissions without re-starting the
database
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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Savard | 2004-10-27 14:19:02 | Array values and foreign keys |
| Previous Message | Bruno Wolff III | 2004-10-27 13:55:34 | Re: primary key and existing unique fields |