Re: How to know the password for the user 'postgres' - Mailing list pgsql-general

From Tony Caduto
Subject Re: How to know the password for the user 'postgres'
Date
Msg-id 4906A1A9.2090602@amsoftwaredesign.com
Whole thread Raw
In response to How to know the password for the user 'postgres'  ("Shashank Sahni" <shredder12@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ivano Luberti
Date:
Subject: Re: Replication with slony-I
Next
From: Gregory Stark
Date:
Subject: Re: PostgreSQL 8.3.3 chooses wrong query plan when LIMIT 1 added?