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@knowledgeinenergy.com>
To: <pgsql-novice@postgresql.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@knowledgeinenergy.com
Show Me the Code