Tim Uckun <timuckun@xxxxxxxxx> writes: > I want to accomplish what I would think would be a simple thing. I > want the root user to be able to connect to the postgres database as > user postgres from the local machine without passwords. Since I am > doing this from a program I don't want to use the su facility. I suspect you are expecting that the map will cause root to be logged in as postgres without asking for that. It won't. What it will do is allow "psql -U postgres" and similar to work. BTW, one has to wonder why you are using the root account for this work in the first place. Wouldn't it be a lot more secure to use a less privileged account (oh, I don't know, maybe postgres)? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general