Re: How to know the password for the user 'postgres'

Shashank Sahni wrote:
>
> when i posted the question on dspace mailing list..one of the guy
> replied me with this solution..
>     createuser -h localhost -U postgres -d -A -P dspace
> but he said that to execute the above command i must know the password
> for the user postgres..
Edit the pg_hba.conf file and add a entry for the PC you are doing your
admin from and set it to Trust.
When set to trust you won't need a password, then use the admin tool of
your choice to change the postgres password to whatever
you want.  Afterwards remember to set it back to MD5 or whatever it was
prior to you making the change.

Later,

Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com