Hi Glenn,

> Looks like I wasn¹t paying attention to an old dspace installation we have.
> Postgres is now telling me my password has expired. Not being a postgres
> expert, would anyone be so kind as to let me know how I change/update the
> password so I can get postgres running again?

===
Edit your pg_hba.conf file to 'trust' for user postgres, you will be able to
log in without any password once you restart postgresql.  From there you are
able to chance whatever passwords you want.

http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html
===

(From: http://archives.postgresql.org/pgsql-admin/2006-11/msg00201.php)

Good luck,


Stuart
_________________________________________________________________

Gwasanaethau Gwybodaeth                      Information Services
Prifysgol Aberystwyth                      Aberystwyth University

            E-bost / E-mail: [EMAIL PROTECTED]
                 Ffon / Tel: (01970) 622860
_________________________________________________________________


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to