Installation
  cd /usr/pkgsrc/databases/postgresql82/
  make
  make install
  ln /usr/pkg/share/examples/rc.d/pgsql /etc/rc.d/pgsql
Add to /etc/rc.conf
  pgsql=YES
Reboot the system, or type these commands:
  /etc/rc.d/pgsql initdb
  /etc/rc.d/pgsql start
Connect to the database
  psql -U pgsql template1