Difference between revisions of "PostgreSQL"

From CBLFS
Jump to navigationJump to search
Line 31: Line 31:
 
Compile the package:
 
Compile the package:
  
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
+
  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 &&
Line 53: Line 53:
 
Compile the package:
 
Compile the package:
  
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
+
  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 &&
Line 68: Line 68:
 
Compile the package:
 
Compile the package:
  
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
+
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-{{DocBook DSSSL StyleSheets-Version}}|" \
 
     configure &&
 
     configure &&
 
  CC="gcc ${BUILDN32}" ./configure --prefix=/usr --libdir=/usr/lib32 \
 
  CC="gcc ${BUILDN32}" ./configure --prefix=/usr --libdir=/usr/lib32 \
Line 82: Line 82:
 
Compile the package:
 
Compile the package:
  
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-1.79|" \
+
  sed -i "s|dsssl-stylesheets|& \\\\\n        sgml/docbook/&-{{DocBook DSSSL StyleSheets-Version}}|" \
 
     configure &&
 
     configure &&
 
  CC="gcc ${BUILD64}" ./configure --prefix=/usr --libdir=/usr/lib64 \
 
  CC="gcc ${BUILD64}" ./configure --prefix=/usr --libdir=/usr/lib64 \

Revision as of 16:16, 17 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 -melf_i386"

Replace -melf_i386 with the flag that is appropriate for your architecture.

Install the package

make install

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

Install the package

make install

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 &&
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