The database support is still considered a technology preview,
and requires knowledge in Postgresql and database setup. You also
need the sources to Planner to access the database scheme file.
can store projects in a PostgreSQL database.  In order to do
this, PostgreSQL must be installed and configured to accept the project
data.  These instructions are intended to outline the steps you should
take to accomplish that.  For more information about PostgreSQL
administration and use, please consult the PostgreSQL documentation
available at The PostgreSQL Web
Site.  The PostgreSQL Documentation includes instructions on
installing from source tarballs.
RPMs are also available from this site if you prefer that method.
Start by logging in as root, and copying the database.sql file to
the /tmp directory. You'll use this file in the last step of the
process, but its better to copy it first rather than go hunting for it
later. Assuming the  folder is in the root directory, you would
do the following:
root# cp /docs/sql/database-0.13.sql /tmpIf you're running Red Hat and you chose to install the PostgreSQL
packages along with the rest of your system, then you already have a
database cluster and default user set up.  The database cluster will
be /var/lib/pgsql/data, and the default user will be postgres.
If there is no default user set up, then create the user postgres
with the home directory /var/lib/pgsql.
Create a database cluster by logging into the postgres account and
executing the initdb command:
root# su - postgresbash$ initdb -D data
Then start the database server:
bash$ pg_ctl -D data -l logfile start
Create a non-default user by logging into the postgres account and
executing the createuser command (use your own user name here - kurt
is mine):
root# su - postgresbash$ createuser
Enter name of user to add: kurt
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
This will allow you to execute commands from your own account rather
than use the default account.
As of v0.13,  can now create the database for you when you save
your project, so you no longer need to perform the remaining steps
in this section manually.
You can now create the database and group from your own account:
kurt# createdb -U kurt plannerdb
CREATE DATABASE
kurt# echo 'create group  with user kurt;' | psql -e -U kurt -d plannerdb
create group  with user kurt;
CREATE GROUP
This final command will build the tables required to store the project
information in the plannerdb database.  The file
database.sql can be found in the
distribution subfolder docs/sql.
kurt# cat /tmp/database.sql | psql -e -U kurt -d plannerdb
This line generates a lot of output.  When it's complete, you should go
back and review the output, checking for any error messages (look for
lines that start with the word ERROR).  If you don't find any, then
all the tables were created successfully.
That's it.  You should now be able to save and open projects using
the PostgreSQL database.
If you have a problem or encounter an error, you can try again removing
the group and database and recreating them:
kurt# dropdb plannerdbkurt# echo 'DROP GROUP ;' | psql -e -U kurt -d plannerdb
