<!--

$PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.47 2004/12/17 04:50:32 tgl Exp $

$PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.48 2005/03/31 03:54:37 momjian Exp $

-->

<chapter id="tutorial-advanced">

<para>

If you feel you need more introductory material, please visit the

<ulink url="http://www.postgresql.org">PostgreSQL web

site</ulink> for links to more resources.

PostgreSQL web site,

<ulink url="http://www.postgresql.org"></ulink>, for links to more resources.

</para>

</sect1>

</chapter>

<!--

$PostgreSQL: pgsql/doc/src/sgml/biblio.sgml,v 1.21 2005/02/21 02:21:00 neilc Exp $

$PostgreSQL: pgsql/doc/src/sgml/biblio.sgml,v 1.22 2005/03/31 03:54:37 momjian Exp $

-->

<bibliography id="biblio">

<para>

Some white papers and technical reports from the original

<productname>POSTGRES</productname> development team

are available at

are available at the University of California, Berkeley, Computer Science

Department web site,

<ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/">

the University of California, Berkeley, Computer Science

Department web site</ulink>

</ulink>

</para>

<bibliodiv>

</biblioentry>

<biblioentry id="FONG">

<title><ulink

url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/UCB-MS-zfong.pdf">The

design and implementation of the

<productname>POSTGRES</productname> query optimizer</ulink></title>

<title>The design and implementation of the

<productname>POSTGRES</productname> query optimizer,

<ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/UCB-MS-zfong.pdf"></ulink></title>

<author>

<firstname>Zelaine</firstname>

<surname>Fong</surname>

<biblioentry id="ROWE87">

<biblioset relation="article">

<title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-13.pdf">The <productname>POSTGRES</productname> data model</ulink></title>

<title>The <productname>POSTGRES</productname> data model, <ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-13.pdf"></ulink></title>

<titleabbrev>Rowe and Stonebraker, 1987</titleabbrev>

<authorgroup>

<author>

<biblioentry id="SESHADRI95">

<biblioset relation="article">

<title><ulink url="http://simon.cs.cornell.edu/home/praveen/papers/partindex.de95.ps.Z">Generalized Partial Indexes</ulink>

<title>Generalized Partial Indexes,<ulink url="http://simon.cs.cornell.edu/home/praveen/papers/partindex.de95.ps.Z"></ulink>

</title>

<titleabbrev>Seshardri, 1995</titleabbrev>

<authorgroup>

<biblioentry id="STON86">

<biblioset relation="article">

<title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M85-95.pdf">The design of <productname>POSTGRES</productname></ulink></title>

<title>The design of <productname>POSTGRES</productname>, <ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M85-95.pdf"></ulink></title>

<titleabbrev>Stonebraker and Rowe, 1986</titleabbrev>

<authorgroup>

<author>

<biblioentry id="STON87b">

<biblioset relation="article">

<title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-06.pdf">The design of the <productname>POSTGRES</productname> storage system</ulink></title>

<title>The design of the <productname>POSTGRES</productname> storage system, <ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M87-06.pdf"></ulink></title>

<titleabbrev>Stonebraker, 1987</titleabbrev>

<authorgroup>

<author>

<biblioentry id="STON89">

<biblioset relation="article">

<title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-82.pdf">A commentary on the <productname>POSTGRES</productname> rules system</ulink></title>

<title>A commentary on the <productname>POSTGRES</productname> rules system, <ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-82.pdf"></ulink></title>

<titleabbrev>Stonebraker et al, 1989</titleabbrev>

<authorgroup>

<author>

<biblioentry id="STON89b">

<biblioset relation="article">

<title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-17.pdf">The case for partial indexes</ulink></title>

<title>The case for partial indexes,<ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M89-17.pdf"></ulink></title>

<titleabbrev>Stonebraker, M, 1989b</titleabbrev>

<authorgroup>

<author>

<biblioentry id="STON90a">

<biblioset relation="article">

<title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-34.pdf">The implementation of <productname>POSTGRES</productname></ulink></title>

<title>The implementation of <productname>POSTGRES</productname>, <ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-34.pdf"></ulink></title>

<titleabbrev>Stonebraker, Rowe, Hirohama, 1990</titleabbrev>

<authorgroup>

<author>

<biblioentry id="STON90b">

<biblioset relation="article">

<title><ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-36.pdf">On Rules, Procedures, Caching and Views in Database Systems</ulink></title>

<title>On Rules, Procedures, Caching and Views in Database Systems,<ulink url="http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/papers/ERL-M90-36.pdf"></ulink></title>

<titleabbrev>Stonebraker et al, ACM, 1990</titleabbrev>

<authorgroup>

<author>

<!--

$PostgreSQL: pgsql/doc/src/sgml/client-auth.sgml,v 1.72 2005/01/28 22:38:37tgl Exp $

$PostgreSQL: pgsql/doc/src/sgml/client-auth.sgml,v 1.73 2005/03/31 03:54:37momjian Exp $

-->

<chapter id="client-authentication">

authentication system suitable for distributed computing over a public

network. A description of the <productname>Kerberos</productname> system

is far beyond the scope of this document; in full generality it can be

quite complex (yet powerful). The<ulink

url="http://www.nrl.navy.mil/CCS/people/kenh/kerberos-faq.html">Kerberos

<acronym>FAQ</></ulink> or<ulink url="ftp://athena-dist.mit.edu">MIT

Project Athena</ulink>can be a good starting point for exploration.

quite complex (yet powerful). TheKerberos <acronym>FAQ</>,

<ulinkurl="http://www.nrl.navy.mil/CCS/people/kenh/kerberos-faq.html"></ulink>, or

MIT Project Athena,<ulink url="ftp://athena-dist.mit.edu"></ulink>,

can be a good starting point for exploration.

Several sources for <productname>Kerberos</> distributions exist.

</para>

<para>

If you use <application>mod_auth_kerb</application> from

<ulink url="http://modauthkerb.sf.net">http://modauthkerb.sf.net</ulink>

<ulink url="http://modauthkerb.sf.net"></ulink>

and <application>mod_perl</application> on your

<productname>Apache</productname> web server, you can use

<literal>AuthType KerberosV5SaveCredentials</literal> with a

default PAM service name is <literal>postgresql</literal>. You can

optionally supply your own service name after the <literal>pam</>

key word in the file <filename>pg_hba.conf</filename>.

For more information about PAM, please read the <ulink

url="http://www.kernel.org/pub/linux/libs/pam/"><productname>Linux-PAM</>

Page</ulink> and the <ulink

url="http://www.sun.com/software/solaris/pam/"><systemitem

class="osname">Solaris</> PAM Page</ulink>.

For more information about PAM, please read the <productname>Linux-PAM</>

Page, <ulink url="http://www.kernel.org/pub/linux/libs/pam/"></ulink>,

and the <systemitem class="osname">Solaris</> PAM Page, <ulink

url="http://www.sun.com/software/solaris/pam/"></ulink>.

</para>

</sect2>

</sect1>

<para>

Refer to the introduction in this manual or to the

<ulink url="http://www.postgresql.org"><productname>PostgreSQL</productname> web page</ulink>

for subscription information to the no-cost mailing lists.

<productname>PostgreSQL</productname> web page,

<ulink url="http://www.postgresql.org"></ulink>,

for subscription information to the no-cost mailing lists.

</para>

<sect1 id="people">

<title>People</title>

-->

<para>

<itemizedlist mark="bullet" spacing="compact">

<listitem>

<para>

<ulink url="lockhart@fourpalms.org">Thomas Lockhart</ulink>

works on SQL standards compliance and documentation.

</para>

</listitem>

</itemizedlist>

</para>

</appendix>

<!--

$PostgreSQL: pgsql/doc/src/sgml/cvs.sgml,v 1.31 2005/01/22 22:06:17 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/cvs.sgml,v 1.32 2005/03/31 03:54:37 momjian Exp $

-->

<appendix id="cvs">

<para>

You will need a local copy of <productname>CVS</productname>

(Concurrent Version Control System), which you can get from

<ulink url="http://www.cvshome.org/">http://www.cvshome.org/</ulink>

<ulink url="http://www.cvshome.org/"></ulink>

(the official site with the latest version) or any GNU software

archive site (often somewhat outdated). We recommend version 1.10

or newer. Many systems have a recent version of

For more info consult the manual that comes with

<productname>CVS</productname>, or see the online

documentation at

<ulink url="http://www.cvshome.org/">http://www.cvshome.org/</ulink>.

<ulink url="http://www.cvshome.org/"></ulink>.

</para>

</sect1>

<productname>CVSup</productname> was developed by

John Polstra (<email>jdp@polstra.com</email>) to

distribute CVS repositories and other file trees for

<ulink url="http://www.freebsd.org">the FreeBSD project</ulink>.

the FreeBSD project,<ulink url="http://www.freebsd.org"></ulink>.

</para>

<para>

<para>

The following is a suggested <productname>CVSup</productname> config file from

<ulink url="ftp://ftp.postgresql.org/pub/CVSup/README.cvsup">the <productname>PostgreSQL</> ftp site</ulink>

the <productname>PostgreSQL</> ftp site,

<ulink url="ftp://ftp.postgresql.org/pub/CVSup/README.cvsup"></ulink>,

which will fetch the current snapshot only:

<programlisting>

You can use pre-built binaries

if you have a platform for which binaries

are posted on

<ulink url="ftp://ftp.postgresql.org/pub">the <productname>PostgreSQL</productname> ftp site</ulink>,

the <productname>PostgreSQL</productname> ftp site,

<ulink url="ftp://ftp.postgresql.org/pub"></ulink>,

or if you are running FreeBSD, for which

<productname>CVSup</productname> is available as a port.

<step performance="optional">

<para>

If you have another platform, check for and download the appropriate binary from

<ulink url="ftp://ftp.postgresql.org/pub">the <productname>PostgreSQL</productname> ftp site</ulink>.

the <productname>PostgreSQL</productname> ftp site,

<ulink url="ftp://ftp.postgresql.org/pub"></ulink>.

</para>

</step>

</substeps>

<step>

<para>

Pick up the <productname>Modula-3</productname>

distribution from

<ulink url="http://m3.polymtl.ca/m3">Polytechnique Montr�al</ulink>,

distribution from Polytechnique Montr�al,

<ulink url="http://m3.polymtl.ca/m3"></ulink>,

who are actively maintaining the code base originally developed by

<ulink

url="http://www.research.digital.com/SRC/modula-3/html/home.html">the DEC Systems Research Center</ulink>.

The <productname>PM3</productname> <productname>RPM</productname> distribution is roughly

the DEC Systems Research Center,<ulink

url="http://www.research.digital.com/SRC/modula-3/html/home.html"></ulink>.

The <productname>PM3</productname> <productname>RPM</productname> distribution is roughly

30MB compressed. At the time of writing, the 1.1.10-1 release

installed cleanly on RH-5.2, whereas the 1.1.11-1 release is

apparently built for another release (RH-6.0?) and does not run on RH-5.2.

As shown, it will get the repository (RCS) files. If you uncomment

the line containing "tag=." then it will instead check out the

latest version of each file. There's a bunch more information about

what you can do in

<ulink url="http://www.freebsd.org/handbook/cvsup.html">the CVSup Handbook</ulink>.

what you can do in the CVSup Handbook,

<ulink url="http://www.freebsd.org/handbook/cvsup.html"></ulink>.

There is one other thing I want to send you, but not tonight. I

discovered the hard way that you need a malloc package that is

<!--

$PostgreSQL: pgsql/doc/src/sgml/dfunc.sgml,v 1.29 2005/01/22 22:56:35 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/dfunc.sgml,v 1.30 2005/03/31 03:54:37 momjian Exp $

-->

<sect2 id="dfunc">

<tip>

<para>

If this is too complicated for you, you should consider using

<ulink url="http://www.gnu.org/software/libtool/"><productname>GNU

Libtool</productname></ulink>, which hides the platform differences

<productname>GNU Libtool</productname>,

<ulink url="http://www.gnu.org/software/libtool/"></ulink>,

which hides the platform differences

behind a uniform interface.

</para>

</tip>