Kullanici sifre resetleme - User password reset change
Definition Description
http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/ 1. How to change PostgreSQL root user password ? $ /usr/local/pgsql/bin/psql postgres postgres Password: (oldpassword) # ALTER USER postgres WITH PASSWORD 'tmppassword'; $ /usr/local/pgsql/bin/psql postgres postgres Password: (tmppassword) Changing the password for a normal postgres user is similar as changing the password of the root user. Root user can change the password of any user, and the normal users can only change their passwords as Unix way of doing. # ALTER USER username WITH PASSWORD 'tmppassword';
