PostgreSQL

Download Source:	ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/source/v8.4.2/postgresql-8.4.2.tar.bz2

---

Introduction to PostgreSQL

PostgreSQL is an advanced object-relational database management system (ORDBMS), derived from the Berkeley Postgres database management system.

Project Homepage: http://www.postgresql.org

Dependencies

Optional

• Python
• TCL
• OpenSSL
• Linux-PAM
• krb4
• MIT krb5 or Heimdal
• Bonjour

Optional (To Regenerate The Documentation)

• DocBook SGML DTD-4.x
• DocBook DSSSL StyleSheets
• OpenJade
• SGMLS

Additional Configuration Options

--enable-integer-datetimes: Use 64-bit integer storage for datetimes and intervals, rather than the default floating-point storage. This reduces the range of representable values but guarantees microsecond precision across the full range (see Section 8.5 of the PostgreSQL documentation for more information). Note also that the integer datetimes code is newer than the floating-point code, and the postgreSQL team still finds bugs in it from time to time.

--enable-nls[=LANGUAGES]: Enables native language support for the given languages. For instance --enable-nls='de fr' will give you language support in PostgreSQL for German and French.

--with-openssl: Enable OpenSSL support.

--with-pam: Enables Linux-PAM support.

--with-perl: Build the PL/Perl server-side language.

--with-python: Build the PL/Python server-side language.

--with-tcl: Build the PL/TCLserver-side language.

--with-tclconfig=DIRECTORY: Tells configure where to find tclConfig.sh. Normally configure is able to find tclConfig.sh on its own, but if you put it in a non-standard place, then you'll probably have to use this flag.

Non-Multilib

Compile the package:

sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
    configure &&
./configure --prefix=/usr --enable-thread-safety --sysconfdir=/etc &&
make

Install the package

make install &&
chown -v root:root /usr/share/doc/postgresql/html/* &&
install -v -m755 -d /usr/share/doc/postgresql/{FAQ/html,TODO.detail} &&
install -v -m644 doc/TODO /usr/share/doc/postgresql &&
install -v -m644 doc/FAQ* /usr/share/doc/postgresql/FAQ &&
install -v -m644 doc/src/FAQ/* /usr/share/doc/postgresql/FAQ/html &&
install -v -m644 doc/TODO.detail/* \
    /usr/share/doc/postgresql/TODO.detail

Multilib

32Bit

Compile the package:

sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
    configure &&
CC="gcc ${BUILD32}" ./configure --prefix=/usr --enable-thread-safety \
    --sysconfdir=/etc &&
make LD="ld ${LD_BUILD32}"

Install the package

make install &&
mv -v /usr/bin/pg_config{,-32}

N32

Compile the package:

sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
    configure &&
CC="gcc ${BUILDN32}" ./configure --prefix=/usr --libdir=/usr/lib32 \
    --enable-thread-safety --sysconfdir==/etc &&
make LD="ld ${LD_BUILDN32}"

Install the package

make install &&
mv -v /usr/bin/pg_config{,-n32}

64Bit

Compile the package:

sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
    configure &&
CC="gcc ${BUILD64}" ./configure --prefix=/usr --libdir=/usr/lib64 \
    --enable-thread-safety --sysconfdir=/etc &&
make

Install the package

make install &&
mv -v /usr/bin/pg_config{,-64} &&
ln -sfv multiarch_wrapper /usr/bin/pg_config &&
chown -v root:root /usr/share/doc/postgresql/html/* &&
install -v -m755 -d /usr/share/doc/postgresql/{FAQ/html,TODO.detail} &&
install -v -m644 doc/TODO /usr/share/doc/postgresql &&
install -v -m644 doc/FAQ* /usr/share/doc/postgresql/FAQ &&
install -v -m644 doc/src/FAQ/* /usr/share/doc/postgresql/FAQ/html &&
install -v -m644 doc/TODO.detail/* \
    /usr/share/doc/postgresql/TODO.detail