[PSQL] 安裝並連接到 Rails
如果還沒安裝 PostgreSQL 的話請先看文章後半部。
在 Rails 中使用 PostgreSQL
安裝 PostgreSQL 的 gem
gem install pg
建立 Rails APP
rails new blogapp --database=postgresql
Windows
Install PostgreSQL and integrate with Ruby on Rails
Install PSQL from official website directly.
Set all METHOD in
pg_hba.conf
astrust
on both IPv4 and IPv6, the file path ofpg_hba.conf
is%HOMEPATH%\psql\pg_hba.conf
in Windows.Open the app
pgAdmin
in 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.
The pg_hba.conf
should look like the settings below:
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
Windows Settings for Developers @ Andyyou 大尺度私房筆記