Re: Authorise root as postgres - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Authorise root as postgres
Date
Msg-id 20021118140719.GA3571@dcc.uchile.cl
Whole thread Raw
In response to Authorise root as postgres  (* Tong * <tong@none.hub.org>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: "Matthew V." <
Date:
Subject: Re: DECLARE CURSOR
Next
From: Lee Kindness
Date:
Subject: Retrieve Number of rows to be DELETEd