Postgre 忘記密碼

修改pg_hba.conf如下:
# IPv4 local connections:
host all all 127.0.0.1/32 md5
md5換成trust後重啟

執行要換的密碼:
psql -d template1 -U postgres -c "alter role postgres password ‘xxxx’;