Difference between revisions of "PostgreSQL"

From CBLFS
Jump to navigationJump to search
(I added the "Additional Configuration Options" section.)
Line 1: Line 1:
 
{| style="text-align: left; background-color: AliceBlue;"
 
{| style="text-align: left; background-color: AliceBlue;"
|-
+
|-valign="top"
 
!Download Source:
 
!Download Source:
| ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/source/v8.2/postgresql-{{PostgreSQL-Version}}.tar.bz2
+
| ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/source/v{{PostgreSQL-Version2}}/postgresql-{{PostgreSQL-Version}}.tar.bz2
 
|}
 
|}
  
Line 26: Line 26:
 
* [[OpenJade]]
 
* [[OpenJade]]
 
* [[Perl Module SGMLS|SGMLS]]
 
* [[Perl Module SGMLS|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 [http://www.postgresql.org/docs/8.1/static/datatype-datetime.html 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/[[TCL]]server-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 ==
 
== Non-Multilib ==
Line 33: Line 51:
 
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-{{DocBook DSSSL StyleSheets-Version}}|" \
 
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-{{DocBook DSSSL StyleSheets-Version}}|" \
 
     configure &&
 
     configure &&
  ./configure --prefix=/usr --enable-thread-safety &&
+
  ./configure --prefix=/usr --enable-thread-safety --sysconfdir=/etc &&
 
  make
 
  make
  
Line 55: Line 73:
 
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-{{DocBook DSSSL StyleSheets-Version}}|" \
 
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-{{DocBook DSSSL StyleSheets-Version}}|" \
 
     configure &&
 
     configure &&
  CC="gcc ${BUILD32}" ./configure --prefix=/usr --enable-thread-safety &&
+
  CC="gcc ${BUILD32}" ./configure --prefix=/usr --enable-thread-safety \
 +
    --syconfdir=/etc &&
 
  make LD="ld ${LD_BUILD32}"
 
  make LD="ld ${LD_BUILD32}"
  
Line 70: Line 89:
 
     configure &&
 
     configure &&
 
  CC="gcc ${BUILDN32}" ./configure --prefix=/usr --libdir=/usr/lib32 \
 
  CC="gcc ${BUILDN32}" ./configure --prefix=/usr --libdir=/usr/lib32 \
     --enable-thread-safety &&
+
     --enable-thread-safety --sysconfdir==/etc &&
 
  make LD="ld ${LD_BUILDN32}"
 
  make LD="ld ${LD_BUILDN32}"
  
Line 85: Line 104:
 
     configure &&
 
     configure &&
 
  CC="gcc ${BUILD64}" ./configure --prefix=/usr --libdir=/usr/lib64 \
 
  CC="gcc ${BUILD64}" ./configure --prefix=/usr --libdir=/usr/lib64 \
     --enable-thread-safety &&
+
     --enable-thread-safety --sysconfdir=/etc &&
 
  make
 
  make
  

Revision as of 17:30, 9 January 2007

Download Source: ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/source/vTemplate:PostgreSQL-Version2/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.

Dependencies

Optional

Optional (To Regenerate The Documentation)

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 \
    --syconfdir=/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