1. Please don't forget to cc: the list
2. Please don't top-quote
Bhavana.Rakesh wrote:
> Does this mean the pg_hba.conf file has to be edited everytime a new
> database/schema is created?
No, only when you want to change network access permissions for the
installation as a whole. See the manuals for full details.
Of course, if you have different rules for each database you'll need to
make more changes than if you have two or three rules that apply to a
whole installation.
With 8.2 you can control access to databases via ROLEs as well as access
to schemas,tables etc.
--
Richard Huxton
Archonet Ltd