dbTalk Databases Forums  

Changing access permissions without re-starting the database

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Changing access permissions without re-starting the database in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Carlos
 
Posts: n/a

Default Changing access permissions without re-starting the database - 10-27-2004 , 07:23 AM






Hi Forum,

Is there a way to change the database access permissions for different IP
addresses without having to re-start 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.



Thanks in advance for your response



Reply With Quote
  #2  
Old   
Michael Glaesemann
 
Posts: n/a

Default Re: Changing access permissions without re-starting the database - 10-27-2004 , 08:27 AM







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

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



Reply With Quote
  #3  
Old   
Carlos Oliva
 
Posts: n/a

Default Re: Changing access permissions without re-starting the database - 10-27-2004 , 09:05 AM



Thank you Michael. This should work

-----Original Message-----
From: pgsql-general-owner (AT) postgresql (DOT) org
[mailtogsql-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:

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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.