Skip site navigation (1) Skip section navigation (2)

Re: control pg_hba.conf via SQL

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Chris Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: control pg_hba.conf via SQL
Date: 2006-03-30 18:27:25
Message-ID: 442C230D.8080706@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Chris Browne wrote:
>> Maybe we could do something like this: if there is a pg_hba.conf
>> file present, then use it as now and ignore the access rights table
>> - if someone does GRANT/REVOKE CONNECT while under pg_hba.conf then
>> process it but issue a warning. Maybe there could also be an initdb
>> switch that gave users a choice.
>>     
>
> initdb is a terrible choice for that; that means you have to
> re-initialize the database to change the option.
>
>   

Not at all. Where did you get that idea? Not everything set by initdb is 
set in concrete. For example, initdb sets shared_buffers but you sure 
don't need to rerun initdb to change that or anything else it sets in 
postgresql.conf.

cheers

andrew

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2006-03-30 18:38:26
Subject: Re: Index vacuum improvements
Previous:From: Chris BrowneDate: 2006-03-30 17:46:12
Subject: Re: control pg_hba.conf via SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group