From: rk <rk>
Date: Sat, 25 Aug 2001 22:23:54 +0000 (+0000)
Subject: no message
X-Git-Tag: arelease~31
X-Git-Url: http://erislabs.net/gitweb/?p=mir.git;a=commitdiff_plain;h=34f5036022cd36b0cf4d2292af6f6292ed3546ac

no message
---

diff --git a/doc/INSTALL.postgresql b/doc/INSTALL.postgresql
new file mode 100755
index 00000000..322ed980
--- /dev/null
+++ b/doc/INSTALL.postgresql
@@ -0,0 +1,77 @@
+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
+
+