Contents 1 Package 2 Description 3 Main Page 4 Current Stable Version 5 Version Check 6 Dependencies 7 Standard Build Units (SBUs) 8 Download URLs 9 Compilation Sequence 9.1 Main Compilation Sequence 9.2 Initial Database Setup 9.3 For Wikis 9.4 Exiting After Install 10 Special Considerations 11 Common Problems

Package Edit

• postgresql

Description Edit

• unknown

Main Page Edit

• unknown

Current Stable Version Edit

• 8.1.3

Version Check Edit

• unknown

Dependencies Edit

• readline

Standard Build Units (SBUs) Edit

• unknown

Download URLs Edit

• unknown

Compilation Sequence Edit

Main Compilation Sequence Edit

• bunzip2 < postgresql-8.1.3.tar.bz2 | tar x
• cd postgresql-8.1.3
• ./configure
• make
• make -C contrib/tsearch2
  • for wikipgedia
• su
• make install

Initial Database Setup Edit

• adduser postgres -p password
• mkdir /usr/local/pgsql
• mkdir /usr/local/pgsql/data
• chown postgres /usr/local/pgsql/data
• su
  • As postgres
• cd /home/postgres
• /usr/bin/initdb -D /usr/local/pgsql/data
• /usr/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
• /usr/bin/createdb test

For Wikis Edit

• /usr/bin/psql wikidb < ./contrib/tsearch2/tsearch2.sql
  • From the postgresql package dir

Exiting After Install Edit

• exit
  • From postgres
• exit
  • From superuser
• cd ..

Special Considerations Edit

• unknown

Common Problems Edit

• unknown