Difference between revisions of "PostgreSQL"

From CBLFS
Jump to navigationJump to search
(Multilib)
Line 56: Line 56:
 
     configure &&
 
     configure &&
 
  CC="gcc ${BUILD32}" ./configure --prefix=/usr --enable-thread-safety &&
 
  CC="gcc ${BUILD32}" ./configure --prefix=/usr --enable-thread-safety &&
  make LD="ld -melf_i386"
+
  make LD="ld ${LD_BUILD32}"
 
 
'''Replace ''-melf_i386'' with the flag that is appropriate for your architecture.'''
 
  
 
Install the package
 
Install the package
  
  make install
+
  make install &&
 +
mv -v /usr/bin/pg_config{,-32}
  
 
=== N32 ===
 
=== N32 ===
Line 72: Line 71:
 
  CC="gcc ${BUILDN32}" ./configure --prefix=/usr --libdir=/usr/lib32 \
 
  CC="gcc ${BUILDN32}" ./configure --prefix=/usr --libdir=/usr/lib32 \
 
     --enable-thread-safety &&
 
     --enable-thread-safety &&
  make
+
  make LD="ld ${LD_BUILDN32}"
  
 
Install the package
 
Install the package
  
  make install
+
  make install &&
 +
mv -v /usr/bin/pg_config{,-n32}
  
 
=== 64Bit ===
 
=== 64Bit ===
Line 91: Line 91:
  
 
  make install &&
 
  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/* &&
 
  chown -v root:root /usr/share/doc/postgresql/html/* &&
 
  install -v -m755 -d /usr/share/doc/postgresql/{FAQ/html,TODO.detail} &&
 
  install -v -m755 -d /usr/share/doc/postgresql/{FAQ/html,TODO.detail} &&

Revision as of 10:51, 24 December 2006

Download Source: http://gd.tuwien.ac.at/db/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.

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