PostgreSQL Database
sudo to postgres and create a new database user:
createuser -D -I -R -S -P core_user
Create an empty database owned by that user:
createdb -O core_user -T template0 core_test_db
Developer info: use this command to create an empty database with all definitions and transfer it directly to the dev host where the installer is:
pg_dump -x --disable-dollar-quoting --attribute-inserts -O -s core | ssh cajones.org "cat - > /home/www/test.core.install/public/installer/sql/data.sql"