\documentclass{article}
\usepackage[latin1]{inputenc}   % Umlaute
%\usepackage[T1]{fontenc}       % richtige Trennung der Worte mit Umlauten
\usepackage{ngerman}            % neue deutsche Rechtschreibung
\usepackage[dvips]{graphicx}
\begin{document}
\section{Preliminary remark}
\small{The postgresql database should be installed on a UNIX or GNU/Linux
system. The GREAT-ER clients can be installed on a windows system
as well but an installation of the database on a windows system
would be experimental at this time. In the following there will be
a description for the installation and configuration of the
postgresql database.}

\section{Create Database and User}
\small{Before the database objects can be created, the database must be
created. Therefore you have to login as postgres user: \\

\textbf{su postgres }

\textbf{createdb [-h $<$host$>$] [-p $<$port$>$] -E unicode $<$dbname$>$ $<$description$>$} \\

\textsl{Parameter :}
\begin{quote} $<$host$>$ name of the host \\ $<$port$>$ number of the port \\
$<$dbname$>$ alias of the database \\ $<$description$>$ e.g. "'GREAT-ER II database"' \\ 
\end{quote}  The -E option specifies the character encoding scheme to be used in the
database. If your \textbf{standard installtion} does not support
the language 'plpgsql' you have to install it manually: \\

\textbf{createlang [-h $<$host$>$] [-p $<$port$>$] -d $<$dbname$>$ plpgsql} \\

\textsl{Parameter : }
\begin{quote} $<$host$>$ name of the host \\
$<$port$>$ number of the port \\ $<$dbname$>$ alias of the
database \\ \end{quote} Now you have to create a new database user. In the next
chapter this user will be made the owner of the system tables,
that are created there: \\ 

\textbf{createuser [-h $<$host$>$] [-p $<$port$>$] -D -A -e $<$user$>$ } \\

\textsl{Parameter :} 
\begin{quote} $<$host$>$ name of
the host \\ $<$port$>$ number of the port \\ $<$user$>$ username \\
\end{quote} This user is not automatically a new GREAT-ER user.
It's just a new database user. To make the new database user a new
GREAT-ER user, you have to use the administration tool or insert
the data manually into the USER\_TAB and GROUP\_TAB after the
system has been created.}

\newpage

\section{Create Database Objects and import Data}
\small{Upon creating the database and the user you have to restore the
dump. The user you just created will be the owner of the
structure, that will be restored. You have to adopt its name after
the -U: \\ 

\textbf{pg\_restore -d $<$dbname$>$ -S postgres -U $<$user$>$ greater\_base.dmp.tar} \\

\textsl{Parameter :}
\begin{quote} $<$dbname$>$ alias of the database \\ $<$user$>$ username
\\ \end{quote} Like in the other 
cases you have the possibility to specify the name of the host 
an the number of port by the -h and -p options after the pg\_restore command. }

\end{document}
