Re: Changing access permissions without re-starting the database - Mailing list pgsql-general

From Carlos Oliva
Subject Re: Changing access permissions without re-starting the database
Date
Msg-id 200410271406.KAA25684@pbsi.pbsinet.com
Whole thread Raw
In response to Re: Changing access permissions without re-starting the database  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
Thank you Michael.  This should work

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michael Glaesemann
Sent: Wednesday, October 27, 2004 9:27 AM
To: Carlos
Cc: 'pgsql-general@postgresql.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@postgresql.org


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: primary key and existing unique fields
Next
From: f-f@club-internet.fr
Date:
Subject: Re: