Home Explore Blog CI



postgresql

2nd chunk of `doc/src/sgml/postgres.sgml`
5795e859c2f5fd34d4323e1e7bf2fbb440a83465c9cb03ae0000000100000a00
 complete
    description of a particular command are encouraged to review
    the <xref linkend="reference"/>.
   </para>

   <para>
    Readers should know how to connect to a
    <productname>PostgreSQL</productname> database and issue
    <acronym>SQL</acronym> commands.  Readers that are unfamiliar with
    these issues are encouraged to read <xref linkend="tutorial"/>
    first.  <acronym>SQL</acronym> commands are typically entered
    using the <productname>PostgreSQL</productname> interactive terminal
    <application>psql</application>, but other programs that have
    similar functionality can be used as well.
   </para>
  </partintro>

  &syntax;
  &ddl;
  &dml;
  &queries;
  &datatype;
  &func;
  &typeconv;
  &indices;
  &textsearch;
  &mvcc;
  &perform;
  &parallel;

 </part>

 <part id="admin">
  <title>Server Administration</title>

  <partintro>
   <para>
    This part covers topics that are of interest to a
    <productname>PostgreSQL</productname> administrator.  This includes
    installation, configuration of the server, management of users
    and databases, and maintenance tasks. Anyone running
    <productname>PostgreSQL</productname> server, even for
    personal use, but especially in production, should be familiar
    with these topics.
   </para>

   <para>
    The information attempts to be in the order in which
    a new user should read it.  The chapters are self-contained and
    can be read individually as desired.  The information is presented
    in a narrative form in topical units.  Readers looking for a complete
    description of a command are encouraged to review the
    <xref linkend="reference"/>.
   </para>

   <para>
    The first few chapters are written so they can be understood
    without prerequisite knowledge, so new users who need to set
    up their own server can begin their exploration. The rest of this
    part is about tuning and management; that material
    assumes that the reader is familiar with the general use of
    the <productname>PostgreSQL</productname> database system.  Readers are
    encouraged review the <xref linkend="tutorial"/> and <xref
    linkend="sql"/> parts for additional information.
   </para>
  </partintro>

  &installbin;
  &installation;
  &runtime;
  &config;
  &client-auth;
  &user-manag;
  &manage-ag;
  &charset;
  &maintenance;
  &backup;
  &high-availability;
  &monitoring;
  &wal;
  &logical-replication;
  &jit;
  &regress;

 </part>

 <part id="client-interfaces">
  <title>Client Interfaces</title>

  <partintro>
   <para>
  

Title: PostgreSQL Server Administration and Client Interfaces
Summary
This section of the PostgreSQL documentation covers server administration topics for PostgreSQL administrators, including installation, configuration, user and database management, and maintenance. It's designed for anyone running a PostgreSQL server, especially in production environments. It also includes information on tuning and managing the system. Additionally, it introduces client interfaces for connecting to PostgreSQL databases from various programming languages and environments, detailing the available options and resources for developers to build applications that interact with PostgreSQL.