<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title> Practical PostgreSQL</title>
<meta name="keywords" content="postgresql, support, recovery, design, software, hosting, expterise, programming, postgres, pgsql, replication, mysql, firebird, database, sql, free, open source, software" />
<meta name="description" content="Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. " />
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="../css/layout.css" />
<link rel="stylesheet" type="text/css" href="../css/cmd4.css" />
<script language="javascript" type="text/javascript"><!--
greymenuhomewideLit = new Image();
greymenuhomewideLit.src = "/images/greymenu_homewide_lit.gif";
greymenuaboutLit = new Image();
greymenuaboutLit.src = "/images/greymenu_about_lit.gif";
greymenuproductsLit = new Image();
greymenuproductsLit.src = "/images/greymenu_products_lit.gif";
greymenuservicesLit = new Image();
greymenuservicesLit.src = "/images/greymenu_services_lit.gif";
greymenusupportLit = new Image();
greymenusupportLit.src = "/images/greymenu_support_lit.gif";
greymenucommunityLit = new Image();
greymenucommunityLit.src = "/images/greymenu_community_lit.gif";
//--></script>
</head>
<body>
<div align="center">
<div id="widecontainer">
<div id="widetop">
<div class="throwleft" style="width: 300px; text-align: left;"><a href="http://www.commandprompt.com/"><img src="../images/cmd4logo_wide.gif" border="0" alt="Command Prompt, Inc." /></a></div>
<div class="throwright" style="width: 400px; text-align: right;">
<div id="topright">
<form action="index.html" name="cmdform" method="post">
<ul>
<li><input type="text" name="search" value="" /></li>
<li><input type="submit" name="action" value="Search Book" /></li>
</ul>
</form>
</div>
</div>
</div>
<ul id="greymenu_wide">
<li><a href="http://www.commandprompt.com/home/"><img onmouseover="this.src = greymenuhomewideLit.src;" onmouseout="this.src = '/images/greymenu_homewide.gif';" src="../images/greymenu_homewide.gif" border="0" height="22" title="" alt="" /></a></li><li><img src="../images/greymenu_divider.gif" border="0" width="2" height="22" alt="|" /></li><li><a href="http://www.commandprompt.com/about/"><img onmouseover="this.src = greymenuaboutLit.src;" onmouseout="this.src = '/images/greymenu_about.gif';" src="../images/greymenu_about.gif" border="0" height="22" title="" alt="" /></a></li><li><img src="../images/greymenu_divider.gif" border="0" width="2" height="22" alt="|" /></li><li><a href="http://www.commandprompt.com/products/"><img onmouseover="this.src = greymenuproductsLit.src;" onmouseout="this.src = '/images/greymenu_products.gif';" src="../images/greymenu_products.gif" border="0" height="22" title="" alt="" /></a></li><li><img src="../images/greymenu_divider.gif" border="0" width="2" height="22" alt="|" /></li><li><a href="http://www.commandprompt.com/services/"><img onmouseover="this.src = greymenuservicesLit.src;" onmouseout="this.src = '/images/greymenu_services.gif';" src="../images/greymenu_services.gif" border="0" height="22" title="" alt="" /></a></li><li><img src="../images/greymenu_divider.gif" border="0" width="2" height="22" alt="|" /></li><li><a href="http://www.commandprompt.com/support/"><img onmouseover="this.src = greymenusupportLit.src;" onmouseout="this.src = '/images/greymenu_support.gif';" src="../images/greymenu_support.gif" border="0" height="22" title="" alt="" /></a></li><li><img src="../images/greymenu_divider.gif" border="0" width="2" height="22" alt="|" /></li><li><a href="http://www.commandprompt.com/community/"><img onmouseover="this.src = greymenucommunityLit.src;" onmouseout="this.src = '/images/greymenu_community.gif';" src="../images/greymenu_community.gif" border="0" height="22" title="" alt="" /></a></li> </ul>
<div style="padding-left: 16px; width: 96%;">
<HTML
><HEAD
><TITLE
>What is PostgreSQL?</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.72
"><LINK
REL="HOME"
TITLE="Practical PostgreSQL"
href="book1"><LINK
REL="UP"
TITLE="Introduction and Installation"
href="p206"><LINK
REL="PREVIOUS"
TITLE="Introduction and Installation"
href="p206"><LINK
REL="NEXT"
TITLE="PostgreSQL Feature Set"
href="x293"></HEAD
><BODY
CLASS="CHAPTER"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Practical PostgreSQL</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
href="p206"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
href="x293"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="CHAPTER"
><H1
><A
NAME="WHATISPOSTGRESQL"
>Chapter 1. What is PostgreSQL?</A
></H1
><DIV
CLASS="TOC"
><DL
><DT
><B
>Table of Contents</B
></DT
><DT
><A
href="c208#AEN226"
>Open Source Free Version</A
></DT
><DT
><A
href="x293"
>PostgreSQL Feature Set</A
></DT
><DT
><A
href="x337"
>Where to Proceed from Here</A
></DT
></DL
></DIV
><P
>PostgreSQL is an Object-Relational Database Management System (ORDBMS) that has been
developed in various forms since 1977. It began as a project named Ingres at the University of California at
Berkeley. Ingres itself was later developed commercially by Relational
Technologies/Ingres Corporation.</P
><P
>In 1986 another team led by Michael Stonebraker from Berkeley continued the development of
the Ingres code to create an object-relational database system called Postgres. In 1996, due to a
new open source effort and the enhanced functionality of the software, Postgres was renamed to
PostgreSQL, after a brief stint as Postgres95. The PostgreSQL project is still under very active
development worldwide from a team of open source developers and contributors.</P
><P
>PostgreSQL is widely considered to be the most advanced open source database system in the
world. It provides many features (which are discussed in more detail in <A
href="x293"
>the Section called <I
>PostgreSQL Feature Set</I
></A
>") that
are traditionally seen only in enterprise-caliber commercial products.</P
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="AEN226"
>Open Source Free Version</A
></H1
><P
>PostgreSQL is an open source project. Open source by definition means that you can obtain
the source code, use the program, and modify it freely without the confines of proprietary
software. In the database world, open source means that you have honest access to benchmarking
numbers and performance statistics, which companies such as Oracle prohibit. Open source also
means that you are free to modify PostgreSQL to fit your particular needs.</P
><P
>However, there is a misconception that since open source software is free from distribution
restrictions, it is always free of cost to your company. This is not necessarily the case.
It is true that you can, without external cost, download and install open source software, but
there will always be costs associated with the time and energy your company puts into support
and research of the application. As such, if you do not have those resources to spend, there
are several commercial vendors and consultants who deal specifically with PostgreSQL.</P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN232"
>Commercial PostgreSQL Products</A
></H2
><P
>The Red Hat version of PostgreSQL is called Red Hat Database
and is a very new product to the database market. Red Hat Database
is based on the community-released open source version, PostgreSQL 7.1.
Red Hat Database currently supports Linux only, preferably Red Hat Linux 7.1.</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN238"
>Open Source Versus Commercial Products</A
></H2
><P
>The open source version of PostgreSQL only includes the database-management system and
the associated programming interfaces. The Red Hat version of PostgreSQL
includes a graphical installer and limited support for the installation.</P
><P
>The main factor in deciding whether to use the open source
version of PostgreSQL or a commercially packaged version
should be your business requirements. If you have a knowledgeable on-site
technical-support staff, the community version may do well for you.
However, if you need installation, configuration, and management support,
you may be better served by purchasing a commercial version of
PostgreSQL.</P
><P
>If you prefer to do business with smaller consulting companies, we have compiled a
modest list of professional companies providing support for PostgreSQL in <A
href="c208#COMMERCIALSUPPORT"
>the Section called <I
>Commercial Support</I
></A
>."</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="THEBOTTOMLINE"
>The Bottom Line</A
></H2
><P
>Marketing would suggest that a commercial version of
PostgreSQL is somehow objectively superior to an open source
version of PostgreSQL. In reality, this is not the case. When
deciding what version of PostgreSQL you are going to run, you need
only be aware of your own needs. For example, are you going to need
installation support? Is a graphical installation important to you? If
they are, then you should probably purchase a commercial version of
PostgreSQL. However, if you or one of your staff are comfortable with
compiling and configuring source code, the open source version could
be more applicable to you.</P
><P
>There are two additional questions you may want to ask. Do you need printed
documentation and are you willing to pay for PostgreSQL? The commercial distribution
comes with printed documentation. However, if you are reading this book, we hope you
won't need the additional documentation. The other question relates to cost. Red Hat Database is priced at
$2,295.00.</P
><P
>The most important thing to remember when deciding on which version of PostgreSQL to
use is this (from a perspective of general usage and feature availability): <SPAN
><I
CLASS="EMPHASIS"
>there
is no practical difference between the open source and the commercial versions.</I
></SPAN
></P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="COMMERCIALSUPPORT"
>Commercial Support</A
></H2
><P
>Outside of Red Hat, there are many companies that provide consulting
services to the PostgreSQL community. The following is a small list of consultants
providing commercial support for PostgreSQL.</P
><P
> <P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
>Command Prompt, Inc. (<SPAN
><I
CLASS="EMPHASIS"
>http://www.commandprompt.com/</I
></SPAN
>)</DT
><DD
><P
>Command Prompt, Inc. is a Linux managed-services and PostgreSQL-support company. They provide Linux and
PostgreSQL support, including custom programming in C & C++, Java, PHP, Perl, and their own LXP application server
for PostgreSQL.</P
><P
>Command Prompt, Inc. is the author of this book.</P
></DD
><DT
>Cybertec Geschwinde & Schvnig OEG (<SPAN
><I
CLASS="EMPHASIS"
>http://postgres.cybertec.at/</I
></SPAN
>)</DT
><DD
><P
>Cybertec provides training courses, support, consulting, and
cost-effective high-end systems. Cybertec services the German-speaking region (Austria, Germany, and Switzerland).</P
></DD
><DT
>dbExperts (<SPAN
><I
CLASS="EMPHASIS"
>http://www.dbexperts.com.br/</I
></SPAN
>)</DT
><DD
><P
>dbExperts offers training courses, specialized support for development, and
commercial products for PostgreSQL. dbExperts is located in Brazil and
provides services in the Portuguese language.</P
></DD
><DT
>PostgreSQL, Inc. (<SPAN
><I
CLASS="EMPHASIS"
>http://www.pgsql.com/</I
></SPAN
>)</DT
><DD
><P
>PostgreSQL, Inc. offers support for PostgreSQL, database
hosting, and promotional materials.</P
></DD
><DT
>Software Research Associates (<SPAN
><I
CLASS="EMPHASIS"
>http://osb.sra.co.jp/</I
></SPAN
>)</DT
><DD
><P
>Software Research Associates offers a range of services to
aid customers with open source software-based systems. Support from
this company is also available in Japanese.</P
></DD
></DL
></DIV
>
</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="COMMSUPPORT"
>Community Support</A
></H2
><P
>The PostgreSQL community provides active support to users of PostgreSQL via a number of
mailing lists. There are several user mailing lists to which you can subscribe, segregated by
topic (e.g., <SPAN
><I
CLASS="EMPHASIS"
>pgsql-general</I
></SPAN
>, <SPAN
><I
CLASS="EMPHASIS"
>pgsql-hackers</I
></SPAN
>, etc.).
The mailing lists for PostgreSQL users are quite thorough, covering everything from general
discussion to support on developing with PostgreSQL programming interfaces.
For a complete list of mailing lists with associated descriptions, please visit the PostgreSQL
website at <SPAN
><I
CLASS="EMPHASIS"
>http://www.postgresql.org</I
></SPAN
>.</P
></DIV
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
href="p206"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
href="book1"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
href="x293"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Introduction and Installation</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
href="p206"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>PostgreSQL Feature Set</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
</div>
<br />
<div id="thefineprint">
<a href="http://www.commandprompt.com/products/mammothpostgresql/"><img src="../images/powered_by_mammoth.gif" alt="Powered by Mammoth PostgreSQL" title="Powered by Mammoth PostgreSQL" border="0" /></a>
<br />
Copyright © 2000-2007 Command Prompt, Inc. All Rights Reserved. All trademarks property of their respective owners.
</div>
</div>
</div>
</body>
</html>