installing postgresql on FreeBSD

After doing the /usr/ports/databases/postgresql7 port make install

root@borrego# su -l pgsql -c initdb
root@borrego# /usr/local/etc/rc.d/010.pgsql.sh start
root@borrego# su pgsql

psql@borrego$ /usr/local/bin/createuser jared  (do this for any users you want to add to postgresql)

>>>Shall the new user be allowed to create databases? (y/n) y

>>>Shall the new user be allowed to create more new users? (y/n) y

>>>CREATE USER
login account jared then:

jared@borrego$ createdb testdb

CREATE DATABASE
jared@borrego$ psql testdb

testdb=# create user blahuser

CREATE USER