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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
