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

wild cards in pg_hba.conf

From: "Glenn" <glenn(at)tangelosoftware(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: wild cards in pg_hba.conf
Date: 2006-07-19 11:46:52
Message-ID: 000401c6ab29$07463bd0$3202a8c0@gdata.local (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi all

I have a user I allow to create databases. At the moment he just "echo
NewDBName >>pgdbnames.txt" and there is  a @HisDBFiles type entry against
his name in pg_hba.conf under the database column. Problem with this reigiem
is I have to reload the database for him each time for it to take effect (on
debian I just /etc/init.d/postgresql-8.0 reload).


What Im hoping is I can just have a wild card entry instead of @... under
the database column say, like  


host   cheshire%  cheshire      password


(where Cheshire is his username). 

This way any db name that starts which Cheshire will use password from
localhost for user Cheshire


Is something like this possible?


Alternatively, though less cool, is there a way he can provoke a 'reload' of
the pg_hba.conf file with out having too much authority ?




pgsql-novice by date

Next:From: Devrim GUNDUZDate: 2006-07-19 12:35:31
Subject: Re: Installation
Previous:From: Alan HodgsonDate: 2006-07-18 20:48:07
Subject: Re: Installation

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