--- /dev/null
+postgresql - installation doku - version 7.1.x
+-------------------------------------------------------------------------------------
+
+prerequisites:
+
+we installed postgres on machines with debian / kernel 2.2 / jdk 1.3 (blackdown),
+make sure you don't have postgresql installed via debian / apt-get. if you do
+purge the installation. the following things have to be down as superuser.
+
+
+1. get the tarball from postgresql.org
+
+2. unzip/untar the tarball
+
+3. configure
+
+./configure --enable-odbc --enable-syslog --with-perl --enable-multibyte=UNICODE --enable-locale --enable-unicode-conversion --enable-recode --with-java
+
+4. make
+
+ two problems with the compilation of the jdbc-driver might occur:
+
+ a) an error message "no modern / no classic-compiler"
+ to get rid of this error you have to set a link in
+
+ /usr/lib/j2re/lib/ext
+ to: /usr/lib/j2sdk/lib/tools.jar
+
+ b) an error message "zip-file must have at least one entry"
+ to get rid of this error: make sure you have ant-1.3 installed
+
+5. make install
+
+6. pg_dumplo
+
+you should install "pg_dumplo" from the contrib part of the postgresql-source.
+this little programm enables you to dump the database *including* the oid (blobs).
+
+ cd contrib/pg_dumplo
+ make
+ make install
+
+7. the start-scripts
+
+change to the start-scripts folder in the contrib-part.
+
+ cd ../start-scripts
+ cp linux /etc/init.d/postgresql
+ chmod a+x /etc/init.d/postgresql
+ update-rc.d postgresql defaults
+
+ edit the start-script in /etc/init.d/postgresql, and make sure
+ postgresql is started with the "-i" option. to enable this insert
+ '-o "-i"' after 'start', which should look like:
+
+ start)
+ $ECHO_N "Starting PostgreSQL: "$ECHO_C
+ su - $PGUSER -c "$DAEMON start -o "-i" -D '$PGDATA' -s -l PGLOG"
+ echo "ok"
+ ;;
+
+
+
+8. adding a user / starting the database
+
+ adduser postgres
+ passwd postgres
+ mkdir /usr/local/pgsql/data
+ chown postgres /usr/local/pgsql/data
+ su - postgres
+ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
+
+ /etc/init.d/postgresql start
+ /usr/local/pgsql/bin/createdb test
+ /usr/local/pgsql/bin/psql test
+
+