Difference between revisions of "PostgreSQL"

From CBLFS
Jump to navigationJump to search
(→‎Multilib)
Line 2: Line 2:
 
|-
 
|-
 
!Download Source:
 
!Download Source:
−
| http://gd.tuwien.ac.at/db/postgresql/source/v{{PostgreSQL-Version}}/postgresql-{{PostgreSQL-Version}}.tar.bz2
+
| ftp://ftp.us.postgresql.org/pub/mirrors/postgresql/source/v8.2/postgresql-{{PostgreSQL-Version}}.tar.bz2
 
|}
 
|}
  

Revision as of 10:48, 26 December 2006

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

Dependencies

Optional

Optional (To Regenerate The Documentation)

Non-Multilib

Compile the package: 

sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
    configure &&
./configure --prefix=/usr --enable-thread-safety &&
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 &&
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 &&
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 &&
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
Retrieved from "?title=PostgreSQL&oldid=6350"