#su - postgres
$psql -p 5432 -U postgres
postgres=#alter user postgres with password 'new password';

新建用户

postgres=#create user new_user with password 'new password';

新建数据库

postgres=#CREATE DATABASE new_db OWNER new_user ENCODING 'UTF-8'; postgres=#\q