<!--

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

$PostgreSQL: pgsql/doc/src/sgml/advanced.sgml,v 1.49 2005/04/09 03:52:43 momjian Exp $

-->

<chapter id="tutorial-advanced">

</para>

<para>

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

PostgreSQLweb site,

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

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

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

for links to more resources.

</para>

</sect1>

</chapter>

<!--

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

$PostgreSQL: pgsql/doc/src/sgml/biblio.sgml,v 1.23 2005/04/09 03:52:43 momjian Exp $

-->

<bibliography id="biblio">

Some white papers and technical reports from the original

<productname>POSTGRES</productname> development team

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

Department web site,

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

</ulink>

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

web site</ulink>.

</para>

<bibliodiv>

</biblioentry>

<biblioentry id="FONG">

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

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

<author>

<firstname>Zelaine</firstname>

<surname>Fong</surname>

<biblioentry id="ROWE87">

<biblioset relation="article">

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

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

The <productname>POSTGRES</productname> data model

</ulink></title>

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

<authorgroup>

<author>

<biblioentry id="SESHADRI95">

<biblioset relation="article">

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

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

Generalized Partial Indexes

</ulink>

</title>

<titleabbrev>Seshardri, 1995</titleabbrev>

<authorgroup>

<biblioentry id="STON86">

<biblioset relation="article">

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

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

The design of <productname>POSTGRES</productname>

</ulink></title>

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

<authorgroup>

<author>

<biblioentry id="STON87b">

<biblioset relation="article">

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

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

<titleabbrev>Stonebraker, 1987</titleabbrev>

<authorgroup>

<author>

<biblioentry id="STON89">

<biblioset relation="article">

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

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

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

<authorgroup>

<author>

<biblioentry id="STON89b">

<biblioset relation="article">

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

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

The case for partial indexes

</ulink></title>

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

<authorgroup>

<author>

<biblioentry id="STON90a">

<biblioset relation="article">

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

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

The implementation of <productname>POSTGRES</productname>

</ulink></title>

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

<authorgroup>

<author>

<biblioentry id="STON90b">

<biblioset relation="article">

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

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

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

<authorgroup>

<author>

<!--

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

$PostgreSQL: pgsql/doc/src/sgml/client-auth.sgml,v 1.74 2005/04/09 03:52:43 momjian 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 Kerberos <acronym>FAQ</>,

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

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

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.

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

</para>

</para>

<para>

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

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

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

<application>mod_auth_kerb</application></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 <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>.

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

</para>

</sect2>

</sect1>

<para>

Refer to the introduction in this manual or to the

<productname>PostgreSQL</productname>web page,

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

<productname>PostgreSQL</productname>

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

for subscription information to the no-cost mailing lists.

</para>

<!--

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

$PostgreSQL: pgsql/doc/src/sgml/cvs.sgml,v 1.33 2005/04/09 03:52:43 momjian Exp $

-->

<appendix id="cvs">

is <productname>CVSup</productname>.

<productname>CVSup</productname> was developed by

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

distribute CVS repositories and other file trees for

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

distribute CVS repositories and other file trees for the

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

</para>

<para>

<para>

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

the <productname>PostgreSQL</> ftp site,

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

the <productname>PostgreSQL</>

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

ftp site</ulink>

which will fetch the current snapshot only:

<programlisting>

<para>

You can use pre-built binaries

if you have a platform for which binaries

are posted on

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

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

are posted on the <productname>PostgreSQL</productname>

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

ftp site</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

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

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

the <productname>PostgreSQL</productname>

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

ftp site</ulink>.

</para>

</step>

</substeps>

<step>

<para>

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

distribution fromPolytechnique Montr�al,

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

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

Polytechnique Montr�al</ulink>

who are actively maintaining the code base originally developed by

theDEC Systems Research Center,<ulink

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

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

DEC Systems Research Center</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

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 the CVSup Handbook,

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

what you can do in the

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

CVSup Handbook</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.30 2005/03/31 03:54:37 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/dfunc.sgml,v 1.31 2005/04/09 03:52:43 momjian Exp $

-->

<sect2 id="dfunc">

<tip>

<para>

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

<productname>GNU Libtool</productname>,

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

which hides the platform differences

behind a uniform interface.

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 behind a uniform interface.

</para>

</tip>