Re: Authorise root as postgres

On Sun, Nov 17, 2002 at 07:06:40PM +0000, * Tong * wrote:

> My postgres is password protected, I want to use 'psql -U postgres' as a
> root without specifying password every time, or for a certain group of
> users. How can I do that? I've been banning my head on the walls in
> finding a way to achieve it. Still can't find a way to do it with
> indent, md5 or even passwords authentication. Please help.

You can use the PGPASSWORD environment variable, or ~/.pgpass if 7.3.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The eagle never lost so much time as
when he submitted to learn from the crow." (William Blake, citado por Nobody)