FreeBSD: Instalar PostgreSQL

#cd /usr/ports/databases/postgresql83-server/
#make config

Opções:

WITH_NLS=true
WITH_OPTIMIZED_CFLAGS=true
WITH_XML=true
WITH_TZDATA=true

# make install clean

Iniciando o PostgreSQL

#echo ‘postgresql_enable=”YES”‘ >>/etc/rc.conf
#/usr/local/etc/rc.d/postgresql initdb
#/usr/local/etc/rc.d/postgresql start

#su - pgsql

$psql postgres

Welcome to psql 8.3.7, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

postgres=# CREATE USER postfix WITH PASSWORD ‘postfixadmin’;
postgres=#CREATE DATABASE postfix OWNER postfix ENCODING ‘unicode’;
postgres=#\q

$exit

FONTE: http://web.inseto.net/?p=1