Install Steps

% cd /usr/ports/databases/postgresql83-server
% make all install clean

Configuration

1. /etc/rc.conf

   # PostgreSQL Server
   postgresql_enable="YES"
   postgresql_data="/usr/local/pgsql/data"
   postgresql_flags="-o '-i -d 5 -E' -w -s -m fast"
   postgresql_initdb_flags="--encoding=SQL_ASCII --lc-collate=C"
   

2. create database

   /usr/local/etc/rc.d/postgresql initdb
   

Startup Steps

1. 啟動

         /usr/local/etc/rc.d/postgresql start
   

2. 修改 pgsql 帳號密碼

   % psql -U pgsql template1
   psql> alter user pgsql with password '[想要使用的新密碼]'
   

3. 修改 pg_hba.conf，限定所有的連線都要經過密碼確認

   # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
   
   # "local" is for Unix domain socket connections only
   local   all         all                               md5
   # IPv4 local connections:
   host    all         all         127.0.0.1/32          md5
   # IPv6 local connections:
   host    all         all         ::1/128               md5
   

4. 重新載入設定，即可開啟連線密碼確認功能

   % sudo -u pgsql /usr/local/bin/pg_ctl reload -D "/usr/local/pgsql/data"