Difference between revisions of "PostgreSQL"
Chipster19 (talk | contribs) |
(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/ | + | | 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 |
---|
Contents
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