Database Reference
In-Depth Information
Note that many tools and client interfaces work with PostgreSQL without any special
installation. Here, we are discussing modules that extend and alter the behavior of
the server beyond its normal range of SQL standard syntax, functions, and behaviors.
Getting ready
First, you'll need to select an appropriate module to install.
There isn't yet an automated package management system for PostgreSQL, so modules
are located in a range of places, such as the following:
F Contrib— PostgreSQL "core" includes many functions. There is also an official section
for add-in modules, known as "contrib" modules. These are documented at the
following URL:
http://www.postgresql.org/docs/9.0/static/
contrib.html
F pgFoundry— an open source development website created specifically to allow
PostgreSQL modules and tools to be shared. PgFoundry uses the same software
as SourceForge.net. Take a look at the following URL:
http://pgFoundry.org/
F Separate projects— large external projects, such as PostGIS, offer extensive
and complex PostgreSQL modules. Take a look at the following URL:
http://www.postgis.org/
How to do it...
In some cases, modules can be added during installation if you're using a stand-alone
installer application, for example, OneClick installer.
In other cases, you'll be able to install from a package, such as with the Oracle compatibility
module http://www.postgres.cz/index.php/Oracle_functionality
First, we get
http://pgfoundry.org/frs/download.php/2420/orafce-3.0.1-1.pg82.rhel5.
i386.rpm
then install using commands, such as the following:
rpm -ivh orafce-3.0.1-1.pg90.rhel5.i386.rpm
sudo apt-get install postgresql-8.4-orafce
 
Search WWH ::




Custom Search