The database cluster's superuser account can change any role's password. This account is typically named something like "postgres" and is set up when the database cluster is created by 'initdb'. Your OS' package installer may have run 'initdb' for you, but it should have at least told you what the superuser role is named and asked what password it should be given.
Let's say your database cluster superuser role is named "postgres" and your DSpace database user is named "dspace". Something like this should work: psql -U postgres [reply to password prompt with "postgres"' password] ALTER USER dspace WITH VALID UNTIL '2009-08-11'; \q That should let "dspace" log in for another year. Set VALID UNTIL to 'infinity' to have it never expire. To get help from 'psql' you use the command '\h' or '\h VERB'. The backslash is not exactly obvious, but that's how you give 'psql' one of its internal, non-SQL commands. '\q' exits. '\h' describes an SQL command. '\?' lists and briefly describes 'psql' internal commands. -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] Typically when a software vendor says that a product is "intuitive" he means the exact opposite.
pgp6SKUhfahvT.pgp
Description: PGP signature
------------------------------------------------------------------------- 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
