Changeset 4472e923 for server/databases
- Timestamp:
- 03/07/2020 09:40:50 AM (4 years ago)
- Branches:
- 10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, lazarus, lxqt, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
- Children:
- 99c61a4
- Parents:
- 21a08bf
- Location:
- server/databases
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
server/databases/lmdb.xml
r21a08bf r4472e923 82 82 <title>Installation of lmdb</title> 83 83 84 <note><para>This package extracts to lmdb-LMDB_&lmdb-version;.</para></note> 84 <note> 85 <para> 86 This package extracts to lmdb-LMDB_&lmdb-version;. 87 </para> 88 </note> 85 89 86 90 <para> -
server/databases/mariadb.xml
r21a08bf r4472e923 73 73 </itemizedlist> 74 74 75 <note><para>The installed size of MariaDB is 473 MB, but this can be 76 reduced by about 200 MB, if desired, by removing the /usr/share/mysql/test 77 directory after installation.</para></note> 75 <note> 76 <para> 77 The installed size of MariaDB is 473 MB, but this can be 78 reduced by about 200 MB, if desired, by removing the <filename 79 class="directory">/usr/share/mysql/test</filename> 80 directory after installation. 81 </para> 82 </note> 78 83 79 84 <bridgehead renderas="sect3">MariaDB Dependencies</bridgehead> -
server/databases/postgresql.xml
r21a08bf r4472e923 31 31 <title>Introduction to PostgreSQL</title> 32 32 33 <para><application>PostgreSQL</application> is an advanced 34 object-relational database management system (ORDBMS), derived 35 from the Berkeley Postgres database management system.</para> 33 <para> 34 <application>PostgreSQL</application> is an advanced 35 object-relational database management system (ORDBMS), derived 36 from the Berkeley Postgres database management system. 37 </para> 36 38 37 39 &lfs91_checked; … … 40 42 <itemizedlist spacing="compact"> 41 43 <listitem> 42 <para>Download (HTTP): <ulink url="&postgresql-download-http;"/></para> 44 <para> 45 Download (HTTP): <ulink url="&postgresql-download-http;"/> 46 </para> 43 47 </listitem> 44 48 <listitem> 45 <para>Download (FTP): <ulink url="&postgresql-download-ftp;"/></para> 49 <para> 50 Download (FTP): <ulink url="&postgresql-download-ftp;"/> 51 </para> 46 52 </listitem> 47 53 <listitem> 48 <para>Download MD5 sum: &postgresql-md5sum;</para> 54 <para> 55 Download MD5 sum: &postgresql-md5sum; 56 </para> 49 57 </listitem> 50 58 <listitem> 51 <para>Download size: &postgresql-size;</para> 59 <para> 60 Download size: &postgresql-size; 61 </para> 52 62 </listitem> 53 63 <listitem> 54 <para>Estimated disk space required: &postgresql-buildsize;</para> 64 <para> 65 Estimated disk space required: &postgresql-buildsize; 66 </para> 55 67 </listitem> 56 68 <listitem> 57 <para>Estimated build time: &postgresql-time;</para> 69 <para> 70 Estimated build time: &postgresql-time; 71 </para> 58 72 </listitem> 59 73 </itemizedlist> … … 101 115 -u 41 postgres</userinput></screen> 102 116 103 <note><para>There are several configuration items that add additional 104 functionality with optional packages to 105 <application>PostgreSQL</application>. Use <userinput>./configure 106 --help</userinput> to see a list.</para></note> 107 108 <para>Install <application>PostgreSQL</application> with the 109 following commands: </para> 117 <note> 118 <para> 119 There are several configuration items that add additional 120 functionality with optional packages to 121 <application>PostgreSQL</application>. Use <command>./configure 122 --help</command> to see a list. 123 </para> 124 </note> 125 126 <para> 127 Install <application>PostgreSQL</application> with the 128 following commands: 129 </para> 110 130 111 131 <screen><userinput>sed -i '/DEFAULT_PGSOCKET_DIR/s@/tmp@/run/postgresql@' src/include/pg_config_manual.h && … … 116 136 make</userinput></screen> 117 137 118 <para>There are a number of programs in the 119 <filename class="directory">contrib/</filename> directory. If you are going 120 to run this installation as a server and wish to build some of them, enter 121 <command>make -C contrib</command> or 122 <command>make -C contrib/<replaceable><SUBDIR-NAME></replaceable></command> for each subdirectory. 123 </para> 124 125 <para>Tests must be run as an unprivileged user because they need to start a 126 temporary server and this is prevented as the root user. For the same reason, 127 you need to stop all PostgreSQL servers if any are running. If a previous 128 version of PostgreSQL is installed, it may be necessary to use 129 <command>--disable-rpath</command> with <command>configure</command> to 130 avoid failures, but <emphasis>installing the binaries created using this 131 switch is not recommended</emphasis>. To test the results, issue: 132 <command>make check</command>.</para> 133 134 <para>Now, as the <systemitem class="username">root</systemitem> user:</para> 138 <para> 139 There are a number of programs in the 140 <filename class="directory">contrib/</filename> directory. If you are 141 going to run this installation as a server and wish to build some of 142 them, enter <command>make -C contrib</command> or <command>make -C 143 contrib/<replaceable><SUBDIR-NAME></replaceable></command> for 144 each subdirectory. 145 </para> 146 147 <para> 148 Tests must be run as an unprivileged user because they need to start a 149 temporary server and this is prevented as the root user. For the same 150 reason, you need to stop all PostgreSQL servers if any are running. If a 151 previous version of PostgreSQL is installed, it may be necessary to use 152 <command>--disable-rpath</command> with <command>configure</command> to 153 avoid failures, but <emphasis>installing the binaries created using this 154 switch is not recommended</emphasis>. To test the results, issue: 155 <command>make check</command>. 156 </para> 157 158 <para> 159 Now, as the <systemitem class="username">root</systemitem> user: 160 </para> 135 161 136 162 <screen role="root"><userinput>make install && 137 163 make install-docs</userinput></screen> 138 164 139 <para>If you made any of the <filename class="directory">contrib/</filename> 140 programs, as the <systemitem class="username">root</systemitem> user:</para> 165 <para> 166 If you made any of the <filename class="directory">contrib/</filename> 167 programs, as the <systemitem class="username">root</systemitem> user: 168 </para> 141 169 142 170 <screen role="nodump"><userinput>make -C contrib/<replaceable><SUBDIR-NAME></replaceable> install</userinput></screen> 143 171 144 <para><emphasis>If you only intend to use 145 <application>PostgreSQL</application> as a client to connect to a server on 146 another machine, your installation is complete and you should not run the 147 remaining commands.</emphasis></para> 148 149 <!-- 'Upgrading' seems to only ever exist in the docs for *previous* version --> 150 <!-- Obsolete: only if upgrading for versions prior to 9 <note> 151 <para>If you are upgrading an existing system and are going to install 152 the new files over the old ones, then you should back up your data, shut 153 down the old server and follow the instructions in <ulink 154 url="http://www.postgresql.org/docs/9.0/static/install-upgrading.html">the 155 official <application>PostgreSQL</application> documentation</ulink>.</para> 156 </note>--> 157 158 <para>Initialize a database cluster with the following commands issued by the 159 <systemitem class="username">root</systemitem> user:</para> 172 <tip> 173 <para> 174 If you only intend to use <application>PostgreSQL</application> as a 175 client to connect to a server on another machine, your installation is 176 complete and you should not run the remaining commands. 177 </para> 178 </tip> 179 180 <para> 181 Initialize a database cluster with the following commands issued by the 182 <systemitem class="username">root</systemitem> user: 183 </para> 160 184 161 185 <screen role="root"><userinput>install -v -dm700 /srv/pgsql/data && … … 163 187 chown -Rv postgres:postgres /srv/pgsql /run/postgresql</userinput></screen> 164 188 165 <para>Now, initialize the database as the <systemitem 166 class="username">root</systemitem> user:</para> 189 <para> 190 Now, initialize the database as the <systemitem 191 class="username">root</systemitem> user: 192 </para> 167 193 168 194 <screen role="root"><userinput>su - postgres -c '/usr/bin/initdb -D /srv/pgsql/data'</userinput></screen> … … 181 207 </para> 182 208 183 <para><parameter>--docdir=/usr/share/doc/postgresql-&postgresql-version;</parameter>: 184 This switch puts the documentation in a versioned directory.</para> 185 186 <para><parameter>--enable-thread-safety</parameter>: This switch makes the 187 client libraries thread-safe by allowing concurrent threads in 188 <filename class="libraryfile">libpq</filename> and ECPG programs to safely 189 control their private connection handles.</para> 190 191 <para><option>--with-openssl</option>: builds the package with support for 192 <application>OpenSSL</application> encrypted connections.</para> 193 194 <para><option>--with-perl</option>: builds the PL/Perl server-side language. 195 </para> 196 197 <para><option>--with-python</option>: builds the PL/Python server-side 198 language. Add PYTHON=/usr/bin/python2 for Python2 support, otherwise 199 Python3 is used by default.</para> 200 201 <para><option>--with-tcl</option>: builds the PL/Tcl server-side language.</para> 209 <para> 210 <parameter>--enable-thread-safety</parameter>: This switch makes the 211 client libraries thread-safe by allowing concurrent threads in 212 <filename class="libraryfile">libpq</filename> and ECPG programs to 213 safely control their private connection handles. 214 </para> 215 216 <para> 217 <option>--with-openssl</option>: builds the package with support for 218 <application>OpenSSL</application> encrypted connections. 219 </para> 220 221 <para> 222 <option>--with-perl</option>: builds the PL/Perl server-side language. 223 </para> 224 225 <para> 226 <option>--with-python</option>: builds the PL/Python server-side 227 language. Add PYTHON=/usr/bin/python2 for Python2 support, otherwise 228 Python3 is used by default. 229 </para> 230 231 <para> 232 <option>--with-tcl</option>: builds the PL/Tcl server-side language. 233 </para> 202 234 203 235 </sect2> … … 209 241 <title>Config Files</title> 210 242 211 <para><filename>$PGDATA/pg_ident.con</filename>, 212 <filename>$PGDATA/pg_hba.conf</filename> and 213 <filename>$PGDATA/postgresql.conf</filename></para> 243 <para> 244 <filename>$PGDATA/pg_ident.con</filename>, 245 <filename>$PGDATA/pg_hba.conf</filename>, and 246 <filename>$PGDATA/postgresql.conf</filename> 247 </para> 214 248 215 249 <indexterm zone="postgresql postgresql-config"> … … 225 259 </indexterm> 226 260 227 <para>The <envar>PGDATA</envar> environment variable is used to 228 distinguish database clusters from one another by setting it to 229 the value of the directory which contains the cluster desired. 230 The three configuration files exist in every <filename 231 class="directory">PGDATA/</filename> directory. Details on the 232 format of the files and the options that can be set in each can 233 be found in <ulink 234 url="file:///usr/share/doc/postgresql-&postgresql-version;/html/index.html"/>.</para> 261 <para> 262 The <envar>PGDATA</envar> environment variable is used to 263 distinguish database clusters from one another by setting it to 264 the value of the directory which contains the cluster desired. 265 The three configuration files exist in every <filename 266 class="directory">PGDATA/</filename> directory. Details on the 267 format of the files and the options that can be set in each can 268 be found in <filename> 269 /usr/share/doc/postgresql-&postgresql-version;/html/index.html</filename>. 270 </para> 235 271 236 272 </sect3> … … 240 276 <phrase revision="systemd">Systemd Unit</phrase></title> 241 277 242 <para>Install the 243 <phrase revision="sysv"><filename>/etc/rc.d/init.d/postgresql</filename> 244 init script</phrase> 245 <phrase revision="systemd"><filename>postgresql.service</filename> 246 unit</phrase> included in the 247 <xref linkend="bootscripts" revision="sysv"/> 248 <xref linkend="systemd-units" revision="systemd"/> package.</para> 278 <para> 279 Install the 280 <phrase revision="sysv"><filename>/etc/rc.d/init.d/postgresql</filename> 281 init script</phrase> 282 <phrase revision="systemd"><filename>postgresql.service</filename> 283 unit</phrase> included in the 284 <xref linkend="bootscripts" revision="sysv"/> 285 <xref linkend="systemd-units" revision="systemd"/> package: 286 </para> 249 287 250 288 <indexterm zone="postgresql postgresql-init"> … … 293 331 294 332 <para> 295 When you are done with testing, you can shut down the server, by issuing296 as <systemitem class="username">root</systemitem>:333 When you are done with testing, you can shut down the server, by 334 issuing as <systemitem class="username">root</systemitem>: 297 335 </para> 298 336 … … 346 384 <term><command>clusterdb</command></term> 347 385 <listitem> 348 <para>is a utility for reclustering tables in a 349 <application>PostgreSQL</application> database.</para> 386 <para> 387 is a utility for reclustering tables in a 388 <application>PostgreSQL</application> database. 389 </para> 350 390 <indexterm zone="postgresql clusterdb"> 351 391 <primary sortas="b-clusterdb">clusterdb</primary> … … 357 397 <term><command>createdb</command></term> 358 398 <listitem> 359 <para> creates a new <application>PostgreSQL</application> 360 database.</para> 399 <para> 400 creates a new <application>PostgreSQL</application> 401 database. 402 </para> 361 403 <indexterm zone="postgresql createdb"> 362 404 <primary sortas="b-createdb">createdb</primary> … … 365 407 </varlistentry> 366 408 367 <!-- <varlistentry id="createlang">368 <term><command>createlang</command></term>369 <listitem>370 <para>defines a new <application>PostgreSQL</application> procedural371 language.</para>372 <indexterm zone="postgresql createlang">373 <primary sortas="b-createlang">createlang</primary>374 </indexterm>375 </listitem>376 </varlistentry>-->377 378 409 <varlistentry id="createuser"> 379 410 <term><command>createuser</command></term> 380 411 <listitem> 381 <para>defines a new <application>PostgreSQL</application> 382 user account.</para> 412 <para> 413 defines a new <application>PostgreSQL</application> 414 user account. 415 </para> 383 416 <indexterm zone="postgresql createuser"> 384 417 <primary sortas="b-createuser">createuser</primary> … … 390 423 <term><command>dropdb</command></term> 391 424 <listitem> 392 <para>removes a <application>PostgreSQL</application> database.</para> 425 <para> 426 removes a <application>PostgreSQL</application> database. 427 </para> 393 428 <indexterm zone="postgresql dropdb"> 394 429 <primary sortas="b-dropdb">dropdb</primary> … … 397 432 </varlistentry> 398 433 399 <!-- <varlistentry id="droplang">400 <term><command>droplang</command></term>401 <listitem>402 <para>removes a <application>PostgreSQL</application> procedural403 language.</para>404 <indexterm zone="postgresql droplang">405 <primary sortas="b-droplang">droplang</primary>406 </indexterm>407 </listitem>408 </varlistentry> -->409 410 434 <varlistentry id="dropuser"> 411 435 <term><command>dropuser</command></term> 412 436 <listitem> 413 <para>removes a <application>PostgreSQL</application> 414 user account.</para> 437 <para> 438 removes a <application>PostgreSQL</application> user account. 439 </para> 415 440 <indexterm zone="postgresql dropuser"> 416 441 <primary sortas="b-dropuser">dropuser</primary> … … 422 447 <term><command>ecpg</command></term> 423 448 <listitem> 424 <para>is the embedded SQL preprocessor.</para> 449 <para> 450 is the embedded SQL preprocessor. 451 </para> 425 452 <indexterm zone="postgresql ecpg"> 426 453 <primary sortas="b-ecpg">ecpg</primary> … … 432 459 <term><command>initdb</command></term> 433 460 <listitem> 434 <para>creates a new database cluster.</para> 461 <para> 462 creates a new database cluster. 463 </para> 435 464 <indexterm zone="postgresql initdb"> 436 465 <primary sortas="b-initdb">initdb</primary> … … 442 471 <term><command>oid2name</command></term> 443 472 <listitem> 444 <para>resolves OIDs (Object IDs) and file nodes in a PostgreSQL data 445 directory.</para> 473 <para> 474 resolves OIDs (Object IDs) and file nodes in a PostgreSQL data 475 directory. 476 </para> 446 477 <indexterm zone="postgresql oid2name"> 447 478 <primary sortas="b-oid2name">oid2name</primary> … … 453 484 <term><command>pg_archivecleanup</command></term> 454 485 <listitem> 455 <para>cleans up PostgreSQL WAL (write-ahead log) archive files.</para> 486 <para> 487 cleans up PostgreSQL WAL (write-ahead log) archive files. 488 </para> 456 489 <indexterm zone="postgresql pg_archivecleanup"> 457 490 <primary sortas="b-pg_archivecleanup">pg_archivecleanup</primary> … … 463 496 <term><command>pg_basebackup</command></term> 464 497 <listitem> 465 <para>takes base backups of a running 466 <application>PostgreSQL</application> cluster.</para> 498 <para> 499 takes base backups of a running 500 <application>PostgreSQL</application> cluster. 501 </para> 467 502 <indexterm zone="postgresql pg_basebackup"> 468 503 <primary sortas="b-pg_basebackup">pg_basebackup</primary> … … 474 509 <term><command>pg_config</command></term> 475 510 <listitem> 476 <para>retrieves <application>PostgreSQL</application> version 477 information.</para> 511 <para> 512 retrieves <application>PostgreSQL</application> version 513 information. 514 </para> 478 515 <indexterm zone="postgresql pg_config"> 479 516 <primary sortas="b-pg_config">pg_config</primary> … … 485 522 <term><command>pg_controldata</command></term> 486 523 <listitem> 487 <para>returns information initialized during 488 <command>initdb</command>, such as the catalog version and server 489 locale.</para> 524 <para> 525 returns information initialized during <command>initdb</command>, 526 such as the catalog version and server locale. 527 </para> 490 528 <indexterm zone="postgresql pg_controldata"> 491 529 <primary sortas="b-pg_controldata">pg_controldata</primary> … … 497 535 <term><command>pg_ctl</command></term> 498 536 <listitem> 499 <para>controls stopping and starting the database server.</para> 537 <para> 538 controls stopping and starting the database server. 539 </para> 500 540 <indexterm zone="postgresql pg_ctl"> 501 541 <primary sortas="b-pg_ctl">pg_ctl</primary> … … 507 547 <term><command>pg_dump</command></term> 508 548 <listitem> 509 <para>dumps database data and metadata into scripts which are used 510 to recreate the database.</para> 549 <para> 550 dumps database data and metadata into scripts which are used 551 to recreate the database. 552 </para> 511 553 <indexterm zone="postgresql pg_dump"> 512 554 <primary sortas="b-pg_dump">pg_dump</primary> … … 518 560 <term><command>pg_dumpall</command></term> 519 561 <listitem> 520 <para>recursively calls <command>pg_dump</command> for each 521 database in a cluster.</para> 562 <para> 563 recursively calls <command>pg_dump</command> for each 564 database in a cluster. 565 </para> 522 566 <indexterm zone="postgresql pg_dumpall"> 523 567 <primary sortas="b-pg_dumpall">pg_dumpall</primary> … … 529 573 <term><command>pg_isready</command></term> 530 574 <listitem> 531 <para>check the connection status of a PostgreSQL server.</para> 575 <para> 576 checks the connection status of a PostgreSQL server. 577 </para> 532 578 <indexterm zone="postgresql pg_isready"> 533 579 <primary sortas="b-pg_isready">pg_isready</primary> … … 551 597 <term><command>pg_recvlogical</command></term> 552 598 <listitem> 553 <para>controls PostgreSQL logical decoding streams.</para> 599 <para> 600 controls PostgreSQL logical decoding streams. 601 </para> 554 602 <indexterm zone="postgresql pg_recvlogical"> 555 603 <primary sortas="b-pg_recvlogical">pg_recvlogical</primary> … … 561 609 <term><command>pg_resetwal</command></term> 562 610 <listitem> 563 <para>resets the write-ahead log and other control information 564 of a PostgreSQL database cluseter.</para> 611 <para> 612 resets the write-ahead log and other control information 613 of a PostgreSQL database cluster. 614 </para> 565 615 <indexterm zone="postgresql pg_resetwal"> 566 616 <primary sortas="b-pg_resetwal">pg_resetwal</primary> … … 572 622 <term><command>pg_restore</command></term> 573 623 <listitem> 574 <para>creates databases from dump files created by 575 <command>pg_dump</command>.</para> 624 <para> 625 creates databases from dump files created by 626 <command>pg_dump</command>. 627 </para> 576 628 <indexterm zone="postgresql pg_restore"> 577 629 <primary sortas="b-pg_restore">pg_restore</primary> … … 583 635 <term><command>pg_rewind</command></term> 584 636 <listitem> 585 <para>synchronizes a PostgreSQL data directory with another data 586 directory that was forked from the first one.</para> 637 <para> 638 synchronizes a PostgreSQL data directory with another data 639 directory that was forked from the first one. 640 </para> 587 641 <indexterm zone="postgresql pg_rewind"> 588 642 <primary sortas="b-pg_rewind">pg_rewind</primary> … … 594 648 <term><command>pg_standby</command></term> 595 649 <listitem> 596 <para>supports the creation of a PostgreSQL warm standby 597 server.</para> 650 <para> 651 supports the creation of a PostgreSQL warm standby server. 652 </para> 598 653 <indexterm zone="postgresql pg_standby"> 599 654 <primary sortas="b-pg_standby">pg_standby</primary> … … 605 660 <term><command>pg_test_fsync</command></term> 606 661 <listitem> 607 <para>determine fastest wal_sync method for PostgreSQL.</para> 662 <para> 663 determines fastest wal_sync method for PostgreSQL. 664 </para> 608 665 <indexterm zone="postgresql pg_test_fsync"> 609 666 <primary sortas="b-pg_test_fsync">pg_test_fsync</primary> … … 615 672 <term><command>pg_test_timing</command></term> 616 673 <listitem> 617 <para>measure timing overhead.</para> 674 <para> 675 measures timing overhead. 676 </para> 618 677 <indexterm zone="postgresql pg_test_timing"> 619 678 <primary sortas="b-pg_test_timing">pg_test_timing</primary> … … 625 684 <term><command>pg_upgrade</command></term> 626 685 <listitem> 627 <para>upgrade a PostgreSQL server instance.</para> 686 <para> 687 upgrades a PostgreSQL server instance. 688 </para> 628 689 <indexterm zone="postgresql pg_upgrade"> 629 690 <primary sortas="b-pg_upgrade">pg_upgrade</primary> … … 635 696 <term><command>pg_waldump</command></term> 636 697 <listitem> 637 <para>display a human-readable rendering of the write-ahead log of a 638 PostgreSQL database cluster.</para> 698 <para> 699 displays a human-readable rendering of the write-ahead log of a 700 PostgreSQL database cluster. 701 </para> 639 702 <indexterm zone="postgresql pg_waldump"> 640 703 <primary sortas="b-pg_waldump">pg_waldump</primary> … … 646 709 <term><command>pgbench</command></term> 647 710 <listitem> 648 <para>run a benchmark test on PostgreSQL.</para> 711 <para> 712 runs a benchmark test on PostgreSQL. 713 </para> 649 714 <indexterm zone="postgresql pgbench"> 650 715 <primary sortas="b-pgbench">pgbench</primary> … … 656 721 <term><command>pltcl_delmod</command></term> 657 722 <listitem> 658 <para>is a support script used to delete a module from a 659 PL/<application>Tcl</application> table. The command 660 requires the <ulink 661 url="http://flightaware.github.io/Pgtcl/">Pgtcl</ulink> 662 package to be installed also.</para> 723 <para> 724 is a support script used to delete a module from a 725 PL/<application>Tcl</application> table. The command 726 requires the <ulink 727 url="http://flightaware.github.io/Pgtcl/">Pgtcl</ulink> 728 package to be installed also. 729 </para> 663 730 <indexterm zone="postgresql pltcl_delmod"> 664 731 <primary sortas="b-pltcl_delmod">pltcl_delmod</primary> … … 670 737 <term><command>pltcl_listmod</command></term> 671 738 <listitem> 672 <para>is a support script used to list the modules in a 673 PL/<application>Tcl</application> table. The command 674 requires the <ulink 675 url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink> 676 package to be installed also.</para> 739 <para> 740 is a support script used to list the modules in a 741 PL/<application>Tcl</application> table. The command 742 requires the <ulink 743 url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink> 744 package to be installed also. 745 </para> 677 746 <indexterm zone="postgresql pltcl_listmod"> 678 747 <primary sortas="b-pltcl_listmod">pltcl_listmod</primary> … … 684 753 <term><command>pltcl_loadmod</command></term> 685 754 <listitem> 686 <para>is a support script used to load a module into a 687 PL/<application>Tcl</application> table. The command 688 requires the <ulink 689 url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink> 690 package to be installed also.</para> 755 <para> 756 is a support script used to load a module into a 757 PL/<application>Tcl</application> table. The command 758 requires the <ulink 759 url="http://gborg.postgresql.org/project/pgtcl/">Pgtcl</ulink> 760 package to be installed also. 761 </para> 691 762 <indexterm zone="postgresql pltcl_loadmod"> 692 763 <primary sortas="b-pltcl_loadmod">pltcl_loadmod</primary> … … 698 769 <term><command>postgres</command></term> 699 770 <listitem> 700 <para>is the PostgreSQL database server.</para> 771 <para> 772 is the PostgreSQL database server. 773 </para> 701 774 <indexterm zone="postgresql postgres"> 702 775 <primary sortas="b-postgres">postgres</primary> … … 708 781 <term><command>postmaster</command></term> 709 782 <listitem> 710 <para>(deprecated, a symlink to <command>postgres</command>) is a 711 multi-user database daemon.</para> 783 <para> 784 (deprecated, a symlink to <command>postgres</command>) is a 785 multi-user database daemon. 786 </para> 712 787 <indexterm zone="postgresql postmaster"> 713 788 <primary sortas="b-postmaster">postmaster</primary> … … 719 794 <term><command>psql</command></term> 720 795 <listitem> 721 <para>is a console based database shell.</para> 796 <para> 797 is a console based database shell. 798 </para> 722 799 <indexterm zone="postgresql psql"> 723 800 <primary sortas="b-psql">psql</primary> … … 729 806 <term><command>reindexdb</command></term> 730 807 <listitem> 731 <para>is a utility for rebuilding indexes in a database.</para> 808 <para> 809 is a utility for rebuilding indexes in a database. 810 </para> 732 811 <indexterm zone="postgresql reindexdb"> 733 812 <primary sortas="b-reindexdb">reindexdb</primary> … … 739 818 <term><command>vacuumdb</command></term> 740 819 <listitem> 741 <para>compacts databases and generates statistics for the query 742 analyzer.</para> 820 <para> 821 compacts databases and generates statistics for the query analyzer. 822 </para> 743 823 <indexterm zone="postgresql vacuumdb"> 744 824 <primary sortas="b-vacuumdb">vacuumdb</primary> … … 750 830 <term><command>vacuumlo</command></term> 751 831 <listitem> 752 <para>remove orphaned large objects from a PostgreSQL database.</para> 832 <para> 833 removes orphaned large objects from a PostgreSQL database. 834 </para> 753 835 <indexterm zone="postgresql vacuumlo"> 754 836 <primary sortas="b-vacuumlo">vacuumlo</primary> … … 760 842 <term><filename class='libraryfile'>libecpg.{so,a}</filename></term> 761 843 <listitem> 762 <para>contains functions to support embedded SQL in C programs.</para> 844 <para> 845 contains functions to support embedded SQL in C programs. 846 </para> 763 847 <indexterm zone="postgresql libecpg"> 764 848 <primary sortas="c-libecpg">libecpg.{so,a}</primary> … … 770 854 <term><filename class='libraryfile'>libecpg_compat.{so,a}</filename></term> 771 855 <listitem> 772 <para>is the ecpg compatibility library.</para> 856 <para> 857 is the ecpg compatibility library. 858 </para> 773 859 <indexterm zone="postgresql libecpg_compat"> 774 860 <primary sortas="c-libecpg_compat">libecpg_compat.{so,a}</primary> … … 780 866 <term><filename class='libraryfile'>libgport.a</filename></term> 781 867 <listitem> 782 <para>is the port-specific subsystem of the Postgres backend.</para> 868 <para> 869 is the port-specific subsystem of the Postgres backend. 870 </para> 783 871 <indexterm zone="postgresql libgport"> 784 872 <primary sortas="c-libgport">libgport.a</primary> … … 790 878 <term><filename class='libraryfile'>libpgtypes.{so,a}</filename></term> 791 879 <listitem> 792 <para>contains functions for dealing with Postgres data types.</para> 880 <para> 881 contains functions for dealing with Postgres data types. 882 </para> 793 883 <indexterm zone="postgresql libpgtypes"> 794 884 <primary sortas="c-libpgtypes">libpgtypes.{so,a}</primary> … … 800 890 <term><filename class='libraryfile'>libpq.{so,a}</filename></term> 801 891 <listitem> 802 <para>is the C programmer's API to Postgres.</para> 892 <para> 893 is the C programmer's API to Postgres. 894 </para> 803 895 <indexterm zone="postgresql libpq"> 804 896 <primary sortas="c-libpq">libpq.{so,a}</primary>
Note:
See TracChangeset
for help on using the changeset viewer.