On Saturday 18 December 2004 01:12 pm, Eric Scott wrote: > Heya; > > Webmin isn't changing my password on PostGreSQL accounts when I tell it > to... hit the save button... the works. It's just not being chipper. > Any help? I don't necessarily need Webmin.... how would I change a > user's password in PostGreSQL manually on my Mandrake 9.2 Server? > Thanx, > ES
Hi Eric, 1. edit /var/lib/pgsql/data/pg_hba.conf change/remark the connection authentification method, and add this line: local all all trust <-- it won't ask you any password anymore 2. restart postgresql: service postgresql restart 3. su postgres 4. psql -U postgres -d template1 5. alter user nameofuser with password 'thepassword'; 6. \q <-- to quit 7. exit 8. restore the pg_hba.conf back to the original setting. 9. restart posgresql 10. you're clear to go :) -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 13:26:03 up 5:20, Mandrakelinux release 10.1 (Official) for i586 public key: https://www.arinet.org/fajar-pub.key
____________________________________________________ Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com ____________________________________________________