- Timestamp:
- 08/04/2004 05:51:45 AM (20 years ago)
- Branches:
- 10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 6.0, 6.1, 6.2, 6.2.0, 6.2.0-rc1, 6.2.0-rc2, 6.3, 6.3-rc1, 6.3-rc2, 6.3-rc3, 7.10, 7.4, 7.5, 7.6, 7.6-blfs, 7.6-systemd, 7.7, 7.8, 7.9, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, gnome, kde5-13430, kde5-14269, kde5-14686, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, krejzi/svn, lazarus, lxqt, nosym, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, systemd-11177, systemd-13485, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
- Children:
- 6da4d5a6
- Parents:
- 95c3dc2
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
content/databases/postgresql.xml
r95c3dc2 r78d0e3c 8 8 <!ENTITY postgresql-download-ftp "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> 9 9 <!ENTITY postgresql-size "9.7 MB"> 10 <!ENTITY postgresql-buildsize " 80MB">10 <!ENTITY postgresql-buildsize "197 MB"> 11 11 <!ENTITY postgresql-time "1.21 SBU"> 12 12 ]> … … 17 17 18 18 <sect2> 19 <title>Introduction to <application>Postgre<acronym>SQL</acronym></application></title> 20 21 <para><application>Postgre<acronym>SQL</acronym></application> is an advanced object-relational 22 database management system (<acronym>ORDBMS</acronym>), derived from the 23 Berkeley Postgres database management system.</para> 19 <title>Introduction to <application>Postgre<acronym>SQL</acronym></application> 20 </title> 21 22 <para><application>Postgre<acronym>SQL</acronym></application> is an advanced 23 object-relational database management system (<acronym>ORDBMS</acronym>), 24 derived from the Berkeley Postgres database management system.</para> 24 25 25 26 <sect3><title>Package information</title> … … 32 33 </sect3> 33 34 34 <sect3><title><application>Postgre<acronym>SQL</acronym></application> dependencies</title> 35 <sect3><title><application>Postgre<acronym>SQL</acronym></application> 36 dependencies</title> 35 37 <sect4><title>Optional</title> 36 38 <para> … … 40 42 <xref linkend="openssl"/>, 41 43 <xref linkend="Linux_PAM"/>, 44 <xref linkend="opensp"/>, 45 <xref linkend="openjade"/>, 46 <xref linkend="perl-modules"/>: SGMLSpm-&SGMLSpm-version;, 42 47 <ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink>, 43 48 <xref linkend="mitkrb"/> or <xref linkend="heimdal"/>, … … 50 55 51 56 <sect2> 52 <title>Installation of <application>Postgre<acronym>SQL</acronym></application></title> 53 54 <para>Install <application>Postgre<acronym>SQL</acronym></application> with the following commands: </para> 57 <title>Installation of <application>Postgre<acronym>SQL</acronym></application> 58 </title> 59 60 <para>Install <application>Postgre<acronym>SQL</acronym></application> with the 61 following commands: </para> 55 62 56 63 <screen><userinput><command>./configure --prefix=/usr && … … 105 112 <para><command>useradd -d /srv/pgsql/data postgres</command>: Add an unprivileged user to run the database server.</para> 106 113 107 <para><command>createdb test, create table t1 , insert into t1 values..., select *108 from t1</command>: Create a database, add a table to it, insert some rows into the table 109 and select them to verify that the installation is working114 <para><command>createdb test, create table t1 , insert into t1 values..., 115 select * from t1</command>: Create a database, add a table to it, insert some 116 rows into the table and select them to verify that the installation is working 110 117 properly.</para> 111 118 … … 113 120 114 121 <sect2> 115 <title>Configuring <application>Postgre<acronym>SQL</acronym></application></title> 122 <title>Configuring <application>Postgre<acronym>SQL</acronym></application> 123 </title> 116 124 117 125 <sect3> 118 126 <title>Config files</title> 119 127 120 <para><filename>$PGDATA/pg_ident.con</filename>, <filename>$PGDATA/pg_hba.conf</filename>, <filename>$PGDATA/postgresql.conf</filename></para> 121 122 <para>The <envar>PGDATA</envar> environment variable is used to distinguish database 123 clusters from one another by setting it to the value of the directory 128 <para><filename>$PGDATA/pg_ident.con</filename>, 129 <filename>$PGDATA/pg_hba.conf</filename> and 130 <filename>$PGDATA/postgresql.conf</filename></para> 131 132 <para>The <envar>PGDATA</envar> environment variable is used to distinguish 133 database clusters from one another by setting it to the value of the directory 124 134 which contains the cluster desired. The three configuration files 125 135 exist in every <filename class="directory">PGDATA/</filename> directory. … … 129 139 130 140 <para>Install the <filename>/etc/rc.d/init.d/postgresql</filename> 131 init script included in the <xref linkend="intro-important-bootscripts"/> package.</para> 132 141 init script included in the <xref linkend="intro-important-bootscripts"/> 142 package.</para> 143 133 144 <screen><userinput><command>make install-postgresql</command></userinput></screen> 134 145 … … 140 151 <title>Contents</title> 141 152 142 <para>The <application>Postgre<acronym>SQL</acronym></application> package contains143 <command>clusterdb</command>,153 <para>The <application>Postgre<acronym>SQL</acronym></application> package 154 contains <command>clusterdb</command>, 144 155 <command>createdb</command>, 145 156 <command>createlang</command>, … … 187 198 <sect3><title>createdb</title> 188 199 <para><command>createdb</command> creates a new 189 <application>Postgre<acronym>SQL</acronym></application> database.</para></sect3> 200 <application>Postgre<acronym>SQL</acronym></application> database.</para> 201 </sect3> 190 202 191 203 <sect3><title>createlang</title> … … 196 208 <sect3><title>createuser</title> 197 209 <para><command>createuser</command> defines a new 198 <application>Postgre<acronym>SQL</acronym></application> user account.</para></sect3> 210 <application>Postgre<acronym>SQL</acronym></application> user account.</para> 211 </sect3> 199 212 200 213 <sect3><title>dropdb</title> 201 214 <para><command>dropdb</command> removes a 202 <application>Postgre<acronym>SQL</acronym></application> database.</para></sect3> 215 <application>Postgre<acronym>SQL</acronym></application> database.</para> 216 </sect3> 203 217 204 218 <sect3><title>droplang</title> … … 209 223 <sect3><title>dropuser</title> 210 224 <para><command>dropuser</command> removes a 211 <application>Postgre<acronym>SQL</acronym></application> user account.</para></sect3> 225 <application>Postgre<acronym>SQL</acronym></application> user account.</para> 226 </sect3> 212 227 213 228 <sect3><title>ecpg</title> 214 <para><command>ecpg</command> is the embedded <acronym>SQL</acronym> preprocessor.</para></sect3> 229 <para><command>ecpg</command> is the embedded <acronym>SQL</acronym> 230 preprocessor.</para></sect3> 215 231 216 232 <sect3><title>initdb</title> … … 222 238 223 239 <sect3><title>ipcclean</title> 224 <para><command>ipcclean</command> removes shared memory and semaphores left over by an225 aborted database server.</para></sect3>240 <para><command>ipcclean</command> removes shared memory and semaphores left 241 over by an aborted database server.</para></sect3> 226 242 227 243 <sect3><title>pg_config</title> … … 240 256 241 257 <sect3><title>pg_dump</title> 242 <para><command>pg_dump</command> dumps database data and metadata into scripts which are243 used to recreate the database.</para></sect3>258 <para><command>pg_dump</command> dumps database data and metadata into scripts 259 which are used to recreate the database.</para></sect3> 244 260 245 261 <sect3><title>pg_dumpall</title> … … 249 265 250 266 <sect3><title>pg_resetxlog</title> 251 <para><command>pg_resetxlog</command> clears the write-ahead log and optionally resets some252 fields in the <filename>pg_control</filename> file.</para></sect3>267 <para><command>pg_resetxlog</command> clears the write-ahead log and optionally 268 resets some fields in the <filename>pg_control</filename> file.</para></sect3> 253 269 254 270 <sect3><title>pg_restore</title> … … 270 286 271 287 <sect3><title>postgres</title> 272 <para><command>postgres</command> is a single user database server, generally used for273 debugging.</para></sect3>288 <para><command>postgres</command> is a single user database server, generally 289 used for debugging.</para></sect3> 274 290 275 291 <sect3><title>postmaster</title> 276 <para><command>postmaster</command> is the multi-user database daemon.</para></sect3> 292 <para><command>postmaster</command> is the multi-user database daemon.</para> 293 </sect3> 277 294 278 295 <sect3><title>psql</title> … … 280 297 281 298 <sect3><title>vacuumdb</title> 282 <para><command>vacuumdb</command> compacts databases and generates statistics for the283 query analyzer.</para></sect3>299 <para><command>vacuumdb</command> compacts databases and generates statistics 300 for the query analyzer.</para></sect3> 284 301 285 302 </sect2>
Note:
See TracChangeset
for help on using the changeset viewer.