Changeset 785d4d91 for content/databases
- Timestamp:
- 02/08/2004 05:08:32 PM (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, v5_1, v5_1-pre1, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
- Children:
- 1f686d2
- Parents:
- 3efe4ba
- Location:
- content/databases/postgresql
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
content/databases/postgresql/postgresql-config.xml
r3efe4ba r785d4d91 30 30 start) 31 31 echo "Starting PostgreSQL daemon..." 32 32 su - postgres -c '/usr/bin/pg_ctl start -W -D /var/pgsql/data \ 33 33 -l /var/pgsql/data/logfile -o "-i" ' 34 34 evaluate_retval … … 38 38 echo "Stopping PostgreSQL daemon..." 39 39 /usr/bin/pg_ctl stop -m smart -D /var/pgsql/data 40 40 evaluate_retval 41 41 ;; 42 42 -
content/databases/postgresql/postgresql-desc.xml
r3efe4ba r785d4d91 23 23 <command>pg_resetxlog</command>, 24 24 <command>pg_restore</command>, 25 <command>pgtclsh</command>, 26 <command>pgtksh</command>, 27 <command>pltcl_delmod</command>, 28 <command>pltcl_listmod</command>, 29 <command>pltcl_loadmod</command>, 25 30 <command>postgres</command>, 26 31 <command>postmaster</command>, … … 28 33 <command>vacuumdb</command>, 29 34 <filename class="libraryfile">libecpg</filename>, 35 <filename class="libraryfile">libpgtcl</filename>, 36 <filename class="libraryfile">libpgtypes</filename>, 30 37 <filename class="libraryfile">libpq</filename> and various charset 31 38 modules.</para> … … 111 118 <command>pg_dump</command>.</para></sect3> 112 119 120 <sect3><title>pgtclsh</title> 121 <para><command>pgtclsh</command> is a <application>Tcl</application> 122 shell interface extended with 123 <application>Postgre<acronym>SQL</acronym></application> database access 124 functions.</para></sect3> 125 126 <sect3><title>pgtksh</title> 127 <para><command>pgtksh</command> is a 128 <application>Tcl</application>/<application>Tk</application> shell 129 interface extended with 130 <application>Postgre<acronym>SQL</acronym></application> database access 131 functions.</para></sect3> 132 113 133 <sect3><title>postgres</title> 114 134 <para><command>postgres</command> is a single user database server, generally used for -
content/databases/postgresql/postgresql-inst.xml
r3efe4ba r785d4d91 7 7 make && 8 8 make install</command></userinput></screen> 9 10 <note><para>If you are upgrading an existing system and are going to 11 install the new files over the old ones, then you should 12 back up your data, shut down the old server and follow the 13 instructions in <ulink 14 url="http://www.postgresql.org/docs/7.4/static/install-upgrading.html">the 15 official <application>Postgre<acronym>SQL</acronym></application> 16 documentation</ulink>.</para></note> 9 17 10 18 <para>Initialize a database cluster with the following commands:</para> … … 18 26 19 27 <screen><userinput><command>su - postgres -c '/usr/bin/postmaster -D /var/pgsql/data > \ 20 /var/pgsql/data/logfile 2>&1 &'</command></userinput></screen>28 /var/pgsql/data/logfile 2>&1 &'</command></userinput></screen> 21 29 22 30 <para>Now we can create a database and verify the installation:</para> 23 31 24 <screen><userinput><command>su - postgres -c '/usr/bin/createdb test' 32 <screen><userinput><command>su - postgres -c '/usr/bin/createdb test' && 25 33 echo "create table t1 ( name varchar(20), state_province varchar(20) );" \ 26 | (su - postgres -c '/usr/bin/psql test ') 27 34 | (su - postgres -c '/usr/bin/psql test ') && 28 35 echo "insert into t1 values ('Billy', 'NewYork');" \ 29 | (su - postgres -c '/usr/bin/psql test ')36 | (su - postgres -c '/usr/bin/psql test ') && 30 37 echo "insert into t1 values ('Evanidus', 'Quebec');" \ 31 | (su - postgres -c '/usr/bin/psql test ') 38 | (su - postgres -c '/usr/bin/psql test ') && 32 39 echo "insert into t1 values ('Jesse', 'Ontario');" \ 33 | (su - postgres -c '/usr/bin/psql test ') 34 40 | (su - postgres -c '/usr/bin/psql test ') && 35 41 echo "select * from t1;" | (su - postgres -c '/usr/bin/psql test')</command></userinput></screen> 36 42 -
content/databases/postgresql/postgresql-intro.xml
r3efe4ba r785d4d91 24 24 <sect3><title><application>Postgre<acronym>SQL</acronym></application> dependencies</title> 25 25 <sect4><title>Optional</title> 26 <para><xref linkend="readline"/>, <xref linkend="Python"/>, <xref 27 linkend="openssl"/> and <xref linkend="Linux_PAM"/> 26 <para> 27 <xref linkend="readline"/>, 28 <xref linkend="Python"/>, 29 <xref linkend="tcl"/>, 30 <xref linkend="tk"/>, 31 <xref linkend="openssl"/>, 32 <xref linkend="Linux_PAM"/>, 33 <ulink url="http://www.pdc.kth.se/kth-krb/">krb4</ulink> or 34 <ulink url="http://web.mit.edu/kerberos/www/">krb5</ulink>, 35 <ulink url="http://ant.apache.org/">Ant</ulink> and 36 <ulink url="http://rendezvous.sourceforge.net/">Rendezvous</ulink> 28 37 </para></sect4> 29 38 </sect3> -
content/databases/postgresql/postgresql.ent
r3efe4ba r785d4d91 6 6 <!ENTITY postgresql-desc SYSTEM "postgresql-desc.xml"> 7 7 <!ENTITY postgresql-version "7.4.1"> 8 <!ENTITY postgresql-download-http " ">9 <!ENTITY postgresql-download-ftp "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar. gz">10 <!ENTITY postgresql-size " 11MB">8 <!ENTITY postgresql-download-http "http://gd.tuwien.ac.at/db/postgresql/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> 9 <!ENTITY postgresql-download-ftp "ftp://ftp.fr.postgresql.org/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> 10 <!ENTITY postgresql-size "9.6 MB"> 11 11 <!ENTITY postgresql-buildsize "86 MB"> 12 12 <!ENTITY postgresql-time "1.74 SBU">
Note:
See TracChangeset
for help on using the changeset viewer.