如果還沒安裝 PostgreSQL 的話請先看文章後半部。
Install PSQL from official website directly.
Set all METHOD in
truston both IPv4 and IPv6, the file path of
Open the app
pgAdminin program files, create an new role. Check image here if needed.
The name of the role SHOULD BE SAME AS the system user, leave the password field empty and make the privilege as SUPERUSER. Check image here.
pg_hba.conf should look like the settings below:
Windows Settings for Developers @ Andyyou 大尺度私房筆記