Re: postgres user

Start psql as postgres (i.e. psql -Upostgres -dtemplate1)

alter user postgres with password 'secret';

You can then edit pg_hba.conf to indicate that passwords are required for
local login, etc.

--rob

----- Original Message -----
From: "Mike Hammonds" <mhammonds(at)knowledgeinenergy(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, December 12, 2000 2:53 PM
Subject: postgres user

** Reply Requested When Convenient **

How do I get the postgres users password into pg_shadow?

Mike Hammonds, CNE5, MCP-NT
Fellon-McCord & Associates, Inc.
Office: 502.214-6324
Fax: 502.426.8800
mhammonds(at)knowledgeinenergy(dot)com

Show Me the Code