This page will be moved to the project web site once we've picked a good one.
PostgreSQL Database
Postgres
sudo to postgres and create a new database user:
Code Block |
---|
createuser -D -I -R -S -P core_user |
Create an empty database owned by that user:
Code Block |
---|
createdb -O core_user -T template0 core_test_db |
Warninginfo |
---|
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" |