I need to manage a large number of various databases, some assigned to different people, others only internal to the company I work for. I would like to be able to update the pg_hba.conf file from inside a psql console connection but only if I an connected to template1 AND the main postgres user. I don't want to have to connect to the database machine via a different means because it's a step that can be forgotten very easily. If I had the option to be able to create a new pg_hba.conf entry then I could remember to do it right after I create a new database, and a user for it. Chris Bowlby, ----------------------------------------------------- Web Developer @ Hub.org. [EMAIL PROTECTED] www.hub.org 1-902-542-3657 ----------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl