1 postgresql - installation doku - version 7.1.x
2 -------------------------------------------------------------------------------------
6 we installed postgres on machines with debian / kernel 2.2 / jdk 1.3 (blackdown),
7 make sure you don't have postgresql installed via debian / apt-get. if you do
8 purge the installation.
10 make sure you have libreadline-dev package installed, otherwise you won't be
11 able to use cursor/backspace in psql-shell.
13 the following things have to be done as superuser (if not otherwise stated):
16 1. get the tarball from postgresql.org
18 2. unzip/untar the tarball
22 ./configure --enable-odbc --enable-syslog --with-perl --enable-multibyte=UNICODE \
23 --enable-locale --enable-unicode-conversion --enable-recode --with-java
27 two problems with the compilation of the jdbc-driver might occur:
29 a) an error message "no modern / no classic-compiler"
30 to get rid of this error you have to set a link in
33 to: /usr/lib/j2sdk/lib/tools.jar
35 b) an error message "zip-file must have at least one entry"
36 to get rid of this error: make sure you have ant-1.3 installed
42 you should install "pg_dumplo" from the contrib part of the postgresql-source.
43 this little programm enables you to dump the database *including* the oid (blobs).
51 change to the start-scripts folder in the contrib-part.
54 cp linux /etc/init.d/postgresql
55 chmod a+x /etc/init.d/postgresql
56 update-rc.d postgresql defaults
58 edit the start-script in /etc/init.d/postgresql, and make sure
59 postgresql is started with the "-i" option. to enable this insert
60 '-o "-i"' after 'start', which should look like:
63 $ECHO_N "Starting PostgreSQL: "$ECHO_C
64 su - $PGUSER -c "$DAEMON start -o '-i' -D '$PGDATA' -s -l PGLOG"
70 8. adding a user / starting the database
74 mkdir /usr/local/pgsql/data
75 chown postgres /usr/local/pgsql/data
77 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
79 /etc/init.d/postgresql start
80 /usr/local/pgsql/bin/createdb test
81 /usr/local/pgsql/bin/psql test