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@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