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 the following things have to be done as superuser (if not otherwise stated):
13 1. make sure you have:
20 2. get the tarball from postgresql.org
22 tar xvfz postgresql-7.1.3.tar.gz
26 ./configure --enable-odbc --enable-syslog --with-perl --enable-multibyte=UNICODE \
27 --enable-locale --enable-unicode-conversion --enable-recode --with-java
31 two problems with the compilation of the jdbc-driver might occur:
33 a) an error message "no modern / no classic-compiler"
34 to get rid of this error you have to set a link in
37 to: /usr/lib/j2sdk/lib/tools.jar
39 b) an error message "zip-file must have at least one entry"
40 to get rid of this error: make sure you have ant-1.3 installed
46 you should install "pg_dumplo" from the contrib part of the postgresql-source.
47 this little programm enables you to dump the database *including* the oid (blobs).
55 change to the start-scripts folder in the contrib-part.
58 cp linux /etc/init.d/postgresql
59 chmod a+x /etc/init.d/postgresql
60 update-rc.d postgresql defaults
62 edit the start-script in /etc/init.d/postgresql, and make sure
63 postgresql is started with the "-i" option. to enable this insert
64 '-o "-i"' after 'start', which should look like:
67 $ECHO_N "Starting PostgreSQL: "$ECHO_C
68 su - $PGUSER -c "$DAEMON start -o '-i' -D '$PGDATA' -s -l PGLOG"
74 8. adding a user / starting the database
78 mkdir /usr/local/pgsql/data
79 chown postgres /usr/local/pgsql/data
81 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
83 /etc/init.d/postgresql start
84 /usr/local/pgsql/bin/createdb test
85 /usr/local/pgsql/bin/psql test
89 See INSTALL.mir for basic dealing with postgresql user.
90 Use 'createdb -U postgres' to create a Database. Create
91 tables with different User inside the Database.
94 Fine! - now you can continue with the postgresql-section in INSTALL.mir