pkg install redmine50

after compile PostgreSQL

cd /usr/port/database/postgresql15-server/
make install clean

change to postgres user

su postgres

initialize database

initdb -D /usr/local/pgsql/data

add PostgreSQL to rc.conf and start prostgresql as root

postgresql_enable="YES"
service postgresql start

follow redmine wiki