Novell PLATESPIN ORCHESTRATE 2.0.2, Installation And Configuration Manual, Page: 41 / 132

Installation and Configuration 41
no
vd
ocx
(e
n)
13
Ma
y 20
09
yast2 -i postgresql-server
When PostgreSQL is installed, you need to create the default database and start it. Use the following
commands:
su - postgres
initdb
pg_ctl start
These commands create or update the PostgreSQL privilege database and installs the prepared
tables. For more detail about what you will see when you run these commands, see
“Detail” on
page 37 .
NOTE: You cannot run the
pg_ctl
command as
root
. You must first change to the superuser for
PostgreSQL (
su - postgres
). Failure to issue this command first results in the following
messages:
# pg_ctl start
pg_ctl: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.
Logging in Locally to the PostgreSQL Database
When you have installed the database, the next step is to check that you can connect to the database
on the database host. The default admin username is
postgres
. Use the following commands to set
up a password for the postgres user on the database host machine:
psql
NOTE: Remember the password. You need it to log in to the database later.
Running this command results in a screen like this:
Welcome to psql 8.1.11, 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=# alter user postgres password 'pass';
ALTER ROLE
postgres=#
Installing and Configuring the Local PlateSpin Orchestrate Audit Database
When you enable and configure PlateSpin Orchestrate auditing, you create a small custom database
and a simple schema that persists all of the PlateSpin Orchestrate jobs that have been run, along with
their parameters.The database also maintains the login or logout activity of the PlateSpin
Orchestrate users and resources.