installation.sgml

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

</screen>
     Then enter
<screen>
<userinput>psql testdb</>
</screen>
     to connect to that database. At the prompt you can enter SQL
     commands and start experimenting.
    </para>
   </step>
  </procedure>
 </sect1>

 <sect1 id="install-whatnow">
  <title>What Now?</title>

  <para>
   <itemizedlist>
    <listitem>
     <para>
      The <productname>PostgreSQL</> distribution contains a
      comprehensive documentation set, which you should read sometime.
      After installation, the documentation can be accessed by
      pointing your browser to
      <filename>/usr/local/pgsql/doc/html/index.html</>, unless you
      changed the installation directories.
     </para>

     <para>
      The first few chapters of the main documentation are the Tutorial,
      which should be your first reading if you are completely new to
      <acronym>SQL</> databases.  If you are familiar with database
      concepts then you want to proceed with part on server
      administration, which contains information about how to set up
      the database server, database users, and authentication.
     </para>
    </listitem>

    <listitem>
     <para>
      Usually, you will want to modify your computer so that it will
      automatically start the database server whenever it boots. Some
      suggestions for this are in the documentation.
     </para>
    </listitem>

    <listitem>
     <para>
      Run the regression tests against the installed server (using
      <command>gmake installcheck</command>). If you didn't run the
      tests before installation, you should definitely do it now. This
      is also explained in the documentation.
     </para>
    </listitem>

    <listitem>
     <para>
      By default, <productname>PostgreSQL</> is configured to run on
      minimal hardware.  This allows it to start up with almost any
      hardware configuration. The default configuration is, however,
      not designed for optimum performance. To achieve optimum
      performance, several server parameters must be adjusted, the two
      most common being <varname>shared_buffers</varname> and
      <varname>work_mem</varname>.
      Other parameters mentioned in the documentation also affect
      performance.
     </para>
    </listitem>
   </itemizedlist>
  </para>
 </sect1>
]]>


 <sect1 id="supported-platforms">
  <title>Supported Platforms</title>

  <para>
   <productname>PostgreSQL</> has been verified by the developer
   community to work on the platforms listed below. A supported
   platform generally means that <productname>PostgreSQL</> builds and
   installs according to these instructions and that the regression
   tests pass.  <quote>Build farm</quote> entries refer to active test
   machines in the <ulink url="http://www.pgbuildfarm.org/">
   PostgreSQL Build Farm</ulink>.
   Platform entries that show an older version of
   PostgreSQL are those that did not receive explicit testing at the
   time of release of version &majorversion; but that we still
   expect to work.
  </para>

  <note>
   <para>
    If you are having problems with the installation on a supported
    platform, please write to <email>[e-mail]</email>
    or <email>[e-mail]</email>, not to the people
    listed here.
   </para>
  </note>

    <informaltable>
     <tgroup cols="5">
      <thead>
       <row>
        <entry><acronym>OS</acronym></entry>
        <entry>Processor</entry>
        <entry>Version</entry>
        <entry>Reported</entry>
        <entry>Remarks</entry>
       </row>
      </thead>
      <tbody>
       <row>
        <entry><systemitem class="osname">AIX</></entry>
        <entry><systemitem>PowerPC</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm
         <systemitem class="systemname">kookaburra</systemitem> (5.2, cc 6.0); 
         <systemitem class="systemname">asp</systemitem> (5.2, gcc 3.3.2)</entry>
        <entry>see <filename>doc/FAQ_AIX</filename>,
         particularly if using AIX 5.3 ML3</entry>
       </row>
       <row>
        <entry><systemitem class="osname">AIX</></entry>
        <entry><systemitem>RS6000</></entry>
        <entry>8.0.0</entry>
        <entry>Hans-J&uuml;rgen Sch&ouml;nig (<email>[e-mail]</email>), 2004-12-06</entry>
        <entry>see <filename>doc/FAQ_AIX</filename></entry>
       </row>
       <row>
        <entry><systemitem class="osname">BSD/OS</></entry>
        <entry><systemitem>x86</></entry>
        <entry>8.1.0</entry>
        <entry>Bruce Momjian (<email>[e-mail]</email>), 2005-10-26</entry>
        <entry>4.3.1</entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>Alpha</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">hare</systemitem> (3.1, gcc 3.3.4)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>AMD64</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">panda</systemitem> (sid, gcc 3.3.5)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>ARM</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">penguin</systemitem> (3.1, gcc 3.3.4)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>Athlon XP</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">rook</systemitem> (3.1, gcc 3.3.5)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>IA64</></entry>
        <entry>7.4</entry>
        <entry>No&egrave;l K&ouml;the (<email>[e-mail]</email>), 2003-10-25</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>m68k</></entry>
        <entry>8.0.0</entry>
        <entry>No&egrave;l K&ouml;the (<email>[e-mail]</email>), 2004-12-09</entry>
        <entry>sid</entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>MIPS</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm
         <systemitem class="systemname">otter</systemitem> (3.1, gcc 3.3.4)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>MIPSEL</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm
         <systemitem class="systemname">lionfish</systemitem> (3.1, gcc 3.3.4);
         <systemitem class="systemname">corgi</systemitem> (3.1, gcc 3.3.4)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>PA-RISC</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem
         class="systemname">kingfisher</systemitem> (3.1, gcc 3.3.5)</entry>
        <entry></entry>
     </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>PowerPC</></entry>
        <entry>8.0.0</entry>
        <entry>No&egrave;l K&ouml;the (<email>[e-mail]</email>), 2004-12-15</entry>
        <entry>sid</entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>S/390</></entry>
        <entry>7.4</entry>
        <entry>No&egrave;l K&ouml;the (<email>[e-mail]</email>), 2003-10-25</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>Sparc</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">dormouse</systemitem>
         (3.1, gcc 3.2.5; 64-bit)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Debian GNU/Linux</></entry>
        <entry><systemitem>x86</></entry>
        <entry>8.0.0</entry>
        <entry>Peter Eisentraut (<email>[e-mail]</email>), 2004-12-06</entry>
        <entry>3.1 (sarge), kernel 2.6</entry>
       </row>
       <row>
        <entry><systemitem class="osname">Fedora</></entry>
        <entry><systemitem>AMD64</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">viper</systemitem> (FC3, gcc 3.4.2)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Fedora</></entry>
        <entry><systemitem>x86</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">thrush</systemitem> (FC1, gcc 3.3.2)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">FreeBSD</></entry>
        <entry><systemitem>Alpha</></entry>
        <entry>7.4</entry>
        <entry>Peter Eisentraut (<email>[e-mail]</email>), 2003-10-25</entry>
        <entry>4.8</entry>
       </row>
       <row>
        <entry><systemitem class="osname">FreeBSD</></entry>
        <entry><systemitem>AMD64</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm
         <systemitem class="systemname">platypus</systemitem> (5.2.1, gcc 3.3.3);
         <systemitem class="systemname">dove</systemitem> (5.4, gcc 3.4.2)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">FreeBSD</></entry>
        <entry><systemitem>x86</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm
         <systemitem class="systemname">octopus</systemitem> (4.11, gcc 2.95.4);
         <systemitem class="systemname">flatworm</systemitem> (5.3, gcc 3.4.2);
         <systemitem class="systemname">echidna</systemitem> (6, gcc 3.4.2);
         <systemitem class="systemname">herring</systemitem> (6, Intel cc 7.1)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Gentoo Linux</></entry>
        <entry><systemitem>AMD64</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">caribou</systemitem> (2.6.9, gcc 3.3.5)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Gentoo Linux</></entry>
        <entry><systemitem>IA64</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">stoat</systemitem> (2.6, gcc 3.3)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Gentoo Linux</></entry>
        <entry><systemitem>PowerPC 64</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">cobra</systemitem> (1.4.16, gcc 3.4.3)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Gentoo Linux</></entry>
        <entry><systemitem>x86</></entry>
        <entry>8.0.0</entry>
        <entry>Paul Bort (<email>[e-mail]</email>), 2004-12-07</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">HP-UX</></entry>
        <entry><systemitem>IA64</></entry>
        <entry>8.1.0</entry>
        <entry>Tom Lane (<email>[e-mail]</email>), 2005-10-15</entry>
        <entry>11.23, <command>gcc</> and <command>cc</>; see <filename>doc/FAQ_HPUX</filename></entry>
       </row>
       <row>
        <entry><systemitem class="osname">HP-UX</></entry>
        <entry><systemitem>PA-RISC</></entry>
        <entry>8.1.0</entry>
        <entry>Tom Lane (<email>[e-mail]</email>), 2005-10-15</entry>
        <entry>10.20 and 11.23, <command>gcc</> and <command>cc</>; see <filename>doc/FAQ_HPUX</filename></entry>
       </row>
       <row>
        <entry><systemitem class="osname">IRIX</></entry>
        <entry><systemitem>MIPS</></entry>
        <entry>8.1.0</entry>
        <entry>Kenneth Marshall (<email>[e-mail]</email>), 2005-11-04</entry>
        <entry>6.5, <command>cc</command> only</entry>
       </row>
       <row>
        <entry><systemitem class="osname">Mac OS X</></entry>
        <entry><systemitem>PowerPC</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm
         <systemitem class="systemname">tuna</systemitem> (10.4.2, gcc 4.0);
         <systemitem class="systemname">cuckoo</systemitem> (10.3.9, gcc 3.3);
         <systemitem class="systemname">wallaroo</systemitem> (10.3.8, gcc 3.3)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">Mandrake Linux</></entry>
        <entry><systemitem>x86</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">shrew</systemitem> (10.0, gcc 3.3.2)</entry>
        <entry></entry>
       </row>
       <row>
        <entry><systemitem class="osname">NetBSD</></entry>
        <entry><systemitem>arm32</></entry>
        <entry>7.4</entry>
        <entry>Patrick Welche (<email>[e-mail]</email>), 2003-11-12</entry>
        <entry>1.6ZE/acorn32</entry>
       </row>
       <row>
        <entry><systemitem class="osname">NetBSD</></entry>
        <entry><systemitem>m68k</></entry>
        <entry>8.1.0</entry>
        <entry>Build farm <systemitem class="systemname">osprey</systemitem> (2.0, gcc 3.3.3)</entry>
        <entry><